cancel
Showing results for 
Search instead for 
Did you mean: 

extracting data from one cube to another cube

Former Member
0 Kudos

Hi All

i have copy the cube1 from another cube2.So i need load the data from cube2 to cube1.

Its is 3.5 data how to do

Thanks

Accepted Solutions (0)

Answers (5)

Answers (5)

former_member188080
Active Contributor
0 Kudos
former_member188080
Active Contributor
0 Kudos
Former Member
0 Kudos

Hi,

At first u have to generate datasource.

select the cube2 and goto context menu. select export generate datasource.

create transfer rules and update rules.

create infopackage and schedule the data.

thanks

Former Member
0 Kudos

Hi

I have to write routine at update rules

to replacing PP16 to FP16.

Can you give sample code

Thanks

Former Member
0 Kudos

Hi Reddy,

To Acheive this no need to write Routine in Updaterules.Instead of writing the routine in update rules, simply we have to use Formula(Ruletype).In Formula so many functions are available so we have to take String functon,under String functions we will use Replace.

Note:writing the routine it decrese the performance.

Former Member
0 Kudos

Hi

Create transfer rules from your source cube2 to your target cube1. Create update rules for each and every infoobject (update rules on the same Infosource as the cube2). Activate them.

The steps to copy the contents of one cube to another:

1. Go to Manage -> Recontruct of the cube1(in your case)

2. Select the "selection button"(red , yellow, blue diamond button).

3.In the selection screen give the technical name of the source cube2, requests ids which you want to load, from & to date.

4. then execute

Hope it works.

Regards,

Shilpa

Former Member
0 Kudos

Hi,

You have to create update rules/transfer rules on new cube cube1 by giving source as old cube2. As it is data mart will be starting with 8 and it is available in info sources tab.

Then create IP in infosource 8cube2 and schedule it.

Thanks

Riyez