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
- 35643 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
Give an example of it?
What is an infocube? What are its different types?
Where do we use write optimized dso’s?
What is the Bex options for characteristics like F4 help for query definition and execution?
which patch u used presently? How can I know which patch that one?
I am looking for SAP BI banking reports and business content for banking. Please help
What is info provider documentation?
How does the time dependency works for bw objects ?
How do you do EURO conversion at the database level?
Why if one request fails, all the subsequent requests are turned to "red"?
What are the hierarchy relevant parameters?
How many types of info sources are there? What are they?
What are the differences between v1, v2, v3 jobs in extraction.
What are the options when defining aggregates?
What is the option of ?pause Automatic Refresh??
