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 |
|
shanmugaraj
Posting Yak Master
219 Posts |
 Posted - 2011-12-09 : 22:52:03
|
| HiI am New to MDX calculation. In my code, i have created an MTD calculation as scope variable.When i see the data without Show non empty cells i get error.Could you please let me know how to add the non empty or CoalesceEmpty in the calculation below./* PY MTD */SCOPE ([Time].[Time Hierarchy].MEMBERS, [Deviation Analysis].[Deviation Analysis].[PY MTD]); this = AGGREGATE(MTD(PARALLELPERIOD([Time].[Time Hierarchy].[Year],1,[Time].[Time Hierarchy].CurrentMember)), [Deviation Analysis].[Deviation Analysis].[CY]); END SCOPE;THANKSSHANMUGARAJnshanmugaraj@gmail.com |
|
|
|
|
|
add the non empty or CoalesceEmpty