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
- 35520 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
What are the elementary tests you can run?
Give an example of VBA?
What is the purpose of sap bw/bi?
Give an example of master data documentation?
Does any other erp software use bw for data warehousing.
How do you upload currency exchange from a flat file?
Explain about cubes?
What is the dimension in bw?
What is partition of an infocube?
what is offset? Without offset we create queries?
You want to see if the execution of a query has been slow or fast. How would you do that?
How do you use print settings?
What is the function of the ‘reconstruction’ tab in an info cube?
what is the ticketing tool for wipro and ticketing tool depends on company or client?
How will you add buttons to a template?
