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
- 35508 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / gangadhar
If the volume of the masterdara of a dimension is growing
along with the transaction data then to improve the data
read performance of master data, we can create the
dimension as line item dimension.
when we create a dimension as line item dimension, the SID
of the characteristic will be joined directly with the fact
table without using dimID's.
Disadvantages : F4 help is not possible in data selection
screens for line item dimension.
Conditions : 1. The dimension should have only one
characteristic. 2. Master data of dimension >= 20% of
transaction data of infocube(interms of records).
| Is This Answer Correct ? | 20 Yes | 2 No |
Post New Answer View All Answers
Do you have any idea how to improve the performance of the bw?
You want to see if the execution of a query has been slow or fast. How would you do that?
What is the benefit of using bw reporting over sap reporting?
Why if one request fails, all the subsequent requests are turned to "red"?
Where to check the log for warning messages appearing in activation of transfer rules?
How do you debug user exit?
how to getweekday,weekmonth,month,weekno,week order in the report by using routines?
How New TSH Hierarchy top node TSH_SITE to be loaded into BI/BW.??
what is sid for to trasport the object along the land scape:/
What are extractors?
What is a control query?
What is data flow in bw/bi?
What are events and how you use it in BW?
Explain business blueprint stage. What do you do here?
What are the system tools you can use?
