MS SQL Server OLAP - Union of Sets with Different Dimensionality

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Union of Sets with Different Dimensionality

Raja Nadar

2005-11-28, 3:24 am

Hi All,

I have a Dimension : [Web Site] with members: [Web Site ID], [Web Site
Name], [Web Site IP] etc.
I need to display a single column consisting of All Web Site IDs followed
by all Web Site Names,
with [Web Site ID]s on the rows. The UNION Function fails due to
difference in Dimensionality.

E.g. Site ID 1,2
Site Name a,b

I need:
ID IDorName
1 1
2 2
1 a
2 b

Is there any way of accomplishing this ?

Sponsored Links