I have a model that using the relative time for time dimension to generate the current month automatically. After I have add in a few new data source, the new data source is the same format as some old data source, the current month generated differently.
1. The old model generate the cube with the latest sales values month as the current month even there is budget value in other latest month. Eg. Sales is up to Jan 2009 but budget is until Dec 2009.
2. The new model generate the cube with the latest budget values month as the current month which is Dec 2009.
I need the latest sales values month as current period. Please help.
Thank you.
Regards,
Mew Yeen
In the properties for each data source in your transformer model, there is an checkbox called something like 'sets current period'. Make sure this is only checked for the data source that you do want to generate the current period.
Hope this helps.
J
Hi J,
Thank you very much for the information.
By the way, I have changed the data source sequence where I move the data source that I need to be use as the current month base to the bottom of the data source list and it works.
Thanks.
Mew Yeen