Skip to Content
avatar image
Former Member

Last data update

Hi,

How I can find the last data update information(date and time) of multiprovider in BW?

Kindly help on this.

Regards

Mukul Singhal

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Nov 20, 2008 at 07:21 AM

    How I can find the last data update information(date and time) of multiprovider in BW?

    Last data update of multiprovider ??? There isnt any data update to multiprovider its doesnot hold any data.

    It just creates Union of data from your infoproviders.

    Add comment
    10|10000 characters needed characters exceeded

    • Let me explain how the "last data update" works.

      If the query is based on one cube or DSO, it is the time of the last request upload.

      If the query is based on a multiprovider, like the example given ealier,

      assume there are three cubes in multiprovider : 

      Last update of cube1 is 11/17/2008

      Last update of cube2 is 11/19/2008

      Last udpate of cube3 is 11/20/2008.

      The "last data update" will be the earliest day of the "last data update"s of all partproviders, i.e.11/17/2008.

      Because the meaning of "last data update" is that, data (of all partproviders) has been already updated until this time.

      Now we assume there are three cubes like this in multiprovider :

      Last update of cube1 is 11/17/2008

      Last update of cube2 is 11/19/2008

      Cube3 is empty. It has never been loaded with any request.

      Then the "last data update" will be empty. Because until no time has all partproviders been updated. This is the design of the system.

      Regards,

      Patricia

  • avatar image
    Former Member
    Apr 30, 2012 at 10:12 AM

    We cannot find the last updated date of a multi-provider.. A multi-provider has various info providers such as a DSO, Cube etc

    Our query may be triggered from the info-providers which actually have data. Right-Click the DATA TARGET, Click MANAGE, where you find the DATE and TIME adjacent to each REQUESTID, since it only shows last update time of infoproviders. 

    Message was edited by: Arathy Dhandapani

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Our default web template created in Web Application Designer currently has a Last Data Update indicator that works with Infosets (it shows the update time of the DSO with the oldest load). I'm trying to find out what table this reads from. We basically want to utilize this functionality but change the target from the web template to a new application we're creating.

  • avatar image
    Former Member
    Jul 26, 2016 at 08:44 AM

    Hello,

    Try table RSDINFOPROVDATA.  This will give timestamp of the latest updates to the InfoProviders.

    Kind regards,

    Ross

    Add comment
    10|10000 characters needed characters exceeded