[MM-W20] Webi IA - Query Time, Row & DB Object Analysis¶

Purpose¶

The purpose of this report is to assist with Impact Analysis of changes to Queries in Webi Documents as a result of changes, to ascertain whether query performance has adversly affected. The report allows for the query times of the same report to be compared against prior historical refrehses of the same report.

Prompts¶

Prompt_Example

Environments -> {FolderTypes -> {FolderPath -> {Folders -> {Documents}}}} | {Datasources -> {Objects}}

Environments

This optional multi-select prompt (featuring in most MMSRL reports) is often used as the parent of a cascading set of subsequent prompts. The LOV will list the CMSIDs of all available Environments. The prompt return value is CMSID, but the more descriptive Environment description along with whether the Environment supports "Enhanced IA" is also detailed in the LOV entries.

FolderTypes

This optional multi-select prompt features in most reports and again is often used as the parent of a cascading set of subsequent prompts for their LOVs and its own LOV cascades from the Environments prompt.

FolderPath

This mandatory mono-select prompt (with its default set to wildcard %) features in most reports with its LOV determined by FolderTypes and again is often used as the parent of a cascading set of subsequent prompts.

Folders

This optional multi-select prompt features in most reports, which benefit the report output by restricting the folders being reported against. Its LOV is determined by the preceding prompts, including the FolderPath prompt (if changed from the default wildcard of %).

Documents

This optional multi-select prompt features in some reports, which benefit the report output by restricting the folders being reported against. Its LOV is determined by the preceding prompts, including the FolderPath prompt (if changed from the default wildcard of %).

Layout¶

Minimum required SAP BusinessObjects version

Please be aware that some features are only compatible with SAP BI4.2 SP3.

Layout

Hyperlinks

Document

Opens the Hyperlinked document, so that it can be further inspected directly.

Input Controls¶

Input_Control_Example

Prompt Selection

Allows the user to reveal / hide the display of the Prompt Selection (can also include Input Control Selection too).

"Spaced" option

The default "Spaced" option reveals the Prompt Selection (below the report header), but also reformats lists to be more readable by adding a space between listed items.

"Show" option

The alternative "Show" option reveals the Prompt Selection (below the report header), without reformatting lists with a space between listed items.

"Hide" option

The "Hide" option hides the Prompt Selection.

Environment / CMSID

Allows the user to switch the display of Environment (within the report) between CMSID and CMS display name (as configured in MetaMiner Administrator).

Warning

Although this Input Control switches the display within the report's results, it does not affect what is listed in the Environment input control, which always lists CMSID. The same is true for the Environments prompt (during prompt selection) and the display of Environments (within the prompt selection block).

Folder / Complete

Allows the user to switch the display of the Folder within the report between the Folder or Complete Folder Path.

Number Format

Allows the user to switch the display of certain metrics to a more readable number format.

Environment

Allows the user to filter the report results to a selected CMSID.

Warning

Although this Input Control is named Environment, it always works on CMSID regardless of the prior Environment / CMSID selection.