1. Profitability Analytics Cloud Service User Guide
  2. Reports & Analytics
  3. Operational Analysis
  4. Tables and Partitions Report

9.3.7 Tables and Partitions Report

The Tables and Partitions Report displays all the tables, partitions, and subpartitions into PACS and PBSM schema for monitoring the details in the tables.

To open the Tables and Partitions Report, from the LHS menu, select Operational Analysis, and then select Tables and Partitions Report.

The Tables and Partitions reports section is arranged as a set of canvases, classified into the following:

  • PA Tables and Partitions
  • PA Tables and SubPartitions
  • PBSM Tables and Partitions
  • PBSM Tables and SubPartitions

Report Filters

You can use a series of canvas-level pinned Prompts to filter the data according to Functional Key Attributes as follows:

Figure 9-34 Canvas Prompt Filters


Canvas Prompt Filters

The following filters are available:

  • Table Name: To select/search for a specific Table Name.
  • Partition Name: To select/search for a specific Partition Name.
  • Subpartition Name: To select/search for a specific Subpartition name.

PA Tables and Partitions

The ALL views show the Partitions as the case be in the PACS Schema.

The two target cloud charts present are: Table Name, Partition Name. You can click on a specific Table or Partition name in the Target Cloud chart to get finer level details on number of rows and checksum.

The table view details present: Table Name, Partition Name, RowCount, and CheckSum.

Figure 9-35 Operation Analysis - Tables and Partitions


Operation Analysis - Tables and Partitions

PA Tables and SubPartitions

The ALL views show the SubPartitions as the case be in the PACS Schema.

Figure 9-36 Operation Analysis - Profitability Analytics Cloud Service Tables and Partitions


Operation Analysis - Tables and Partitions

PBSM Tables and Partitions

The functionality of this canvas is similar to PACS canvas of the same name. The ALL views show the Partitions as the case in the PBSM Schema.

Figure 9-37 Profitability and Balance Sheet Management Cloud Service Tables and Partitions


Profitability and Balance Sheet Management Cloud Service Tables and Partitions

PBSM Tables and SubPartitions

The functionality of this canvas is similar to PACS canvas of the same name . The ALL views show the SubPartitions as the case in the PBSM Schema.

Figure 9-38 Profitability and Balance Sheet Management Cloud Service Tables and SubPartitions


Profitability and Balance Sheet Management Cloud Service Tables and SubPartitions