Using data provider functions

Data provider functions provide us with data that relates to the query, such as the universe name, number of rows retrieved, data provider type, and more.

Data provider functions aren't useful in the report tables or charts as part of the data displayed but rather as metadata that relates the report frame and its context.

The main data provider functions are as follows:

• LastExecutionDate: This provides the last refresh date of the report (this action is recorded when the document is saved; otherwise, it keeps the last refreshed time of a saved version of the report)

• NumberOfRows: This is a function that returns the number of rows returned by a query

• UniverseName: This function returns the universe name that the query is based on

• UserResponse: This function is one of the most common and useful functions, and it returns the values picked in a prompt.

• DataProviderType: This determines whether the data provider is based on universal or personal data

How to do it.....