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
List the steps to do the creating classes in sap-bw
What are the different types of infocube?
What is a content extraction?
What are the destination target options?
What is business blueprint stage. What do you do here?
Tell something you know about the dimension in the warehouse and how it can be optimized?
What exactly do you know about business warehouse statistics?
I don't have master data it will possible to load transaction data? it is possible is there any other steps to do that one
What is the maximum number of key fields that you can have in an ods object?
when u creating infoobject it shows reference and template what is it
What is the index?
What is 1 ROWCOUNT key figure?
What are the monitor settings?
Which of the tables are inside and outside cube in an extended star schema?
What are extractors? Name a few which are used commonly in the sap bw?