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