How to create Daily and monthly aggregated cubes from same model

[UseCog]

Hi guys,

I am looking to make my existing transformer cube as 2 different cubes by providing the daily information for the current year in one cube and the second cube which provides a monthly summary information till last year. can someone suggest me the best way to achive this. I cant create this using time based partitioned cube because I am using more than one time dimension. Also I am not interested to add a filter in the FM model as this time dimension is confirmed and used for many other models.

I would be happy to get this from the same model, Any more thoughts than creating two different models

Thank you

Regards

[twlarsen]

Could you switch the source of the cube to be a report based off of the FM model?  In the report you could just add that filter.

[UseCog]

Thanks for your reply mate,

I am struggling to understand how i can add 7-8 dimensions and fact into a report