TM1 Forum

Posted: **Mon Feb 01, 2010 11:45 pm**

ok I'm pulling out the last of my hairs!

I have a cube where the data is loaded against a date yyyy-mm-dd and there are string attributes held against each date for month and year (ie Apr and 2009/10)

i want to be able to send the data to a smaller reporting cube which has month and year dimensions instead of the date by using a rule.

Any help greatly welcomed

Posted: **Tue Feb 02, 2010 12:33 am**

You'll need to have some consolidation points in the Date dimension at month level if there is no 'Day' in the smaller reporting cube. For easy of use you should make those consolidations match up to the element names in the reporting cube. E.g. Apr 2009/10

Then the rule in your reporting cube will be

Code: Select all

['Value'] = N: DB('DataCube', !Dim1, !Month | ' ' | !!Year, !Dim3, 'Value');

The feeder from the data cube will be

Code: Select all

['Value' => DB('Reporting Cube', !Dim1, attrs('Date', !Date, 'Month'), attrs('Date', !Date, 'Year');

For more specific help, can you please post the dimension structure of your two cubes.

Martin

TM1 Forum

date to month and year rule

date to month and year rule

Re: date to month and year rule