Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on 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 a 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

  • author's profile photo Former Member
    Former Member
    Posted on 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 a 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.

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.