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 3 sap defined dimensions?
What is ?predefined characteristics??
Define the upgrade steps to 3.x?
What are value sets?
What is the precaution you should take when archiving?
What makes it more advanced than sap business warehouse (sap bw) 7.5?
Explain bp master data?
How do you access to source system data in bi without extraction?
as you said you have worked on cubes and ods, which one is better suited for reporting? Explain and what are the drawbacks and benefits of each one?
What do you mean by the term rollup in the sap bw?
How does bex analyzer connect to bw?
When to virtual providers based on dtp?
What all data sources you have used to acquire data in sap bw system?
How to gathering the requirement
What is the use of navigational attributes?