Skip to Content
Author's profile photo Andreas Schuth

Loading Date of BW InfoProvider in SAP BO

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 🙂



Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Tammy Powlas
      Tammy Powlas

      Moved to the Business Warehouse space; please post this type of content there in the future.

      Author's profile photo Andreas Schuth
      Andreas Schuth
      Blog 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 🙂