Skip to Content
avatar image
Former Member

Partitioning of Infocubes

Hi guys

I have some questions about maintaining BI...I couldnot find answers for these....

1.How do we analyse if we have to do partitioning or not?(I came to know that SAP has some recommendations for this)

2.Whats the problem we face with aggregates on navigational attributes?

Thanks in adv foryour help...

Regards

Schand

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 07, 2010 at 08:57 AM

    Hi,

    You can run an analysis in ST03N, where you look at the ratio between data the queries run through and the data shown. If you have high DB time, you can also look at aggregates. But try partitions first.

    Also, check that data statistics are up to date.

    For info on partitioning check:

    http://help.sap.com/saphelp_nw70ehp1/helpdata/en/0a/cd6e3a30aac013e10000000a114084/frameset.htm

    If OLAP time is high, you can check the queries in RSRT.

    Br,

    Sonni

    Add comment
    10|10000 characters needed characters exceeded