Friday, 10 July 2009

Display cube dimension percentage used

To display, per dimension, the percentage used with regard to the number of entries in the fact table(s), function module RSDEW_INFOCUBE_DESIGNS can be used.
Enter the name of the cube for input parameter I_INFOCUBE and execute the function module.
Export parameter E_T_TABLSIZE will provide you the desired result as shown in the attached picture.

2 comments:

  1. Hi Sven,

    I knew transaction code RSRVALT (Analysis of the BW objects) as a way to find this information.
    Now i know the "short-cut"

    Don't know if RSRV will also give this info?
    I'll check this.

    Thnx!

    ReplyDelete
  2. Rene,

    Yes RSRV gives the info as well. Check out Option 'Database Information about InfoProvider Tables' in the Database tab.

    Good luck!

    ReplyDelete