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
- 35259 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
List the steps to configure sd and mm for bw.
What is the benefit of using bw reporting over sap reporting?
what do you mean by update routines
What is an infocube? What are its different types?
Explain customization?
What are the data sources supported?
Tell something you know about the dimension in the warehouse and how it can be optimized?
What is the index?
what is high cardinality tell me brief
is there is any book that covers all topics of BI 7.0 and the navigation steps for bi 7.0 and pdf of 7
we have a ods in process chain and the ods activation is taking long time how will u optimize the activation process.
Differentiate between v1, v2, v3 jobs in extraction.
How the mapping is done in bw?
What is the data flow from LIS tables to BW?
What is rowlevel security ? can u please explain with real time example?
