Skip to content

[MM-D01] Activity and Data Source

Lists documents of every type with their data providers, universes or connections, and when and by whom they were last touched.

Report document

Web Intelligence document [MM-D01] Documents - Activity & Datasource 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 documents use a given universe or connection?
  • When was each document last used, and by whom?
  • Which data source each data provider of a document reads.

Who uses it: BI CoE leads and administrators doing impact analysis and content cleanup across document types.

Report tabs

Tab Shows
Documents - Activity & Datasource One row per document and data provider.

Image of MM-D01 refreshed for one environment, Documents - Activity & Datasource tab

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

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

Columns and measures

Group Columns
Document Environment, Document, Document CUID, Document Type, Document Type (Parent if Instance), Document is an Instance?, Folder Type, Folder Name, Folder Path Complete
Data source Document DP, Document DP Type, Document DP Universe, Document DP Universe Updated, Document DP Universe Unbound, Document DP Data Connection
Crystal Reports Crystal Doc, Crystal Doc contains a Sub Report?, Crystal Doc has Command Text (directly or in Sub Report)?
Activity Audit (Last Touched) Max Date Time, Audit (Last Touched) User

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.
DocumentTypes No Pick one or more Document types to include, for example Web Intelligence or Crystal Reports.
Universes No Pick one or more Universes to include.

Image of the MM-D01 Prompts dialog with Environments answered

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

Legacy image for reference: images/mmsr_prompt_MM-D01.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, Folder Type, Document, Document Type, Document is Instance?, Universe, Connection.

Image of the MM-D01 Input Controls panel

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

Legacy image for reference: images/mmsr_ICs_D01.png

Link Opens
Document name Opens the document in BI launch pad.
Web Intelligence SQL drill Opens [MM-W17] Data Provider SQL for that document.
Crystal command text drill Opens [MM-C17] Command Text Use for that report.

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-D01] Documents - Activity & Datasource 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: Document data from the regular pull, plus Web Intelligence and Crystal Reports document processing for data providers and connections, and audit data for the last-touched columns. See Document Processing and Audit and CMS Databases.