Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 31, 2008 at 11:59 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.