Bus. Analytics: how to report on detail level

johan72

Hi,

I have created some dimensions on a cube (either through the configurator or directly on the sql server) and now I want to create a report in BA both grouped on product posting group and on transaction number.

For example: value entry cube
dimension: gen. product posting group
value: cost amount (actual)

In the BA report generator only the dimension and values can be selected, but I want a drilldown to the complete value entry record. I can't make dimensions of each column, it will explode the datawarehouse aggregations.

Thanks,
Johan.

ammandul

Hello,

for the detail level, you must activate the drillthrough option (tools) in the cube. After this, you can find in the context menu from BA-table object the enabled entry "drillthrough"

Kind Regards

André