Interested to Buy Any Domain ? << Click Here >> for more details...
what is line item dimension? when we need them?
how we will come to know we need to create line item
dimensions?
- 7 Answers
- 35862 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / balaji bathala
If you have a characteristic that can have a large no,of distinct values it is the likely the dimension which you include these char contains same no.of records. The path from Fact table to Dim Table and then to SID Table will become critical for performance. If you make this dimension as LineItem then the SAP BW will not create DIM Ids and it creates the Dimension Table and this table will act as a just view.
Directly the SID is connected to the Fact Table. Here the SID will act as the key in the Fact Table.
Limitations:-
We can include only one Characteristic in the Line Item Dimension because the Key in the Fact Table is SID. We can Create SID for each characteristic separately.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain return tables.
Can you add programs in the scheduler?
What are the data sources supported?
What are the steps to do the creating classes in sap-bw.
Can you name a few important tasks which are essential in the data warehousing and management of the same?
Explain the architecture of the sap bw system and its components?
hierarchies are not there in bi?why
Explain about cubes?
What are the steps to do the converting from lis to lo extraction.
What is the purpose of sap bw/bi?
What is the data flow from LIS tables to BW?
What is the use of db connection in sap bw data acquisition?
what are the different components in dso architecture?
What are the different types of infocube?
I have 80 queries which query is taking so much time how can you solve it
