Skip to Content
0
Former Member
Feb 24, 2011 at 11:28 AM

Line Item Dimension

33 Views

Hi,

I have created a simple infocube (ZLESS3) with the following dimensions.

Dimension1 (Line Item Dimension): Infoobject Product ID (ZPRODUCT)

Dimension 2: Infoobject Product Type (ZTYPE)

Key Figures: Cost Price (ZCOST)

I know that if a dimension is set as a line item dimension, then the dimension table is not created, and the fact table is directly linked to the SID table.

However, if I do a listschema on this infocube, I can see a dimension table /BIC/DZLESS31 is created for the line item dimension.

I checked the entries in this table, and the SID and DIMID values are the same.

I do not understand. Does flagging a dimension as line item dimension actually NOT create a dimension table or does it mean that the dimension table is created and the dim and sids have the same values?

Regards.

Suraj