Delete Unused LINE ITEM DIMENSION Entries

[Former Member]

Hi,

I'm using RSDRD_DIM_REMOVE_UNUSED to remove unused items in the dimesions of a cube. However several of these dimensions are line item dimensions. RSDRD_DIM_REMOVE_UNUSED skips these diemensions. My questions are. Does someone know why? Secondly is there a way to control the size of this dimension?

Thx Rolf

[Former Member · Accepted solution]

Hi,

A line item dimension does not exist in the database. So the report can not delete the unused entries as there are none.

Explanations :when you have a single characteristic in a dimension of a cube, this is not worth to generate the Dimension IDs. This would be a copy of the indexes of the master data called SIDs.

By ticking the box Line Item Dimension, you precise that the indexes for the fact table will not be those generated in the dimension, but those from the master data. This is the reason why we do have indexes for master data.

To control the size of your dimensions, there is this report : SAP_INFOCUBE_DESIGNS

Regards

[former_member184494]

Also there ideally is no DIM ID for a Line Item dimension - the SIDs are directly stored in the fact table and hence these dimensions are skipped...

Arun

[Former Member]

Thx for the quick reply.

It helped