Cloning a Cube and copying data only
Posted: Wed Jul 04, 2012 7:03 pm
Hi All,
I am trying to copy ALL data from one cube to another using a TI process. The cubes are exactly the same but one excludes ALL the rules.
The one cube has over 1500 lines of rules which (I believe) is hindering the performance of BI Report which sources from the cube. So my solution is to replicate the cube without rules to see if the performance will improve. I am using CX9.5 and am aware that BI & TM1 under this version aren't as efficient as the latest and greatest.
I was hoping:
1. If any one has a TI script that I could reference to clone a cube? OR
2. Figure out how to include more than one measure in a cube view through TI
As always, thanks for your input!
Lance
I am trying to copy ALL data from one cube to another using a TI process. The cubes are exactly the same but one excludes ALL the rules.
The one cube has over 1500 lines of rules which (I believe) is hindering the performance of BI Report which sources from the cube. So my solution is to replicate the cube without rules to see if the performance will improve. I am using CX9.5 and am aware that BI & TM1 under this version aren't as efficient as the latest and greatest.
I was hoping:
1. If any one has a TI script that I could reference to clone a cube? OR
2. Figure out how to include more than one measure in a cube view through TI
As always, thanks for your input!
Lance