on 04-07-2011 7:24 AM
Daer Experts,
Request you to help me to know, how to load data from cube to cube in BI 7.0.
Regards,
Ramesh-Kumar.
Dear All Experts,
Thanks for valuable Info.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.