How to prevent end users to use Year, which is insensitive for YTD calculation RRS feed

  • Question

  • Hello All, 

    Here is the question we are facing.

    Let's say you have a standard dimdate table(datekey, fulldate, year, quarter, month, day, isholiday....) And in cube you setup a hierarchy as YQM(Year-Quarter-month). With this YQM hierarchy, you further calculate the measure [YTD Amouont], which probbaly looks like this 

    YTD(Date.YQM.currentMember, Fact.amount)

    The problem here is , for the same name measure--[YTD Amount], it is only sensitive with YQM but not for Year. Sometimes, users do pull out [Date].[Year] and [Fact].[YTD Measure] but as expected, it wont work.

    Any good ideas to prevent this in addition to telling people not do this?

    Or say any way I can make this measure working with both(YQM and Year) maybe even more with Month/day?


    • Edited by Derek Dai Wednesday, May 6, 2015 8:03 PM
    Wednesday, May 6, 2015 8:01 PM

All replies