Skip to content

[MM-W10] Object Use Overview

Shows which universe objects and other data source objects are used in which Web Intelligence documents, and how often.

Report document

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

What it answers

  • Is this universe object used in any Web Intelligence document, and where?
  • Which documents would a change to an object or data source affect?
  • How many objects each document uses, and how many times.

Who uses it: Universe designers and BI CoE leads doing impact analysis before changing or removing objects.

Report tabs

Tab Shows
Webi IA - Object Use Overview One row per document and object, with object and occurrence counts.

Image of MM-W10 refreshed for one environment, Webi IA - Object Use Overview tab

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

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

Columns and measures

Group Columns
Document Environment, Document, Document Description, Folder Type, Folder Name, Folder Path Complete
Data source DP Type, Datasource, Universe CUID, Universe Unbound
Object Class, Object, Object ID, Location (where in the document the object is used)
Measures Nbr Objects, 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-W10 Prompts dialog with Environments answered

../images/reports/mm-w10-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.
Number Format Switches large numbers to a short format, for example K for 1,000s.

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

Image of the MM-W10 Input Controls panel

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

Legacy image for reference: images/mmsr_ICs_W10.png

Link Opens
Document name Opens the document in BI launch pad.
Document drill Opens [MM-W12] Object Use Detail for that document.
Universe drill Opens [MM-U11] Unused Objects UNV or [MM-U12] Unused Objects UNX for that universe.

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-W10] Webi IA - Object Use Overview 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.