date to month and year rule

[scrummyd]

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

[Martin Ryan]

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