Answer / kg

This means the dimension contains precisely one
characteristic. This means that the system does not create
a dimension table. Instead, the SID table of the
characteristic takes on the role of dimension table.

Answer / murali

When dimension table size equals or exceeds the fact table
at that point time we need to use the line item dimension.

If we use Line item dimension our fact table contains SID
instead of dimension ID.

For maintaining L.I.D we have to create only one object in
dimension table.

Answer / 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).

Answer / kalyan

Line item dmension is a single chracteristic considered as
a dimension.When size of dimension table is greater then
10% of the size of fact table then we create line item
dimension

Answer / chavid

Hen the chracteristic value (#s) is one & is larger (say
like order no. During query this ill give performance
issue. So it is better to define such chars as line item
Dims. Only SId is generated & used by fact table. R O thumb
is hen the cardinality is > 10 then it is advisable to
define the IO as L I Dim. L I Dim uses b-tree index (
default is Bipmap).

Answer / karunesh mishra

Line item dimension can be created only on characteristic
not on key figure.
Reason why we create L.I.D is that, it increases the query
performence because it doesn't create the dimension table
and the SID is directly connected with the fact table.

Answer / balaji bathala

If you have a characteristic that can have a large no,of distinct values it is the likely the dimension which you include these char contains same no.of records. The path from Fact table to Dim Table and then to SID Table will become critical for performance. If you make this dimension as LineItem then the SAP BW will not create DIM Ids and it creates the Dimension Table and this table will act as a just view.

Directly the SID is connected to the Fact Table. Here the SID will act as the key in the Fact Table.

Limitations:-
We can include only one Characteristic in the Line Item Dimension because the Key in the Fact Table is SID. We can Create SID for each characteristic separately.

what are the extractions made in a sap bw project using lo cockpit extraction in mm and sd and fi?what is the requirement and name them?

0 Answers   Accenture,

What are the options to convert currency?

2 Answers  

Can you partition a cube that has data already?

5 Answers  

What is SUMRT?

0 Answers  

Give an example of the content key figure OTOTALSTCK (quantity total stock)?

0 Answers  

what is meant by flat aggregate?explain in detail

1 Answers   Rockwell, TCS,

Where the data is extracted during init of delta and during delta updates?

0 Answers  

What are the system tools you can use?

0 Answers  

is there is any book that covers all topics of BI 7.0 and the navigation steps for bi 7.0 and pdf of 7

0 Answers  

How would you measure the size of a infocube?

0 Answers  

When you define aggregates, what are the available options?

0 Answers  

How do perform real-time data acquisition in a bw system?

0 Answers