Skip to Content
avatar image
Former Member

Query Performance

Hi,

Had a question...for SEM-BPS, transactional cube is used for planning. All the queries are based on this transactional cube only. Some queries run really slow because of the complex structures involved in rows section (that is strcutures with selections restricted to hierarchy nodes or range of hierarchy nodes). Will it be a good idea to push all the data to a basic cube and create complex reports on it or is there another alternative?

Usually in an SEM environment, do they just create queries on transactional cubes only? What is the norm?

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Apr 24, 2006 at 08:37 PM

    Hi,

    There will be no performance improvement even if you move the data to basic cubes. The way query reads the data is the same for both the types of cubes. What you should target is creating indexes/aggregates on the cube.

    thanks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 25, 2006 at 02:21 AM

    Hi Ann,

    I think u should have a different basic cube for reporting, in our SEM project also we r doing the same.

    The reason is:

    According to the database on which they are based, transactional InfoCubes differ from Standard BasisCubes in the way they are indexed and partitioned. For an Oracle DBMS this means, for example, no Bitmap indices for the fact table and no partitioning (initiated by BI) of the fact table according to the packet dimensions.

    Reduced read-only performance is accepted as a drawback of transactional InfoCubes, in favor of the option of parallel (transactional) writing and improved write performance.

    regards,

    ajay

    assigning points is the way of saying thanks in forum

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 25, 2006 at 06:33 AM

    Hi Ann,

    Welcome to SDN.

    I believe you must be having a request open for entering data to the transactional infocube. Try closing the request with the FM RSAPO_CLOSE_TRANS_REQUEST, and compress the data of the Infocube.

    It should improve the performance of the queries based on the cube.

    Hope it helps.

    Add comment
    10|10000 characters needed characters exceeded