Help Custom Rollup in AS 2005 -
05-11-2006
, 10:28 PM
Hi there,
I have a Time dimension which has a THier hierarchy as show in follows:
Year->Quarter->Month
What am I going to do is to enable custom rollup. I want the all
measures show the quantities of the last quarter at the Year Level. And
all measures show the quantities of the last month at the Quarter
Level. I tried to add a column named MDX of Time table and assigned all
rows' value as "TIME.THier.CurrentMember.LastChild". Then I edit Time
dimension, and set customerollupcolumne properties of Year and Quarter
to "MDX". I can deploy my cube to AS 2005, however, when I browse my
cube, each measure has empty result instead of its really quantity.
What's wrong with my steps? How could I get the correct values?
Best Regardly |