Skip to Content

The BPC Data Package Monitoring is tacking quite Long as you need to enter the Model on EPM. This solution gives you the possibility to monitor on real time all Data Packages and this also for more than one Environment.

To get the reporting done we use the View UJD_STATUS and do create an extract structure for direct data access.

Go to SBIW Tab Maintain Generic DataSources and generate the extract structure.

SBIW.png  

Go now to the Tap Postprocessing of DataSources and define the section fields.

SBIW_2.png

With RSA3 you can already test the data extraction. You see now than the result from the view gives much more information as you would use ST13. Especially you see the User , Environment and Model and so on.

RSA3.png

Create now on RSA1 the InfoObjects for the Virtual Cube.

InfoObjects.png

Please have a look to the Transformation, you see the Timestamp are changed with a Formula Function.

Transformation.png

I think, I do not need to explain how to build the DTP process or the Cube.

See now a picture for the Virtual cube.

Cube.png

Now we are ready to create an Bex query and test our BPC DataPackage reporting.  I did create variables for Status, Environment, Model and User ID:

Variables.png

I did select the Environment ‘ZIG_GLOBAL’. If the Field End Time is empty then the DataPackage is still running.

Query.png

You can now refresh the query and as soon then field End Time is filed the Data Package is finished.

I hope this will help you to manage and control your BPC Data Package better and faster. 

  Regards Dario

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply