Skip to Content
author's profile photo Asif Ummad
0
Asif Ummad

Aggregates and indexes

Posted on Nov 29, 2007 at 05:39 PM 9 Views

Hi,

I have a question.

how to find or check the secondary indexes and aggregates.

bw 3.5

object cubes

please help me.

Thanks

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Nov 29, 2007 at 10:21 PM
    0

    You can check out the aggregates in RSA1 by right clicking on the infoprovider and selecting Maintain Aggregates. This will show you the status of the aggregates, as well as information as to how often each is used.

    Here's a link to some SAP information on SAP indexes

    http://help.sap.com/saphelp_sem40bw/helpdata/EN/cf/21eb20446011d189700000e8322d00/frameset.htm

    Generally with a cube you don't need to create secondary indexes, BW does it for you. You can check to see if there are any missing indexes by using transaction DB02, and clicking "Missing Index" at the bottom.

    You should be able find quite a bit of information on aggregates and indexes by simply searching the forums.

    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.