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?