cancel
Showing results for 
Search instead for 
Did you mean: 

Cube to Cube data loading

Former Member
0 Kudos

Daer Experts,

Request you to help me to know, how to load data from cube to cube in BI 7.0.

Regards,

Ramesh-Kumar.

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Dear All Experts,

Thanks for valuable Info.

Former Member
0 Kudos

Hi Ramesh......

The process is same as DSO to cube.......infact in BI 7.0 the loading process is same in all the cases..

1) First you have to crreate the Transformation....Right click on the Target Cube "Create Transformation"....Mapping will be done automatically......if you want to change some thing you can do it manually...........or you can write field level routine, Start Routine or End Routine as per your requirement if you want to manipulate the data.......

2) Then again Right Click on the Target Cube --> Create DTP.......There Select The Object Type as Cube and then the Source Cube name.......Create Full or Delta as per your requirement.......

Regards,

Debjani.....

Former Member
0 Kudos

Hi Ramesh,

If you are using BI7 flow, you need to load the data from cube to cube using DTP.

If you are in BW3.5 flow, then right click on the cube--> Additional Functions --> Update 3.X data to Targets.

Hope it helps!

Regards,

Pavan

Former Member
0 Kudos

Hello Ramesh,

For loading data between cube to Cube, first select the source or target cube then right click and select create transformations, then mappings will be done automatically, for any field mapping is not done use the required rule type and then map and activate the transformations.

Once it is done create DTP and then start performing loadings

Thanks

PT

Former Member
0 Kudos

Hi Ramesh,

if you want to load data from existing cube to a new cube, please follow the below steps.

> create a new target with specified fields, cube in our case

> create transformation and DTP in the source Cube, and specify the target as ur new cube.

> save and activate

> execute your DTP, data ll be loaded to the target

please let me know if you need more help regarding this.

BR

adlin