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
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.
Thanks for your reply mate,
I am struggling to understand how i can add 7-8 dimensions and fact into a report