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
What steps do you take when you add a new company code to the already running delta datasource ? The datasource is already extracting specific company code delta data , so how will add new company code without disturbing delta
What are transfer rules?
What are the do?s and don?ts?
Which transaction on R/3 shows the transactions with pending processes for update?
What is the calculated key figure?
What is an open hub service?
What is the program to maintain change run?
Where the data is extracted during init of delta and during delta updates?
Extraction in mm and SD and FI? What is the requirement and name them?
Where do we use write optimized dso?
what are the data types for the characteristics info object?
What exactly do you know about business warehouse statistics?
What is update routines.
What is data ware-housing hierarchy?
What are the naming conventions for aggregates created from statistics?