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

Cube & multiprovider

Hi all,

What happens during roll up of aggregates & compression in cubes? Whether multiprovider can collect data from infosource????

Thanks & regards,

Jasil

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on Jan 29, 2008 at 08:33 AM

    Data is never physically avaialble in the Multiprovider.

    They are just used to create a union between two infocubes so that different fields from different infoprovider can be brought into the same report.

    Rollup of aggregates are done to fill teh aggregates with the new data that has been loaded into the cube.

    When a compression is done data is moved from F table to E table ..

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 08:48 AM

    Dear Jasil Babu

    ℹ️ Aggregates are mini cubes. It will used for faster accesing for your queries. When the cube has aggregated, when reporting it will get all the possible data by defined methods faster.

    (ii) When compression unwanted spaces in the target can be eliminated and used for further. Hence space will be more for data accessing. Here after compression you can't delete the data in data target but you can do selective deletion

    (iii) Mulpiprovider follows :UNION" concept. You can conbine CUBE, DSO, INFO SET, INFO OBJECTS. While reporting it will get all the data, but physically it will not hold any data.

    Hope you will get some idea.

    Regards

    Raju Saravanan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 08:52 AM

    Hi,

    roll-up aggregates

    http://help.sap.com/saphelp_nw70/helpdata/en/9a/33853bbc188f2be10000000a114084/frameset.htm

    Compressing InfoCubes

    http://help.sap.com/saphelp_nw70/helpdata/en/ca/aa6437e7a4080ee10000009b38f842/frameset.htm

    multiprovider collect data from infoprovider's only. he will not collect data from infosource.

    hope this help you

    regards

    harikrishna N

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 11:06 AM

    Hi,

    1. Aggregates are small type of cubes built upon cubes. Aggregates are build upon the requirement of the reports how frequently the user will be executing and how many characerstics are used in the query etc.

    When you execute a query, if the query has suitable aggregates then it will fetch data from aggregates other wise it will extract data from cube.

    2. When you compress data the data in the cube moves from F table to E table with compressing the data and the request id's will be deleted accordingly.

    Cheers,

    Malli..

    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.