If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

how to use hierarchy level in model itself

Started by paulmaric, 07 Jul 2009 08:14:34 AM

Previous topic - Next topic

paulmaric

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.