dbTalk Databases Forums  

Different time aggreation for DTD vs YTD measurements

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


Discuss Different time aggreation for DTD vs YTD measurements in the microsoft.public.sqlserver.olap forum.



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

Default Different time aggreation for DTD vs YTD measurements - 03-21-2005 , 08:27 AM






Hi,

I have a time dimension (Time: Year-Month-Day) and to different kind of
Measurements YTD_1, YTD_2 as well as DTD_1, DTD_2.

How is it possible in the time dimension a customized roll-up which
shows for YTD_1 & YTD_2 on month & year level the lastchild of the day
level without aggregation but the DTD_1 & DTD2 aggregated on Month &
Year level.

thanks for your suggestions

best regards
BB


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.