• Contents
  • Index

Altair® Monarch®

 

Working with Monarch Classic Files

Monarch Data Prep Studio allows you to work with existing Monarch Classic models and projects.

This means you can take advantage of the robust templating and extraction capabilities of Monarch Classic and use pre-defined models to work with reports.

However, note that tables that come from Monarch Classic files may behave a little differently from tables that come from other sources:

  • Tables associated with a Monarch Classic file are not displayed on the Preview window.

  • Data from reports associated with a Monarch Classic file are displayed as tables on the Prepare window but cannot be prepped.

The following Monarch Classic features are translated in Monarch Data Prep Studio when you open a Monarch Classic file:

  • Data captured via all trap types

  • Multi-column regions

  • Formula-based calculated fields using all built-in Monarch Classic functions

  • Named filters

  • Named sorts

  • Lookup-table calculated fields

  • Multiple reports

  • PDF reports

  • Projects that use databases

  • Projects with named exports (some exceptions are listed below)

  • External lookups

  • Runtime parameter fields

  • Summary definitions

 

The following features in Monarch Classic models are currently not supported in Monarch Data Prep Studio:

  • User-defined functions – Fields that use user-defined functions are displayed in Monarch Data Prep Studio with null values.

  • External Models – External model definitions within a Monarch Classic model are simply ignored when the model is imported into Monarch Data Prep Studio.

  • User-edited fields – User-edited fields are displayed in Monarch Data Prep Studio with null values.

  • Redaction of report fields – Monarch Data Prep Studio does not support Consistent Alias Replacement (CAR)-type redactions. In the case where the Monarch Classic model specifies a CAR redaction for some field, the Monarch Data Prep Studio substitutes a non-CAR redaction change that best emulates the CAR redaction specified.

  • Projects with inputs and models from S3, HTTPS, and FTPS (i.e., web sources that require authentication)

  • Bookmarks – Any bookmarks present in the Monarch Classic model are ignored in DPS

  • Report colors – Any report colors specified in the Monarch Classic model are ignored in DPS

  • Report index – Any report index definitions present in the Monarch Classic model are ignored in DPS

 

The following Monarch Classic project exports are currently not supported in Monarch Data Prep Studio:

  • Report exports

  • CAR Map exports

  • PDF (.pdf)

  • dBase (.dbf)

  • Fixed text (.txt)

  • Tableau Data (.csv) (NOTE: Tableau TDE and Tableau Server exports are imported)

  • Web File (.htm, .html)

  • ODBC

  • OleDb

  • Panopticon

  • Custom

  • Access exports using a password

  • Access exports using Update or UpdateAndAppend

  • Any export specifying a column mapping (Excel, Access, ODBC, and OleDb file types)

  • Any export specifying an Update Exception File (Access, ODBC, and OleDb file types)

 

Opening Monarch Classic files

Steps:

  1. Select Open Data from the start page and then select Monarch Classic File from the Select Data Source dialog.

  2. Navigate to the file you want to open on the Open dialog.

  3. Select the file and then click Open.

Working with Monarch Classic projects

If you open a Monarch Classic Project, the model is represented as a table on the Prepare window. Reports associated with model are represented as "sub-tables."

Selecting the report associated with a Monarch project displays the report in Report View.

 

Right-clicking anywhere in Report View displays a context menu that allows you to:

  • Edit the report in Report Design

  • Copy selected text

Notes:

  • You can Prep, Transform, and Combine data if you select the main (model) table.

  • You can only view the data if you select a report (you cannot Prep, Transform, and Combine data).

  • Add more reports by selecting the drop-down beside the main table and selecting Add Report.

  •  

    You must select a report that is compatible with the model you opened.

  • Edit a report's file path by selecting the drop-down beside the main table and selecting Edit File Path.

  •  

  • Modify the model associated with a Monarch Classic file by selecting Edit in Report Design.

  •  

  • To delete a report, right-click on the report you want to delete and select Remove Report from the context menu:

  •  

  • If you open a Project that uses a model that cannot be located, Monarch Data Prep Studio will display a dialog box telling you that the model cannot be found. Click the Browse button to look for the model and point the model to the correct location.

  •  

    A similar dialog is produced if the report associated with a model cannot be found.

 

Working with Monarch Classic models

If you opened a Monarch Classic model, the model is represented as a Table on the Prepare window. At this point, no data are displayed:

 

To view data, you must add reports compatible with the model. To do so, select the drop-down beside the main table and select Add Report:

 

Note:

  • You can Prep, Transform, and Combine data only if you select the main table. You can only view the data if you select a report (you cannot Prep, Transform, and Combine data).

  • When a project/model containing elements not supported by Monarch Data Prep Studio is loaded into the application, a warning popup will display.