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
- 35888 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
Can you add programs in the scheduler?
What are the transaction codes for process chain?
I have a report it taking so much time how can I rectify
What are the built in javascript functions available to customize your web template?
What are the components of sap bw system?
Explain about cubes?
what is high cardinality tell me brief
What is SUMRT?
How would you measure the size of a infocube?
What is a content extraction?
I created process chain 1st day it taking 10 min after that 1st week it taking 1 hour after that next time it taking 1 day with a same loads what happen how can u reduce the time of loading
what is virtual kef figures? what are the uses and in which case supposed to be use?
I don't have master data it will possible to load transaction data? it is possible is there any other steps to do that one
What are the mathematical functions?
What is modelling?
