Hi Jothi,
What do you mean by 'Last database refreshed date'?
Need more info please.
-Abhilash
Hi Abhilash,
I have Crystal reports designed on op of BEx Query.
User want to see the Date of last refershed data in BW.
Suppose we extract data into BW from source systems evey 3 days and user is trying to run the report on 4th day and in crystal reports it doesn;t show anywhere that this is the updated data they are looking at.
In this scenario they have request if we can provide any last refreshed BW data date in Crystal.
Pls let me know if you want more details and I misssed anything you expect.
Thanks,
Jothi
Any Suggestions will be appreciated 
Thanks,
Jothi
Jothi,
There are two special fields, Datadate and Datatime, that together will give you the date and time the data was retrieved from the database.
Debi
HI Debi,
I already tried those available fields in report and it showing only the last refreshed date of the report and not the database.
Please correct me if I'm wrong.
Thanks,
Jothi
You are correct... datadate is the report refresh date. Sorry, that is what I thought you were looking for. I do not see anything close in the index of my CR bible either.
I found SQL statements on line at http://www.zimbio.com/SQL/articles/jYsn42w_5l8/Find+Database+creation+date+DATABASE+AGE+SQLhttp://
SELECT sys.schemas.name + '.' + sys.objects.name,
create_date,
modify_date
FROM sys.objects
And this for a SQL server
SELECT name,crdate
FROM master..sysdatabases
Database->Date Of Creation
and I found at http://sqltrends.blogspot.com/2011/03/find-created-date-and-modified-date-of.html
SELECT sys.schemas.name + '.' + sys.objects.name,
create_date,
modify_date
FROM sys.objects
INNER JOIN sys.schemas ON sys.objects.schema_id = sys.schemas.schema_id
WHERE type = 'P'
OR type = 'U'
OR type = 'FN'
OR type = 'V'
ORDER BY modify_date DESC
Maybe one of them will help get you where you want to go.
Thank you so much DEbi,
I will start working on it and keep you update.
Thanks,
Jothi
Hi,
While working on one of the issues, I came across following KBase written by Henry Banks:
1548588 - Can << Last Data Update (Multiprovider) >> information from BW be shown in Business Objects reporting tools.
There is an enhancement request created on the Idea place and you might want to vote for it to have it included in the next releases/patches.
Thanks,
Prathamesh
Thank you,
I did voted the Idea by Henry.
Will be looking into the SAP Note that you sent.
Thanks
Jothi
Hi,
In relational databases (for eg Oracle) there are system tables or user data dictionaries where such info is available.
Databse refresh date-time must be surely logged into a system R3 table. You just need to use this table field into the Infocube and include that Infoobject in your BEx query.
Following white paper details the SAP BW point-in-time data recovery:
Although, these are steps for recovery, there could be some info available on database update timestamp. See info from page 4 through 8.
You might want to consult a SAP BASIS Admin for a better solution.
Thanks,
Prathamesh
Thank you for the reply and link Prathamesh,
I will discuss this with my Bex developers if they can help me out in this.
Thanks,
Jothi
