youngcougar
Programmer
I've looked and looked....How do I create a calculated member of % change based on any dimension?
I have a sales cube that has the following dimensions:
Product
Quarter
Period
Year
Location
The measure is 'Sales'. I would like to apply the % change to any of the above dimensions based on any one of the time dimensions. so if the users selected 'Years' the % change would show the change for 2003, to 2004. If the Users drilled down to period the % change would change accordingly. Is this doable? I will go out and by the book by George as many of you think this is a good ref.
thanks in advance
I have a sales cube that has the following dimensions:
Product
Quarter
Period
Year
Location
The measure is 'Sales'. I would like to apply the % change to any of the above dimensions based on any one of the time dimensions. so if the users selected 'Years' the % change would show the change for 2003, to 2004. If the Users drilled down to period the % change would change accordingly. Is this doable? I will go out and by the book by George as many of you think this is a good ref.
thanks in advance