Displaying the update time of a Datamart

---

Sometimes it may be required to display the last update time of the Datamarts used as part of the report.

O3 Report includes a mechanism that provides developers with this feature by using a simple MDX query

Specifying the Query

1. Add a new MDX query with the following sentence

   SELECT {CubeInfo.LastModifiedDate} ON COLUMNS
   FROM Vinos
   

   In this sentence, CubeInfo indicates that information is required from the Datamart, and LastModifiedDate identifies its last update time.

In the following example, a Data Set named "Wines Update Time" is used

Displaying the update time in the report

There are several ways to display this date in the report.

For instance, it may be possible to add a Table, just like it is described in the section Specifying the data to use

Another alternative, that is shown bellow, would be to use a Data element that would not require a Table

1. Drag the Data item from the Palette to the Design Area
   
   This automatically displays the following window requesting the information that should be shown.
   
2. Cancel the edition in this window. We first need to bind the Data element with the corresponding Data Set.
3. Activate the Properties Editor for the Data element you just added and select the Binding tab
4. Select the "Wines Update Time" option as the Data Set to use
   
5. Finally we need to indicate the column from the Data Set that contains the information
6. Right-click the Data element and choose the Change Data Column option.
   The following windows is shown:
   
7. Activate the checkbox next to the LastModifiedDate column and accept the changes
   

---