Hai All,
I have a cube say C01 with some objects. The source system is now revised and the new data from the date of revision has to be loaded to a new cube C02. The C02 and C01 have many objects in common but as there are changes in the source system, I have to make a new cube.But here is another imporant thing, I want to still report on the C01 on what ever data we have and stop loading data from now on. I am not deleting the data in C01.
Now here are my questions:
1. can I use the same objects in C02 that I used in the C01?
2. If I want to make a multiprovider involving both the cube C01 and C02, then is it possible? Does the data gets messed up in reporting? Or do I need to make all my objects time dependent so what ever the time we give, if its before today, it gets from C01 and if its after today it would be from C02...? I think making objects time dependent hampers performance. At the same time, I don't want to create too many objects.
3. Can I make a common report to report on the multiprovider that shows both the C01 and C02 data?
I apperciate if somebody could answer my questions.
Thank you very much.
Message was edited by: Visu Venkat