Analyze Your Cube

You can analyze your cube as follows:
tdm10
You can analyze your cube as follows:
2
2
Repository Coverage Metrics
  1. Open the Datamaker UI and select
    Data Profiler, Repository Coverage Metrics
    from the main menu.
  2. Select the cube that you want to view from the drop-down list.
    This selection automatically places the appropriate columns into the selected columns pane. To deselect/select available columns, click on the column name and use the arrow buttons to move between panes.
  3. Click the tick mark icon after you are done with your selection.
    The
    Repository Coverage Metrics
    dialog opens.
  4. Click the tick mark icon in the top-right corner to recalculate the coverage and perform the analysis.
    The top pane provides a statistical summary of the coverage in the chosen cube view. This information includes the number of distinct values, number of possible combinations, and total coverage. The bottom pane of the summary tab identifies coverage weaknesses in specific columns and combinations. The exclamation mark icon identifies normal weaknesses; the cross mark icon represents severe weaknesses.
  5. To find out more about each column, click on the corresponding tab at the top of the dialog.
    The top pane shows a statistical summary of distinct values. The bottom pane shows an analysis of the coverage across that column. This analysis shows the total number of paired combinations and the combinations found. This information lets you quickly identify the weaknesses in your coverage for each different combination.
  6. You can export a coverage to a CSV file by clicking table icon. 
  7. Select the reports that you want to generate and then click the tick mark icon button to generate them.
    You can also place constraints on the cube so that only valid combinations of data are considered rather than all possible combinations. For instance, you can have a rule where a person can only have one type of account that is associated with them (and persons with more than one type of account would be considered a data error). To do so, select a constraint from the drop-down list in the top-right corner.
Repository Find Duplicates
  1. Open the Datamaker UI and select
    Data Profiler, Repository Find Duplicates
    from the main menu.
  2. Select the cube that you want to view from the drop-down list.
  3. After you select all the appropriate columns, click the tick mark icon to find the duplicate values. 
    A dialog showing a report about the presence or absence of the duplicates opens.