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.
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.