what is line item dimension? when we need them?
how we will come to know we need to create line item
dimensions?
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
Is it possible for the users to convert the package group into a process chain? If so, how?
Explain bp master data?
how to getweekday,weekmonth,month,weekno,week order in the report by using routines?
What are the tools to monitor overall query performance.
What are events and how you use it in BW?
How does it do delta?
Why if one request fails, all the subsequent requests are turned to "red"?
What are the options for conditions for key figures?
How would you know if a segment/segment level entry has been summarized?
Give some examples of queries delivered with BW statistics?
What are the general tuning guidelines?
Do you have any idea how to improve the performance of the bw?
what is offset? Without offset we create queries?
What are the combined tests?
What are the load process and post processing?