Hi,
I have this MDX statement that produces my sites the way I want to see them in SSMS.
My problem is when I import from my cube into a SQL2012 table it breaks 'SITES' out from the hierarchy.
It doesn't look like that in SSMS - the way it is in SSMS is it has one column called 'SITES' and it lists them straight down.
When I import in to SQL it breaks out all of the levels of my SITE and creates all these new columns.
How do I stop that?