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
What are the load process and processing?
can anyone tell me abt WAD navigation?
Where do you store your custom images (like logos)?
Explain about the dimension in the warehouse?
What are the elementary tests you can run?
What are the steps to do the converting from lis to lo extraction.
What is the function of the ‘reconstruction’ tab in an info cube?
What is rowlevel security ? can u please explain with real time example?
What is the conversion routine for units and currencies in the update rule?
What is the difference between sending a mail to a recipient list compared to sending individual mails via a dynamic loop?
What are the Oracle specific tuning should be done?
which object based you created extended star schema?
What is the dimension in bw? How would you optimize the dimensions?
what is the difference between pdf and excel format after saving the report?
What is a dashboard in sap bw and how it is created?