Topic
  • 2 replies
  • Latest Post - ‏2014-02-06T21:34:02Z by proprincess
proprincess
proprincess
3 Posts

Pinned topic How to change Cross Tab intersection based on Prompt of Measures?

‏2014-02-06T16:58:27Z |

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.

Attachments

  • rperzul
    rperzul
    62 Posts

    Re: How to change Cross Tab intersection based on Prompt of Measures?

    ‏2014-02-06T17:39:48Z  

    Hi,

    you can do this but it is not very straightforward for a Newbie. Check the following document. It should help.

    http://mecbi.blogspot.de/2010/02/interactive-measure-reports.html

    Regards,

    Ron

  • proprincess
    proprincess
    3 Posts

    Re: How to change Cross Tab intersection based on Prompt of Measures?

    ‏2014-02-06T21:34:02Z  
    • rperzul
    • ‏2014-02-06T17:39:48Z

    Hi,

    you can do this but it is not very straightforward for a Newbie. Check the following document. It should help.

    http://mecbi.blogspot.de/2010/02/interactive-measure-reports.html

    Regards,

    Ron

    Thank you SO MUCH. That is EXACTLY what I needed to do.  I had sort of been doing bits and pieces of what you showed  but I guess I was missing some key components & in the wrong place to make it fully work. 

    Thanks again you made my day!!!