Data Discovery Guide

10.5.1
- 10.5.7
- 10.5.6
- 10.5.2
- 10.5
- 10.4.0

Back Next

Adding Columns to an Existing Scorecard

After you run a profile, you can add columns to an existing scorecard.

Click a profile to open it.

The profile results appear in the summary view.

Select a column. Click

Actions

Add to scorecard

The

Add to Scorecard

wizard appears.

Use the following rules and guidelines before you add columns to a scorecard:

You cannot add a column to a scorecard if both the column name and scorecard name match.

You cannot add a column twice to a scorecard even if you change the column name.

Select

Existing Scorecard

to add the columns to a predefined scorecard. Click

In the

Step 2 of 7

screen, select the scorecard that you want to add the columns to. Click

You can view the existing metrics and metric groups associated with the scorecard.

In the

Step 3 of 7

screen, select the columns and rules that you want to add to the scorecard as metrics. Optionally, click the check box in the left column header to select all columns. Click

Column Name

to sort column names. Click

In the

Step 4 of 7

screen, you can create filters for the metrics. You can also apply the filter that you created for the profile to the metrics.

In the

Step 5 of 7

screen, you can perform the following tasks:

In the

Metrics

pane, select each metric and configure metric values in the other panes.

In the

Score using: Values

pane, select multiple values in the

Available Values

pane, click the right arrow button to move the values to the

Valid Values

pane.

The total number of valid values for a metric appears at the top of the

Available Values

pane.

In the

Metric Thresholds:

pane, you can set thresholds for

Good

Acceptable

, and

Unacceptable

scores.

In the

Cost of invalid data

, you can:

Select each metric and configure the cost of invalid data for the metric.

Select

Fixed Cost

option to assign a constant value to the cost for the metric. You can click

Change Cost Unit

to change the unit of cost.

Select

Variable Cost

option to attach a numeric column as a variable cost to the metric. You can click

Select Column

to select a numeric column.

Click

In the

Step 6 of 7

screen, you can perform the following tasks:

Select the metric group to which you want to add the metrics.

In the

Default - Metrics

pane, you can double-click the default metric weight of 0 to change the value.

In the

Metric Thresholds:

pane, you can set thresholds for

Good

Acceptable

, and

Unacceptable

scores.

Click

In the

Step 7 of 7

screen, select a run-time environment.

Click

Save

to save the scorecard, or click

Save & Run

to save and run the scorecard.

Scorecards in Informatica Analyst

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Data Discovery Guide

Data Discovery Guide

Adding Columns to an Existing Scorecard

Adding Columns to an Existing Scorecard