Trying to create a simple cross tab with months along the top and products along the side with Measured in the intersection that will be changed based on prompt. I have 2 prompts, 1 for Year to change the months and 1 for Measures to change the measures to display in the crosstab. Example attached.
We are using Cognos 10.1.1 with a SSAS 2005 Olap Cube. We are changing from ProClarity to Cognos. This was possible in ProClarity but I can’t seem to figure out how to get those values to change in the Crosstab via Cognos.