what is a dimension table and types? explain about line
item dimension and high cardinality and uses, in which case
suppose to be use?
- 1 Answers
- 4856 Views
- I also Faced
- E-Mail Answers
Answer / shri
Dimension table which holds character infobjects...
Types of Dimension tables..
Time dimension
Unit dimension
Package dimension
Line item dimension
when the dimension table contains more than 20% size of
fact table then it is a line item dimension..
in line item dimension table we will have only one
character info object..
scenario..
document number in granular infocubes..
customer numbers in coustmer-centric business like
telecommunications,banking and insurance...
| Is This Answer Correct ? | 9 Yes | 1 No |
How do start routine and return table synchronize with each other?
where do u find the option "REPAIR REQUEST"? WHAT IS THE USE OF THAT?
7 Answers Cap Gemini, John Deere, TCS,
What is the structure of infocube?
How to fetch the data from sap-r/3, sap-bw/bi to informatica system? what is step by step procedure? at what senario you retrieve the data from sap system to informatica or say dwh system? --
R/3 extraction failed - recovery procedure?
explain return tables. How do start routine and return table synchronize with each other?
Give the steps and tips to load hierarchy data from flat files?
What is the calculated key figure?
What is the option ?default chains??
what are types of kef Figures, characteristics, attributes? explain me in detailed?
how do you extract data from R3 to BW for a specific date.? how to filter the data for the period?
How do you access to source system data in bi without extraction?
-
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)
