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

Adding "Current rolling 12m" to Cognos reports

Started by NewDeveloper, 04 Dec 2014 05:19:55 AM

Previous topic - Next topic

NewDeveloper

Hi All,

New to the forum so please forgive me!

Im trying to use a 'Current rolling 12m' date consolidation from a date dimension in Cognos reports and its showing no values for metrics which are displayed as %'s - for example 'Return on Equity'.

In TM1 I have a date dimension which also hosts period calculation consolidations. One such consolidation is 'Current rolling 12m', which is a roll up of 'Rolling 12m to <month><year>'.

When viewing data in TM1 the Rolling 12m to Oct 2014/15 shows the values (%'s) I expect for a number of ratios, whereas the parent consolidation ('Current rolling 12m') shows all %'s as either ".0%" or "0.0%". This (I believe) may be the root cause of the Cognos report issue I have.

Anyone experience a similar issue? Or better still know how to resolve this?

Thanks in advance for your suggestions and feedback!

Update: Has this stumped everyone? Or have I inadvertently offended the forum?