Reading aggregated data from a cube/multiprovider

[Former Member]

Hi BI people

My project is currently looking for a functionmodule that reads aggregated data from a cube/multiprovider.

I already have a functionmodule that reads data from a cube and returns it in a flat format. I have debugged this, but have not found any flags that can enable the OLAP functionality needed to perform the aggregation. The functionmodule is "RSDRI_INFOPROV_READ_RFC".

The situation is that I need to apply the aggregation logic of a profit center hierrarchy to the data I read from RSDRI_INFOPROV_READ_RFC, this means manually replicating the the OLAP engine functionality (keyfigure aggregation exception, ect.) and this is not an option with the available time/budget.

Please have a look at the example below:

Say that I have a profit center hierarchy as displayed below (with postable nodes).

PC1 - $10

|---- PC2 - $30

|---- PC3 - $20

The data I'm getting back from the functionmodule RSDRI_INFOPROV_READ_RFC looks like this:

PC1 $10

PC2 $30

PC3 $20

But I need the data aggregated. An aggregation utilizing the hierarchy above will make the data look like this:

PC1 $60

PC2 $30

PC3 $20

Instead of building an aggregation program, it would be usefull if it was possible to extract aggregated data.

Any comments appreciated.

Regards

Martin

[Former Member · Accepted solution]

Hi,

did you try RSCRM_BAPI transaction?

you'll be able to run a query and post the result into a table...

hope this helps...

Olivier.

[Former Member · Accepted solution]

Thx Olivier,

The problem is that I need a functionmodule that can apply the OLAP aggregation for a hierarchy to the data outpu from RSDRI_INFOPROV_READ_RFC.

... or the best alternative would be if there were a fm/class that could provide me with the hierarchy aggregation of the data.

/Martin