WHERE DO YOU STORE THE MASTER DATA IN BI 7.0
Answers were Sorted based on User's Feedback
Answer / george quarranttey
Unlike the older version of BW which uses star schema, BI
7.0 uses the extended star schema. In this, master data is
stored outside the cube.
In the star schema, both master data and transaction data
resides inside the cube bringing many problems: master data
not reusable, computing of alphanumeric values and analysis
being limited.
In BI 7.0 Master data is stored outside the cube which
makes it reusable, and alphanumeric values can be computed
and many more analysis are possible.
George Q.
Is This Answer Correct ? | 20 Yes | 1 No |
Answer / san
Generally we use InfoObjects to Store master data.They
havent asked about the cubes are anything like that.Just
asked about the storage so I think InfoObjects is the answer
for that
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / babu
In characteristics.For this in infopriver tab under modeling
right click on Infoarea and press INSERT CHARACTERISTIC AS
INFOPOVIDER OPTION.THEN this characteristic enable to store
master data
ex:0material,0vendor,0customer
Is This Answer Correct ? | 13 Yes | 6 No |
Answer / bandari suresh
In Older version of BW which uses star schema, BI
7.0 uses the extended star schema. In this, master data is
stored outside of the cube.
In Older version of BW inside of the cube so that to facing
some of problems, they are
1. master data cannot be reused
2. performance is very slow
3. limited Analysis
In advance version of BI master data stored outside of the
cube.
1. So master data is Reused
2. We having the Alphanumeric values so Performance is increased
3. And More analysis is Posible
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / uday
Master data stores in Master data tables like Attribute ,Text and Hierarchy .
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / harish
WE Have Following Master in Sap B1:
Item Master
Bp master
Whse Master
Employee Master
Tax Master
Etc etc.....
You Can see All this master as Per MOdule..
Is This Answer Correct ? | 1 Yes | 12 No |
Why sap business one?
What are the features of sap business one include?
can we have separate cubes for Delivery & Billing Data Sources.
What is the value returned by a method when it executes successfully?
How we know, whether we have to use DSO or Infocube for particular data source?
Difference between UNION and UNIONALL
1 Answers Axtria, ITC Indian Tobacco Company, TCS,
What are the complex reports you developed in Business Objects.Please tell me 3 reports you developed and the complexity you faced and the solution
1 Answers GHG, KPIT, Mind Tree, NTT Data,
Why we have only 16 Dimension tables in a cube.Is there any reson.Is it a limitation?
4 Answers Enteg Technologies, IBM, Infosys, TCS, Wipro,
your process chain link with ABAP Program,suppose your ABAP Code need some changes how you do this(your process chain is in running stage)
What is the value returned when any method of a di api object executes successfully?
i am raj i have attended lot of interviews but i could not get job. the interviwer asking me some real time scanrions please tell me any one . 1. expalin u have created any customize cube? 2. what is ur exp in bex and wad? 3. howmany reports u have created? give one scenario abour calculated key figure and formula? 4. tell me some recently what u have done tickets give me 2 tickets explain briefly? 5.what they (off shore team) have done ?
) Why is there a restriction of 16 Dim tables in an Info Cube and 16 key fields in an ODS.