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
How would you convert an info package group into a process chain?
What is the source for FIAR extractor from R/3?
what do you mean by transfer routines
What is the use ':' as an authorization value?
What is a number range object?
How would you know if a segment/segment level entry has been summarized?
what is meant by compounding attribute tell me the scenario?
What is the difference between sending a mail to a recipient list compared to sending individual mails via a dynamic loop?
What are the mathematical functions?
What are extractors? Name a few which are used commonly in the sap bw?
What is the advantage of CO-PA?
What does the VARIABLE_SCREEN URL parameter do?
Performance monitoring and analysis tools in bw
What is the data flow from LIS tables to BW?
What is the data target administration task?