I need to add a filter to a measure dimension to return only the last value of the fact table based on the time level the report is at. So for example with GO Sales Warehouse sample model, I've added this filter to 'Sales fact':
[Sales and marketing data].[SLS_SALES_FACT].[ORDER_DAY_KEY] = maximum([Sales and marketing data].[SLS_SALES_FACT].[ORDER_DAY_KEY] for roleValue('_businessKey', currentMember([Dimensional view].[Time dimension].[Time dimension] )) )
So I want it to substitute the business key column of whatever level of this hierarchy appears in the query, but when I try to save this change, I get this error:
BMT-MD-0003 GEN-ERR-0016 The 'currentMember' function is not supported in the context in which it is used.
GEN-ERR-0009 Data source type(s) '' - Function 'realDataMode' is not supported in 'NoDataModeProvider'.
Is it possible to reference the current level or member of a level in a model measure dimension in order to do something like this? Is so, then how?
Thanks.