Analyzing a Profile - discovery - 23.1

Spectrum Discovery Guide

Product type
Software
Portfolio
Verify
Product family
Spectrum
Product
Spectrum > Discovery
Version
23.1
Language
English
Product name
Spectrum Discovery
Title
Spectrum Discovery Guide
First publish date
2007
Last updated
2024-02-07
Published on
2024-02-07T17:21:58.768552

After a profile is created and listed, you can send it for analysis. The profile is analyzed based on the rules selected for it and a report gets displayed on the Data Profiling Results page. The report can also be sent directly to the targeted users if you specify this on the Add Profile page and you can also download it as a PDF or Excel document.
Note: The report can be downloaded as an Excel document only at profile and table level.
The profile analysis can be run as a one time activity or a recurring event by scheduling the recurrence in the Add Schedule page. You can also start analysis directly from the Profiles tab. In all these cases the analysis is run and the status displayed on the Profiles and the History tab.
When a profile starts getting analyzed, a unique ID is assigned to it, which is displayed on the History tab. For more information, see Viewing Analysis History.
Note: If the same profile is sent for analysis multiple times, every analysis is assigned a different ID.
To run profile analysis from the list of profiles displayed on the Profiles tab, perform these steps:
  1. In a web browser, go to:

    http://server:port/discovery

    Where server is the server name or IP address of your Spectrum Technology Platform server and port is the HTTP port. By default, the HTTP port is 8080.

  2. Log in with your credentials.
  3. On the Home page, click Profile & Monitor.
  4. From the list of profiles displayed, select the check box corresponding to the one you want to analyze, and click the Run Profile icon .
    Note: You can search for the required profile by using the type-ahead Filter text box. It helps you search on the basis of the Name, User, or Data Source of the profile.
    The selected data set of the profile starts getting analyzed, with the Status column showing the in-progress icon. The icon turns to a tick mark when the profiling is complete. The other details displayed for the profile are:
    • Name: The name of the profile. Clicking on the profile name takes you to the Data Profiling Results page. For more information, see Data Source Details in Profiling Results.
    • Data Source: The source of the data in the profile being analyzed. It can be a physical or logical model or a direct data source connection.
    • User: The user who created the profile
    • Last Run Start Time: The date (in mm/dd/yy format) and time (in hh:mm and AM/PM format) when the most recent profile analysis started
    • Last Run End Time: The date (in mm/dd/yy format) and time (in hh:mm and AM/PM format) when the most recent profile analysis completed
    • Duration: The duration (in mm:ss) of the analysis
    • Status: If the analysis is in progress, complete, or failed
    • Tables analyzed
    • Records analyzed
    • Suggestions: Click the suggestions icon to view the suggestions. You can copy the Recommendations provided in the form of groovy scripts and further use those in the Enterprise Designer.
    • Reports: Click the PDF or Excel icon to download the analysis report. In case the profiling hits some roadblock, you can view the error in this field.