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 have separate cubes for Delivery & Billing Data Sources.
hi frnds dc's suma.could u tell me this one.(suma.sapbi@gmail.com).I have 2 Data Sources sales and Billing.I have 2 Cubes called 1.sales cube and 2.Billing Cube with its own Data,Now i want to add Sales Data to Billing Cube.How Can it Possible,Can you any one Explain?
5 Answers Cap Gemini, HCL, IBM,
What is difference between matrix and grid in sap business one?
what is cumulative and non-cumulative key figures in sap bi?
What is di server in sap business one ?
What is dtw in sap business one?
Hi Friends, 1) What precautions i should take as a BI Consultant when it is to UPGRADE the version of ECC (Eg: from R/3 to ECC 6.0)? 2) Will this upgradation affect BI system anyway?
what is the techincal name for dimensions in a cube?
Where does di server executes i.e. Client or server ?
What is a/p invoice ?
What will happen if we remove eventfilters ?
What is company object in sap business one ?
SAP Basis (1262)
SAP ABAP (3939)
SAPScript (236)
SAP SD (Sales & Distribution) (2717)
SAP MM (Material Management) (912)
SAP QM (Quality Management) (99)
SAP PP (Production Planning) (523)
SAP PM (Plant Maintenance) (252)
SAP PS (Project Systems) (138)
SAP FI-CO (Financial Accounting & Controlling) (2766)
SAP HR (Human Resource Management) (1180)
SAP CRM (Customer Relationship Management) (432)
SAP SRM (Supplier Relationship Management) (132)
SAP APO (Advanced Planner Optimizer) (92)
SAP BW (Business Warehouse) (896)
SAP Business Workflow (72)
SAP Security (597)
SAP Interfaces (74)
SAP Netweaver (282)
SAP ALE IDocs (163)
SAP Business One (110)
SAP BO BOBJ (Business Objects) (388)
SAP CPS (Central Process Scheduling) (14)
SAP GTS (Global Trade Services) (21)
SAP Hybris (132)
SAP HANA (700)
SAP PI (Process Integration) (113)
SAP PO (Process Orchestration) (25)
SAP BI (Business Intelligence) (174)
SAP BPC (Business Planning and Consolidation) (38)
SAP BODS (Business Objects Data Services) (49)
SAP BODI (Business Objects Data Integrator) (26)
SAP Ariba (9)
SAP Fiori (45)
SAP EWM (Extended Warehouse Management) (58)
Sap R/3 (150)
SAP FSCM Financial Supply Chain Management (101)
SAP WM (Warehouse Management) (31)
SAP GRC (Governance Risk and Compliance) (64)
SAP MDM (Master Data Management) (0)
SAP MRS (Multi Resource Scheduling) (0)
SAP ESS MSS (Employee Manager Self Service) (13)
SAP CS (Customer Service) (0)
SAP TRM (Treasury and Risk Management) (0)
SAP Web Dynpro ABAP (198)
SAP IBP (Integrated Business Planning) (0)
SAP OO-ABAP (Object Oriented ABAP) (70)
SAP S/4 HANA Finance (Simple Finance) (143)
SAP FS-CD (Collections and Disbursements) (0)
SAP PLM (Product Lifecycle Management) (0)
SAP SuccessFactors (33)
SAP Vistex (0)
SAP ISR (IS Retail) (28)
SAP IdM (Identity Management) (0)
SAP IM (Investment Management) (0)
SAP UI5 (59)
SAP SCM (Supply Chain Management) (51)
SAP XI (Exchange Infrastructure) (49)
SAP Cloud Platform (34)
SAP Testing (89)
SAP SolMan (Solution Manager) (63)
SAP MaxDB (116)
SAP GUI (15)
SAP AllOther (329)