"Validity of data" field showing incorrect date
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.
Bhanu Gupta replied
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...