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 is SUMRT?
What do you understand by start and update routine?
what are the drawbacks of ods?
Describe the new BW 3.x authorizations?
Which transaction on R/3 shows the transactions with pending processes for update?
What is the benefit of using bw reporting over sap reporting?
what is the data model and how it is use ?
What are the objects that support variables?
Where do we use write optimized dso?
Give examples of data sources that support remote cubes?
Explain business blueprint stage. What do you do here?
Explain about the dimension in the warehouse?
How do you do Currency translation in SAP BW ?What are the settings that needs to be done?
What is a constant selection?
What are the Oracle specific tuning should be done?