Cube & multiprovider

[Former Member]

Hi all,

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

Thanks & regards,

Jasil

[former_member189638 · Accepted solution]

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 ..

[Former Member]

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..

[Former Member]

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

[raju_saravanan]

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