How to add a timestamp to a HTML Document to display when the report was last executed in Microstrategy Developer
Create an attribute to retrieve the database system time using a Strategy function, CurrentDateTime.
The source table and available columns are irrelevant in this example.
Note: The keyword "Sysdate" is an MS Access specific function which specifies date. It may not be supported for all databases. Check with the system DBA for the appropriate keyword. For more infomation, refer to Strategy Knowledge Base document, KB4000-007-0034- How to create dynamic dates using Strategy Developer
Change the "Form format" to "Datetime."
Change the data type to "TimeStamp" under the column alias tab. Save and Close.
Bring the attribute into the report and execute it.
The following screen shot shows the report with the time stamp added:
For information on how to add an extra time stamp column to a datamart, refer to Strategy Knowledge Base document,
KB7860 (KB4000-7X0-0856): How to create a datamart table that contains an extra column with the current time stamp in Strategy Developer
