Configuring charts for a Data Director dashboard

Back Next

Source Data

You choose the source data that you want to use in the chart. The source data comes from reports that collect information about your master data. You can also filter or group the source data used in charts.

Before you can generate reports or populate charts, you must configure the data mart database connection. Then you can populate the data mart with the report data. To populate the data mart with report data, run a java command to populate the data mart for all available reports, or for specific report. For more information about how to configure the data mart database connection, see the

Multidomain MDM Resource Kit Guide

Open a command prompt.

To populate the data mart with data for all available reports, run the following command:

java -jar populate_datamart.jar

To populate the data mart with data for a specific report, run the following command:

java -jar populate_datamart.jar exec <report name>

The C_REPOS_RPT_DETAIL table is populated with report data.

Configuring charts for a Data Director dashboard

Reports

You can use the out of the box reports to collect information about your records and tasks. The out of the box reports are available by default and collect information about predefined criteria. If you need to collect other types of information about your master data, you can create custom reports.

For example, you might use a report to collect information about the number of tasks assigned to each user. Or, you might use a report to collect information about the number of records added for each business entity type.

You must register the out of the box reports and custom reports that you want to use. For more information about out of the box reports, see Out of the Box Reports.

Filters

To narrow the focus of a chart, you can filter the source data used in the chart. You can filter the source data by data dimensions collected in the report.

For example, you might populate the chart with data collected by the out of the box Business Entities Added report. The report collects information about the number of records added for each business entity type and breaks down the records by year. The chart shows business entity growth trends for all business entity types. You can filter the source data to only include records created for the Person business entity type. Then the chart shows business entity growth trends for the Person business entity type.

You can also use filters to ensure that new data is included in the chart. For example, you might populate the chart with data collected by the Business Entities Added report and filter the data to only included records created for the Person business entity type. Then when users create new records for the Person business entity type, the chart displays the new data in the chart.

The following image shows a chart that displays the number of records created for the Person business entity type and breakdowns the records by year:

Chart settings to filter the source data

Group by

To segment data in a data series into groups, you can group the source data displayed in a chart by a criteria in the underlying data. The grouped data appears side by side or stacked. You might want to use the group by criteria for bar graphs.

For example, you might create a chart that shows tasks by status and then grouped by task type. The chart displays the tasks by status, with the data about each status grouped by task type.

The following image shows a chart with grouped data:

Rename Saved Search

Table of Contents

Configuring charts for a Data Director dashboard

Configuring charts for a Data Director dashboard

Source Data

Source Data

Reports

Filters

Group by