BAPI via Excel VBA to check Roll up status of InfoCubes?
Is it possible to write VBA in excel to make use of a BAPI,
that will look into a InfoCube, and ensure that all requests have been rolled up (assuming the aggregates are active)
This will be the scenario
- Aggregates are active on an infocube
- a new data request is loaded into the cube
- the administrator forgets to roll up the data into the existing aggregates.
You may wish to look into the BW administrator Cockpit, which is a lovely bit of standard content that provides all of the administrative reports you might wish to see. As far as using BW through Excel, you can create queries to use the standard business content for BW Technical Content (Statistics)