how to create info package from ods to ods then to infocube
for process chain

Answer Posted / k m r

lets Say your updating from ODS A to ODS B and then sub
sequently to CUBE

Create an info package under the infoorce starts as
8ODSA,choose data target as ODS B under targets tab of info
package and create one more info package under info source
8ODSB ,choose data target as Infocube under data target
tab if its BW 3.5

if its BI 7.0
Create DTP between ODS A and ODS B
and ODS B to CUBE

Create a process chain as shown below

if its BI 7.0
Start --> DTP to ODSB from ODS A -->activate ODS B---
>Delete index -->Deactivate Aggregates --> DTP to Cube From
ODS B -->create indexes -->rollup ---> compression

if its BW 3.x

START --->infopak to ODS B from ODS A -->Activate ODS--
>delete index --->Deactivate Aggregates -->IP CUBE from ODSB
-->Create Indexes -->rollup-->compression

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the load process and processing?

522


can anyone tell me abt WAD navigation?

1853


Where do you store your custom images (like logos)?

1981


Explain about the dimension in the warehouse?

512


What are the elementary tests you can run?

1542






What are the steps to do the converting from lis to lo extraction.

517


What is the function of the ‘reconstruction’ tab in an info cube?

594


What is rowlevel security ? can u please explain with real time example?

1718


What is the conversion routine for units and currencies in the update rule?

2113


What is the difference between sending a mail to a recipient list compared to sending individual mails via a dynamic loop?

496


What are the Oracle specific tuning should be done?

1326


which object based you created extended star schema?

1178


What is the dimension in bw? How would you optimize the dimensions?

571


what is the difference between pdf and excel format after saving the report?

6006


What is a dashboard in sap bw and how it is created?

554