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

tuple error on crosstab with nested columns

Started by phantomluvs, 04 Sep 2015 12:07:39 PM

Previous topic - Next topic

phantomluvs

Calling all Cognos OLAP / MDX Gurus for help,
I am hit with Cognos RS tuple error. Source is TM1.

I have a crosstab with nested columns and the report is budget vs actual with variances and & differences.  The variance of $$ for months works fine, whereas YTD $$ variance doesn't work for some reason. It only works if I had code the member.
Please refer to the attached image. 

Please feel free if this is not clear or needs more explanation.

Formula Used for Month Calc:
parallelPeriod ([Monthly Income Statement].[t_time].[t_time].[Month],0,[Monthly Income Statement].[t_time].[t_time].[Month]->?Month?)

Formula Used for YTD Calc:
aggregate(currentMeasure within set ( periodsToDate([Monthly Income Statement].[t_time].[t_time].[Year], (parallelPeriod ([Monthly Income Statement].[t_time].[t_time].[Month],0,[Monthly Income Statement].[t_time].[t_time].[Month]->?Month?)))))

Error code:
XQE-PLN-0264
The argument at position 1 of the function 'tuple' is invalid in data item 'YTD Var $' of query 'ReportQuery_ForQrd_ReportQuery.5', expected one of the following types: 'member, measure'.




phantomluvs

I figured the solution by changing the aggregate to member