Skip to content

[MM-U11] Unused Objects UNV

Lists every object of the selected UNV universes and whether any Web Intelligence document uses it.

Report document

Web Intelligence document [MM-U11] Unused Objects - UNV from the MetaMiner standard report pack. It reads the MetaMiner Database (MMDB) through the MetaMiner Standard universe. See Reports and Data.

What it answers

  • Which objects of a UNV universe no document uses?
  • Which objects are used in queries but never shown in a report.
  • How many documents use each object.

Who uses it: Universe designers removing or hiding unused objects.

Report tabs

Tab Shows
Unused UNV Objects - Detail One row per universe object.

Image of MM-U11 refreshed for one environment, Unused UNV Objects - Detail tab

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

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

Columns and measures

Group Columns
Universe Environment, UNV, UNV CUID, UNV Folder, UNV Folder Path
Object UNV Class, UNV Object, UNV Object ID, UNV Object Type
Use UNV Object is Used?, UNV Object is Used in Report Layer?, UNV Object is Used (Webi Doc Count)

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.
Universes No Pick one or more Universes to include.
UniverseCUID No Pick one Universe CUID, normally filled in by a drill link from another report. Leave empty when you refresh the report yourself.

Image of the MM-U11 Prompts dialog with Environments answered

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

Legacy image for reference: images/mmsr_prompt_MM-U11.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.

Filter controls keep only the rows that match the values you pick: Object is Used?, Object is Used in Report Layer?, Environment, Unv Folder, Universe, Class, Object, Object Type.

Image of the MM-U11 Input Controls panel

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

Legacy image for reference: images/mmsr_ICs_U11.png

Link Opens
Universe drill Opens [MM-U13] Unused Objects Detail 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-U11] Unused Objects - UNV from the folder where you imported the standard report pack.
  2. Refresh the document and answer the prompts.
  3. Use the input controls to change the display or narrow the results.

Data it needs: Universe processing (UNV and UNX) plus Web Intelligence document processing, which records where each object is used. See Document Processing.