Cloning a Cube and copying data only

Post Reply
LanceTylor
Posts: 66
Joined: Mon Feb 27, 2012 12:37 am
OLAP Product: TM1
Version: 10.2.2 Fix Pack 4
Excel Version: 2010

Cloning a Cube and copying data only

Post by LanceTylor »

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
kpk
MVP
Posts: 214
Joined: Tue Nov 11, 2008 11:57 pm
OLAP Product: TM1, CX
Version: TM1 7x 8x 9x 10x CX 9.5 10.1
Excel Version: XP 2003 2007 2010
Location: Hungary

Re: Cloning a Cube and copying data only

Post by kpk »

you will find the following site (and the sample codes) very useful:
http://bedrocktm1.org/
Best Regards,
Peter
Post Reply