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

Conditional Render of Crosstab Columns

Started by bi4u2, 10 Mar 2014 10:34:40 AM

Previous topic - Next topic

bi4u2

We are on 10.2.1 FP2 and I am working with TM1 (dimensional) data. The package is published using Dynamic Query Mode.

I am trying to conditionally hide certain columns based on a prompt selection. I had tried applying both conditional styles and a style variable to set the 'box type' to None and to set 'Visible' to No. Nothing is working. I think it is because the columns I want to conditionally display are nested below another dimension (Months).

A sample is here

Employees        Month
                        Hours  Labor Cost Hourly Rate

And I want to show Hours/Labor Cost/Hourly Rate based on a Prompt

The error message I get says:

XQE-PLN-0003 Internal Error. The expression has an invalid combinations of hierarchies.

bi4u2

I removed the default measure from the crosstab and now I am no longer getting the error message and it hides the columns, but the problem is that it shifts columns out to the right because the Months dimension is still above the hidden column.