dbTalk Databases Forums  

How to define these calc measures and in MDX

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


Discuss How to define these calc measures and in MDX in the microsoft.public.sqlserver.olap forum.



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

Default How to define these calc measures and in MDX - 05-16-2004 , 06:22 AM






I have the following calculated measures for forecast to be defined
from the forecast measure.

Forecast1 forecast for currentPeriod (Period is a dimension like
200301)
Forecast2 forecast for currentPeriod+2 (Period is a dimension like
200301)
Forecast3 forecast for currentPeriod+3 (Period is a dimension like
200301)
Forecast4 forecast for currentPeriod+4 (Period is a dimension like
200301)
Forecast5 forecast for currentPeriod+5 (Period is a dimension like
200301)
Forecast6 forecast for currentPeriod+6 (Period is a dimension like
200301)


Similaryly I have a dimension called CalMonth which as a property
called daysinmonth I want to define the following derived dimensions:

Mth1 = Days in currentmonth
Mth2 = Days in Currentmonth + 1
Mth3 = Days in Currentmonth + 2
Mth4 = Days in Currentmonth + 3
Mth5 = Days in Currentmonth + 4
Mth6 = Days in Currentmonth + 5

Please advise how I can implement in this in AS2K.

Thanks
Simon

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.