Function documentation Line Item Dimension Locate the document in its SAP Library structure

Use

A line item is an InfoObject, which has a small number of facts listed on its characteristic values in the fact table of the InfoCube. The dimension table of a line item InfoObject would become almost as large as the fact table. By indicating a dimension as a line item, you can prevent performance problems that would come about from the size of the dimension table. The document number is a good example.

We do recommend that you use ODS objects, where possible, instead of InfoCubes for line items. See Creating ODS Objects.

Activities

When creating the dimensions in the InfoCube maintenance, flag the relevant dimension as a Line Item. You can assign this dimension to exactly one InfoObject. No database table is created when you activate the InfoCube. Instead, a field is written for this dimension to the fact table. The field is a direct link to the SID table of the InfoObject. The data is requested directly from the InfoObject.

From the Star Schema diagram:

InfoCube ® Dimension ® InfoObject

we now have (for this line item InfoObject):

InfoCube ® InfoObject