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

Reporting on Transactional Cubes

Hi,

A transactional cube is loaded data from BPS (APO* request)constantly, and there are aggregates associated with this cube. By default aggregates are rolled-up after the number of records reaches 50000. If a query is run before that threshold is reached, is it going to hit the aggregates? If yes, it will not have the most recent data; if no,it will read the db and performance would be very slow...why do we need the aggregates since they are not accessed?

Am I missing something? Could you guys clarify.

Thanks,

FF

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 Oct 10, 2005 at 02:50 AM

    Hi,

    If I am right, the behaviour you are referring to is relating to the open data request on a TransCube, which closes the request once it reaches the 50000 records and creates a new one. Thus committing the data to the cube, removing the data request key. This should not be confused with Aggregates, built on a cube.

    If you want to do a reporting, including the open request, you can use the variable 0S_RQMRC (Exit variable for Request ID)in the BEx query, to bring the data in the request also to query output.

    HTH,

    Nataraj.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      When the request is closed (after 50000 records), it commits the data to the cube, removing the request id.

      Aggregate is a roll-up built on top of a cube. Aggregates are primarily to ease the performance by foregoing an extent of the data granularity.

      If your concern is to report on 'Most recent data', including the data in the open request, use the variable I have suggested. If your concern is on the 'usefulness' of the aggregates, then it needs a brief review of your data model and reporting requirement. In general, aggregates are used to improve the performance, but bear in mind the reduced data granularity level.

      Regards,

      Nataraj.

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.