Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Joozh
Posting Yak Master
145 Posts |
 Posted - 2004-05-05 : 08:07:21
|
| Hi, I want to see the YTD sales regardless of what time period I have selected in my Time Dimension. For example if the to-date total Sales are $1000, then even if I have selected March-2004 in my Time Dimension, I still want to see $1000 as YTD.Using the built-in "Business Center" functionality of MSDA (Microsoft Data Analyzer), there is something labelled as "Year To Date-BC-(e)" and this gives me the desired results. BUT I do not like the label and want to change it... HOwever I can not get the MDX which this built-in uses... I tried the following but this does not give me the YTD sales and instead gives me the YTD sales at/till the selected time period: iif(Current dimension.name=Open Time dimension.name,null,(Length measure,Open Time dimension.currentmember))I'll appreciate your help. MANY TIA!Thanks & Regards.-J |
|
|
|
|
|
Urgent MDX Question