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

Previous Year Error with TM1

Started by Mfg, 17 Mar 2016 02:35:04 AM

Previous topic - Next topic

Mfg

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


MFG