[MM-D01] Documents - Activity & Datasource¶

Purpose¶

The purpose of this report is to assist with Impact Analysis of changes to Universes on General Documents, to analyse whether which Universes are used what Documents.

Prompts¶

Prompt_Example

Environments -> {FolderTypes -> {FolderPath -> {Folders -> {Documents}}}} | {Universes}}

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 %).

Universes

This optional multi-select prompt allows the user to restrict the report to selected Universes. The LOV will list all Universes available in the Environments selected in the prompt above. Its LOV cascades from the Environments prompt so if no Environments are selected in the prior prompt then no LOV entries will be listed.

DocumentTypes

This optional multi-select prompt allows the user to restrict the report to selected DocumentTypes. NOTE that currently the following is not true: "The LOV will list all DocumentTypes available in the Environments selected in the prompt above. Its LOV cascades from the Environments prompt so if no Environments are selected in the prior prompt then no LOV entries will be listed.

Layout¶

Layout

Hyperlinks

Drill ▼

Opens & refreshes [MM-W17] Webi IA - Dataprovider SQL (passing in the relevant parameters for the Drill), to get a detailed of the SQL used within the particular Webi Document.

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.

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.

Folder

Allows the user to filter the report results to a selected Folder Path.

Folder Type

Allows the user to filter the report results to a selected Folder Type.

Document

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

Document Type

Allows the user to filter the report results to a selected Document Type.

Document is Instance?

Allows the user to filter the report results to Instances or Non-Instances (**Yes* or No)*.

Universe

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

Connection

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