Query element - "Last Data Update:" for MultiProviders

[Former Member]

Hi,

I have a MultiProvider where data for different years are stored in separate InfoCubes, queries are created on MultiProvider upon those basic cubes.

Everything runs well, just the text element for "Last Data Update:" displays the most old data of the data load for included InfoProviders.

I would like to display the date form the InfoProvider where the current data are loaded. And do not want to change the WEB template.

Is there any standard text variable to be used?

Similar post:

Thanks, Tom

[Former Member]

tomaz this is how it works, it is not a bug,

take an example

I have a multiprovider which has two cubes, say Cube A and Cube B.

Cube A was last loaded on Oct 20 and the Cube B was last loaded on Oct 22.

Now in the Web Report developed on the multiprovider, the "Validity of data" field shows the date as Oct 20.

solution:

It takes the oldest date (Oct 20) with the assumption that this would be true for all the data cming through in the query. If it takes the latest date (Oct22), then this would not hold true for data that is not coming from Cube A.

if u refer note 680652 & 993622 it says :

"The minimum date is taken from the dates of the highest number of requests.