what is line item dimension? when we need them?
how we will come to know we need to create line item
dimensions?
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
What is data flow in bw/bi?
Which datastore object is used?
Explain table partition?
What are the differences between v1, v2, v3 jobs in extraction.
Where the data is extracted during init of delta and during delta updates?
What are value fields?
When you define aggregates, what are the available options?
What is update routines.
What are the transaction codes for process chain?
What are the general restrictions?
What is scoring ?
What is a content extraction?
What is customization.
What are the objects that support variables?
Define the Lis data flow?