Hello Ppl,
version: Cognos 10.1.1
db : Relational (DB2)
I have list report and Certain columns in the report need to have trending arrows based on values from previous month's data.
Something like arrow upward when current month > previous month and downward arrow when prev month > current month.
Is this possible using the report studio.
Your help will be greatly appreciated.
Thank you
Yes - definitely possible. If your package is modelled as DMR, it will be much easier to author this report than if your package is modelled as pure relational.
With a DMR package, you can simply code a query calculation to provide the tuple of the measure and the prior month (derived using a lag() function, for example) then compare this with the tuple of the measure and the current month. With a relational package, you will need to add an extra query to retrieve the prior month values and join this to your main query.
Regards,
MF.