Show TOC

Background documentationSelect Display Fields: Query Information Locate this document in the navigation structure

 

Use the Select Display Fields dialog box to select the query information you want to display in your model. Query information is textual information saved in a BI query such as query author and last update of the data, and is generated from an output port on the BI query data service. The Select Display Fields dialog box is displayed when you drag from a query's Info port and choose Add Form View from the context menu.

In the Select Display Fields dialog box, a list is displayed showing available query information. Using the checkboxes, you select the query information that you want to display.

Structure

The main fields and controls of the dialog box are listed in the following table:

Field/Control

Description

Select all

Checks the boxes of all the information types.

Clear all

Clears the checks from all boxes.

AUTHOR

Author: The user who defined the query.

INFOCUBE

InfoProvider: The InfoProvider that provides the data reported by the query.

MODTIME

Changed At: The time at which the query definition was last changed.

MODUSER

Last Changed by: The user who last changed the query definition so that the query has been regenerated.

REPTNAME

Query Technical Name: Technical name for the query.

REPTXTLG

Query Description: Description of the query.

ROLLUPTIME

Status / Validity of Data: The point in time when data for the latest request that can be used for reporting was posted to the InfoProvider. This shows a date and a time (in the local time zone).

ROLLUP_DATE

Relevance of the Data (date): The date of the ROLLUPTIME text element.

ROLLUP_TIME

Relevance of the Data (hour): The time of the ROLLUPTIME text element.

SRDATE

Key Date: The date for which time-dependent master data is selected.

SYUSER

Current User: The user who has this query open.

SYUZEIT

Last Refreshed: When the query data was last refreshed.

Example

See Adding Query Information to Your Model in the SAP NetWeaver Visual Composer Modeler's Guide.