table name where I can see the Secondary bit map Index for Cube Loads in BI

[Former Member]

Hello Friends I want to know the table name where I can see the Secondary bit map Index that gets created with each request that get loaded to Cube so each 1 request will be multiplied by 7 dimension and 7x1 = 7 local secondary bit map index will be created where is that table which show me that .

Under Oracle every uncompressed request corresponds to one partition in the

F facttable of the corresponding infocube. This partition also brings along

a full set of secondary local bitmap index partitions.

If you have a cube with 10 uncompressd requests and 10 dimensions (every

dimension brings with it a local bitmap index) you have 100 partitions for

the table itself and 10 x 10 index partitions which makes a total of

100 database objects. where is that table in BI WHICH STORE THIS INFORMATION

Also if I have E Table with no entries for future 2009 dentries will that be an issue with blank partition ion E Fact table if yes please suggest how to resolve this issue

[Former Member · Accepted solution]

Hi Soniya

Information about BI objects is stored in the RSD* tables. For example:

Infocubes: RSDCUBE / RSDCUBET

Aggregates: RSDDAGGR_V / RSDDAGGRT

You can see information on abap dictionary object as well in transactions SE11 / SE14. You will have to know the real table name of the cube, should be something like /BIC/F* for the uncompressed and /BIC/E* for the compressed table.

Best regards, Michael