Hi All,
Year data Drop down and a data deck listening to the years control. Have actual,budget and last year data item as follows:
Actual: Measure
Budget: Measure
Last Year: Tuple(prevMember(currentMember(Year Hierarchy))) as chart series items.
Categories are Revenue,EBITDA etc.,.
Problem: Last Year Values are blank.
I tried nesting last year with year hierarchy to give context to the currentMember() function then i get the following error:
RSV-VAL-0010 Failed to load the report specification. XQE-PLN-0352 The query is not supported. It contains a master detail link '[Year, Month and Customer Data Deck Query].[Year]<=>[Main].[Time]' affecting a hierarchy projected by a relative member function. Consider using parameters in the detail query to specify where the link should be done.
query:"Main"
any help will be appreciated....!!
um with cog 10.2.2