Skip to content

[MM-W12] Object Use Detail

Shows every place a universe object is used inside Web Intelligence documents: report tab, element, variable and expression.

Report document

Web Intelligence document [MM-W12] Webi IA - Object Use Detail from the MetaMiner standard report pack. It reads the MetaMiner Database (MMDB) through the MetaMiner Standard universe. See Reports and Data.

What it answers

  • Exactly which report tab, table, chart, filter or variable uses an object.
  • The formula or expression that references the object.
  • What breaks in a document if the object changes.

Who uses it: Report developers and universe designers fixing or planning a change to specific documents.

Report tabs

Tab Shows
Webi IA - Object Use Detail One row per use of an object in a document.
Webi IA - Object Use (alt view) Alternative view of the same data.
Webi IA - Object Use (mirror alt view) Alternative view of the same data.

Image of MM-W12 refreshed for one environment, Webi IA - Object Use Detail tab

../images/reports/mm-w12-layout.png

Legacy image for reference: images/mmsr_layout_MM-W12.png

Columns and measures

Group Columns
Document Environment, Document, Folder Type, Folder Name, Folder Path Complete, Report Tab, Report Tab Ordinal
Where used Location, Location: Expression, Element Name, Element Type, IsBlock, Variable, Variable Definition, Cell Expr, DP Expr, Expression
Object Dataprovider, DP Type, Datasource, Universe Unbound, Class, Object
Measures Nbr Occurances

Prompts

Prompt Required Answer What it does
Environments No Pick one or more Environments to include, listed by CMSID with their description. Leave empty for all. The prompts below list only values from the environments you pick.
FolderTypes No Pick one or more Folder types to include.
FolderPath Yes Pick one Folder path pattern, matched with LIKE. Enter % for all folders.
Folders No Pick one or more Folders to include. The list depends on the prompts above.
Documents No Pick one or more Documents to include.
Datasources No Pick one or more Data sources (universes and other sources) to include.
Objects No Pick one or more Universe objects to include.

Image of the MM-W12 Prompts dialog with Environments answered

../images/reports/mm-w12-prompts.png

Legacy image for reference: images/mmsr_prompt_MM-W10.png

Input controls

Display controls change how the report shows its data:

Input control What it does
Prompt Selection Shows or hides the block under the header that lists your prompt answers. Spaced (default) shows it with a space between list items, Show shows it without spacing, Hide hides it.
Environment / CMSID Shows environments in the report body by display name or by CMSID. Filters and prompts always list CMSIDs.
Folder / Complete Shows the folder name or the complete folder path.

Filter controls keep only the rows that match the values you pick: Environment, Folder, Document, Report, DP Type, Location, Element Type, Datasource, Object.

Image of the MM-W12 Input Controls panel

../images/reports/mm-w12-input-controls.png

Legacy image for reference: images/mmsr_ICs_W12.png

Link Opens
Document name Opens the document in BI launch pad.

A drill link opens the target report through BI launch pad OpenDocument and passes the environment and the selected item as prompt answers.

Run the report

  1. In BI launch pad, open [MM-W12] Webi IA - Object Use Detail from the folder where you imported the standard report pack.
  2. Refresh the document and answer the prompts. Keep FolderPath at % to include all folders.
  3. Use the input controls to change the display or narrow the results.

Data it needs: Web Intelligence document processing (data providers, queries, report elements and variables of each document). See Document Processing.

  • [MM-W10] Object Use Overview - shows which universe objects and other data source objects are used in which Web Intelligence documents, and how often.
  • [MM-W11] Object Use per Object - shows, object by object, which Web Intelligence documents and data providers use each universe object.
  • [MM-W17] Data Provider SQL - lists the SQL of each Web Intelligence data provider, with row counts and refresh times, and finds documents whose SQL contains a search term.
  • Reports and Data - all standard reports, shared prompts and delivery