Viewing 4 posts - 1 through 4 (of 4 total)
I did change this so the table has only 3 records and re-built the cube but it doesn't seem to have an effect on performance...:(
January 9, 2013 at 5:03 pm
Do you need all the measures?
Yes, I need to provide Line of Business in columns of the Pivot Grid.
In addition have you set the attribute relationships correctly on the...
January 9, 2013 at 5:01 pm
Realized I don't need to provide any intersection. Not looking through all 7 million records reduced the query to under a second.
Got it all working.
------------------
set [x] as
{
[Dim Geographic].[LOCATIONID].&[1000007],
[Dim Geographic].[LOCATIONID].&[1000019],
[Dim Geographic].[LOCATIONID].&[1000003],
[Dim...
January 5, 2013 at 11:10 am
Mack - Thanks for this!
Took a while to absorb it since I don't quite have my baby shoes on yet.
It is doing what I need (still...
January 4, 2013 at 4:45 pm
Viewing 4 posts - 1 through 4 (of 4 total)