Sharing Mapping Specification Logic > Mapping Specification Export to Microsoft Excel
  

Mapping Specification Export to Microsoft Excel

Export the mapping specification logic to Microsoft Excel to share the mapping specification logic with business teams who do not have access to the Analyst tool.
After you export the mapping specification logic to Microsoft Excel, you can choose to open the file in Microsoft Excel, or save the file to another location. Analysts can edit the file and upload it to a shared location for further review. Analysts can then edit the mapping specification to incorporate the review comments.

Exporting a Mapping Specification to Microsoft Excel

Export the mapping specification logic to Microsoft Excel to document, share, and review the mapping specification logic.
    1. From the Actions menu, select Export.
    The Export wizard appears.
    2. Select Excel.
    3. Click Next.
    4. Enter a name for the Microsoft Excel file.
    By default, the Analyst tool uses the mapping specification name to name the Microsoft Excel file.
    5. Click Finish.
    A browser pop-up enables you to open or save the file.

Mapping Specifications in Microsoft Excel

After you export the mapping specification logic to Microsoft Excel, you can view the mapping specification objects, properties, and relationships between objects in separate worksheets in an Excel workbook.
The following mapping specification logic appears in the Microsoft Excel workbook:
Column Mapping
Contains the following information that appears in the Column Mapping view of the mapping specification:
Contains hyperlinks for any columns related to mapping specification objects. Click a hyperlink to access the related object in another worksheet.
Properties
Contains the mapping specification properties.
Expressions
Contains any expressions that appear in aggregators, lookups, and rules.
Filters
Contains the expressions that appear in filters.
Joins
Contains the following join information between sources: