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

DMR report - filtering measures differently in one query

Started by keating101, 27 May 2020 04:28:08 PM

Previous topic - Next topic

keating101

Hello

I am trying to write a straight forward report in Cognos 11 in a DMR model.
I don't have access to framework manager, so I am limited in what has been provided within the Package (controlled by the licensed software reseller).

I want two columns containing 'Actual MTD' and 'Actual YTD'. However there is only a measure 'Actual'.
how can I achieve this within the one query?
Period, period number and year is mapped in the package, but I don't know how to filter each measure individually.

in a relational report, I can achieve this by creating 2 queries (one for MTD, one for YTD), and then creating a Union.

thankyou in advance
Shaun