dbTalk Databases Forums  

Help Custom Rollup in AS 2005

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Help Custom Rollup in AS 2005 in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
tomchu
 
Posts: n/a

Default 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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.