Consolidate historical data

[dwhcognos8]

Hi All,
I want to Consolidate/Aggregate historical data in TM1 cube which is on day level to monthly level/End of the Month (Except current Quarter) in TM1 cube?

Thanks,
TM1 Guy

[declanr]

Hi All,
I want to Consolidate/Aggregate historical data in TM1 cube which is on day level to monthly level/End of the Month (Except current Quarter) in TM1 cube?

Thanks,
TM1 Guy

That's great... what's the problem/question?

[dwhcognos8]

Hi Declanr,

I want to know how can we do that, using Rules or TI Process?Any Suggestions Please?

Thanks,
TM1Guy

[Duncan P]

Although you don't say so this

monthly level/End of the Month (Except current Quarter)

makes me think you are wanting to aggregate balances. You might try to use the search button in the forum to see how others have done this, e.g. searching on "aggregate balance" or "YTD consolidation" or "current month".

A couple that spring to mind are http://www.tm1forum.com/viewtopic.php?f=3&t=1026 and http://www.tm1forum.com/viewtopic.php?f=3&t=1936. The first of these also shows the level of information that you need to put into the question in order to get a good and helpful response. This is explained in full in the Request for Assistance Guidelines here http://www.tm1forum.com/viewtopic.php?f=3&t=1037.

[rkaif]

You need to create a cube which has Period dimensions (containing the Years and Months) and Day dimension.

See the sample screen shots for Period and Day dimensions.

This should give you a starting point....

[dwhcognos8]

Thanks Rizwan.