Howdy fellas,

since I found the very nice blog entry from Prabhith and people may have not activated the BI Administration Cockpit, I decided to quickly post an entry quick and dirty while loading some data 😉

(Link to document: http://scn.sap.com/docs/DOC-48514)

One of the most missing features in BI is the loading date of InfoProvider in SAP BW.

Quite a while before the BI Admin Cockpit was activated in our system, I needed to find a solution.

As Prabhith mentioned there a quite a few so this is how I done it:

1. Create a Generic DataSource in your BW System on Table RSBKREQUEST (no delta necessary at least in my case).

/wp-content/uploads/2013/11/1_315423.jpg

2. Create a DSO with the following InfoObjects:

-> ZULADDAT is a Date and ZULADTST ist the timestamp of the loading.

/wp-content/uploads/2013/11/2dso_315424.jpg

3. Create a Transformation

/wp-content/uploads/2013/11/3trfn_315431.jpg

4. Create the routines for converting the timestamps into somthing we can use:

a. Routine for the InfoObject ZULADDAT (convert the timestamp in date)

/wp-content/uploads/2013/11/4rout_315432.jpg

b. Routine for the InfoObject ZULADTST

/wp-content/uploads/2013/11/5routtimstamp_315433.jpg

-> Make sure to set your TimeZone and DayLightSaving indicator according to your needs.

in my case we are in Switzerland.

5. Create the DTP with filter:

a. TargetObjectType  CUBE, IOBJA, ISET and ODSO

b. Request Status: 2 and 8

6. Create a Multiprovider on top of the DSO – add the fields

-> Create a BEx Query and / or a Universe.

7. Result can look like this (we have this on all our Webi-Reports:

/wp-content/uploads/2013/11/6_315434.jpg

Thats about it.

Hope this helps,

Andreas

PS: Make sure to put this load after loading all other InfoProvider 🙂



To report this post you need to login first.

2 Comments

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

    1. Andreas Schuth Post author

      Well argueable, cos BW does not need the loading date of InfoProviders since its already build in BEx. This solution is for BO – especially for Webi / Dashboards etc.

      But i dont mind letting you move this 🙂

      (0) 

Leave a Reply