Skip to Content
0
Former Member
Jun 29, 2007 at 10:39 AM

Reading aggregated data from a cube/multiprovider

17 Views

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