how to load data from ods to cube

[Former Member]

Hai all ,

how to load adata from ods to cube in BI

please ineed step by step

Points will be assigned

regrds,

Aravindan pagadala

[Former Member]

thank u very much it is very help ful

[Former Member]

Hi Aravindan,

The loading process depends on whether you are modeling data in BI7 or BI3.x. Anyways both the processes are as given below

BI3.x :

Once you have created a ODS with a tech name say ZXYZ, in your infosource tab an infosource is automaticalli created with the name 8ZXYZ ( 8 followed by your ODS name in General ). This will act as infosource to your cube. Now please go to ur cube right click on it and say create update rules. Now it will take you to the screen where you have to assign your Infosource. Please give the infosource created from your ODS (8*). Once this is done update rules are created. Activate the update rules. After this the link between your ODS and cube is established. Now right click on your ODS and say 'Update ODS data in Datatargets'. It will get updated

BI7

Right click on your cube and say create Transformation. It asks for a source object and target object. Give source object as ur DSO and target Object as yout Cube. The transformation gets created. Once the transformation is activated. Right click on the cube say create Data Transfer process. It will create a DTP. Now activate this DTP and run it the data gets updated

Regards,

Pramod

[chemicala_srimallikarjuna]

Hi,

Cube to ODS:

1.from context menu of Infocube--->Create export generate datasource

2.this generated data souce will be available under 'datamarts' of Indosource tree

it is 8IC01_C01 if your cube is IC01_C01.

3.add 0recordmode to this Infosource.

4.from Context menu of ODS->create update rules>here you can map as required.

5.Create infopackege to load data.

while loading from ODS to cube,you need not generate export datasouce as it is created automatically after activation of ODS.follow the same steps.

ODS-CUBE :

o First prepare a flat file in Microsoft excel sheet for master data and transaction data and save it in .CSV format and close it.

o First select info objects option and create info area then create info object catalog then char, & key figure. Then create ‘id’ in Char, Name as attribute activate it then in key figures create no and activate it.

o In info sources create application component then create info source with direct update for master data and flexible update for transaction data. The flat files would be created for master data create info package and execute it.

o For transaction data go to info provider then select the file right click on it then select option create ODS object. Then a new screen opens give the name of the ODS and create other screen opens then drag character to key fields.

o Activate it then update rules it will give error to it then go to communication structure and give 0Record mode then activate it then go to update rules it will activate it.

o Then go to info source then create info package then external data then processing update, Data targets then the scheduling then click start then the monitor.

o Then other screen opens there we can see if we doesn’t able to see the records then come back to the info provider right click on it then other screen opens then select the option activate data in ODS then a screen opens.

o so select the option QM where it would be in a yellow co lour then by double click then another screen opens then select green color option then click continue it and it comes to the previous screen then select the option and click save it would be underneath of it just click it up and close it.

o Then come back to the main screen to the info source to the info package go to the package and right click on it then a screen opens then click schedule without distributing any of the tab directly click the monitor tab. Then refresh it until the records come to the green.

o Once it is green then click data target and see the file executed.

o Now go to the info provider then a right click on the file name then create info cube. Then a new screen opens and gives the name and activates it. The drag the key figures to the other side, time characteristics to the other side, and chacetristics to the other side.

o Then create the dimension table then assign it and activate it .Then go to file name right click on it then select the option create update rules select ODS option and give the file name and activate it .

o Then come back to the main screen and refresh it. Whenever you see 8 file names you will know that it is undergoing the data mart concept.

o In the main screen click ODS file right click then a pop up screen opens select the option update ODS data target. Then another screen opens in that we are able to see 2 options full update, initial update then select initial update.

o Then another screen opens info Package there the external data , data targets , scheduler select the option later in background option then a another screen opens just click immediate then click save automatically it closes then click start option.

o Then select monitor option then the contents then the field to be elected then the file to be executed.

Regards

CSM reddy