on 12-17-2009 3:54 PM
Folks,
We are planning to buy TDMS for our BI 7.0 system and wondering how TDMS will work for Cubes, aggregates? Is this tool will work exactly like system copy? I am not able to find good documentation on TDMS for BI specific.
Can some one share experience with this tool.
Thanks,
Kumar
Resolved
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
TDMS BI will reduce the infocubes. It will apply the specified timeslice and the infocube fact tables are reduced based on time characteristics. After the infocubes are transferred to the receiver system, TDMS will rebuild the aggregates. This will ensure that the infocube data is in sync with the aggregates.
Hope this answers the above questions.
Regards,
Rajeev
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I'm also looking for information on this. We know that TDMS can offer reductions on Info Cubes and ODS objects. The question is, what is the impact if a customer is doing aggregates on the InfoCubes? How does TDMS handle this?
>>
Relational aggregates allow you to improve the performance of BI queries when data is read from an InfoCube. The data of a BI InfoCube is saved in relational aggregates in an aggregated form. Relational aggregates are useful if you want to improve the performance of one or more specific BI queries, or specifically improve the performance of reporting on characteristic hierarchies.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.