"Validity of data" field showing incorrect date

[Former Member]

Hi Experts,

I have some queries built on a multi cube, and developed web reports on those queries. I have inserted a text element for "validity of data" in the Web Report for seeing the date on which the data was last loaded to the Cubes

Now when the report is run, the "Validity of data" field is not showing the date on which the Cube is last updated. Since the query is developed from a multiprovider, the "Validity of data" field shows the Oldest date on which one of the Cube present in the Multiprovider is loaded.

Is this how this text element works or is there a BUG in my web template?

Please advise me.

Regards,

shameem

[former_member188975 · Accepted solution]

Hi Shameem,

This is how this text element works...it is not a bug.

[Former Member · Accepted solution]

Hi Bhanu Gupta,

Thank you for the quick response.

To confirm, 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.

So you are saying, this is how it works.

Regards,

shameem

[former_member188975 · Accepted solution]

Yes, that's right. 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.

Hope this helps...

[Former Member · Accepted solution]

Thank you so much, Bhanu Gupta.