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 |
Can we format BEx reports/graphs using HTML and CSS
How types of reports we can create in BOBJ
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,
Hi everybody, This is Srinu,recently i got selected for a small comapny with sap b1 but i was new to the technology.I knew c#.net,asp.net,Sql server 2005.My question is what are the pre-required knowledge to learn SAP B1 please suggest me. Thanks & Regards.
What is a/p invoice ?
In sap business one sdk, which object is used for executing sql queries and stored procedures ?
Can we load the datatable directly using sql query ?
How is sap business one implemented ?
For performing heavy duty operations what is suitable di api or di server ?
1. We have standard info objects given in sap why you created zinfo objects can u tell me the business scenario
Hi, I am currently working in midsized company in SAP Business One after getting two years experience can i move to MNC company with SAP B1 or can i change technology to SAP ABAP na Please suggest me......
can any working guy help me...by explaining me about any twop reports which u have created.....on sales and purchase