[MM-U12] Unused Objects UNX¶
Lists every object of the selected UNX universes and whether any Web Intelligence document uses it.
Report document
Web Intelligence document [MM-U12] Unused Objects - UNX 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 UNX 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 UNX Objects - Detail | One row per universe object. |
Image of MM-U12 refreshed for one environment, Unused UNX Objects - Detail tab
../images/reports/mm-u12-layout.png
Legacy image for reference: images/mmsr_layout_MM-U12.png
Columns and measures¶
| Group | Columns |
|---|---|
| Universe | Environment, UNX, UNX CUID, UNX Folder, UNX Folder Path |
| Object | UNX Class, UNX Class Parent (Lineage), UNX Object, UNX Object ID (MM), UNX Object Ordinal, UNX Object Type |
| Use | UNX Object is Used?, UNX Object is Used in Report Layer?, UNX 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 | Type a value | Universe CUID, normally filled in by a drill link from another report. Leave empty when you refresh the report yourself. |
Image of the MM-U12 Prompts dialog with Environments answered
../images/reports/mm-u12-prompts.png
Legacy image for reference: images/mmsr_prompt_MM-U12.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, Unx Folder, Universe, Class, Object, Object Type.
Image of the MM-U12 Input Controls panel
../images/reports/mm-u12-input-controls.png
Legacy image for reference: images/mmsr_ICs_U12.png
Drill links¶
| 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¶
- In BI launch pad, open
[MM-U12] Unused Objects - UNXfrom the folder where you imported the standard report pack. - Refresh the document and answer the prompts.
- 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.
Related reports¶
- [MM-U10] Unused Objects Summary - summarises, per universe, how many of its objects Web Intelligence documents actually use.
- [MM-U11] Unused Objects UNV - lists every object of the selected UNV universes and whether any Web Intelligence document uses it.
- [MM-U13] Unused Objects Detail - lists, document by document, the universe objects each Web Intelligence data provider returns and whether the report layer uses them.
- [MM-U01] Universe Dictionary - describes UNV and UNX universes in full: summary, objects, joins, contexts, tables and restrictions.
- Reports and Data - all standard reports, shared prompts and delivery