PeriodsToDate on TM1 cube with Report Studio

wwpsy

Hi,

I am using Cognos Report Studio with TM1 cube

I have a requirement to show the numbers for all the previous years in the cube based on a year selection. I thoght this is easy (coming from a transformer cube background) and used periodsToDate function. But the following function just displays the selected year instead of the set of previous years till the selected year.

periodsToDate ( [Cube].[Dimension].[Hierarchy].[Year], [Selected Year])

Can anybody tell me if there is any issues for using periodsToDate function on TM1 cube, or may be I am missing something

Thanks in advance,
Siyad

tianya369

Unlike Powerplay & Transformer TM1 cubes have no concept of a special time dimension and therefore no "built in time intelligence".  Time dimension(s) are just like any other dimension.  Reporting of YTD, rolling MAT, etc are typically handled via rollups within the time dimensions and vs LY type measures typically via rules or a combination of rules and rollups.

This is a significant disadvantage of TM1 vs Transformer as adding this kind of functionality is more or less roll your own (TM1 does have it's advantages though.)  This can be a bit of a learning curve.

670648633

Thanks for your reply and I will try to get the rollup done in the TM1 cube,

So this means that I cannot use the typical date functions like periodsToDate() on a TM1 cube to get a set of all the previous years in the system or YTD etc...

玩美123

You can still use any valid MDX commands in Report Studio as MDX is unaware of time as well.

The trick to remember with OLAP is that you are always dealing dimensions and therefore are using logic based on sets of members or levels to get what you want.  Functions like descendants and head, tail, except, etc. can all be combined to dynamically derive the correct member set for reporting.