Viewing Cell Summary

The Cell Summary Window provides the non-derived cells or MDRMs configured as a part of the solution for the corresponding schedule under a report. Select the Schedule Code in the Schedule Summary Window to navigate to the Cell Summary window (as shown in Error! Reference source not found.).

For example, the Cells for Schedule Part7 Summary Window under the CRSA Report is displayed as follows.

Figure 62: Cell Summary Window

Description of the Cells for Schedule window follows This illustration shows the cell information for the schedule.

 

NOTE:   

You can view the summary of all the configured reports in the Tile view Tile View Tile View Icon or List viewList View List View Icon.

 

The Search Bar helps you to find the required information from the database. You can enter the nearest matching keywords to search and filter the results by entering information on the search box. You can search for a Cell using either the name or description.

The Paging Option (Error! Reference source not found.) at the bottom right corner allows you to see more reports than the ones currently displayed on the window.

 

NOTE:   

Select the Return Return Icon icon on the top right corner to return to the Report Summary Window.

 

Topics:

·        Cell Information 

·        Derived Entity 

·        Measure 

·        Filters 

Cell Information

Each tile or list on the Cell Summary Window corresponds to one cell or MDRM under the schedule. For each cell, you can view the MDRM Name, count of Utilized Derived Entities, count of Utilized OFSAA Hierarchies, and Measures for that cell.

For example, the cell CRSAR040C180 tile is displayed as follows. Select the cell or MDRM Code to navigate to the Cell Information Window.

Figure 63: Cell Information

Description of Cell Information window follows This illustration shows the cell details derived from a report.

The Cell Information window is displayed as follows.

Figure 64: Cell Information Window

Description of the Cell Information window follows This illustration shows the cell information such as Derived Entities, Measure, Filters, regulatory Report Cell Identifier and Cell Dimension.

Each section in the Cell Information Window displays the relevant OFSAA Metadata and filters used for the cell.

Derived Entity

This displays the name of the OFSAA Materialized View or View that contributes to the Cell.

Measure

This displays the name of the OFSAA Measure that is reported for the particular Cell.

Filters

The Filter conditions are as follows:

1.     All filters that are applied to the cell are displayed under the filter section. It displays all the applied filters as their OFSAA Description.

2.     On selection, the filter is marked by a Filter icon Filter icon sign on the top left corner of the selected filter.

3.     The section that follows displays the entity or table on top of which the filter is based and the OFSAA Level Description for the selected filter.

4.     All filter values that apply to the particular MDRM are available as a ribbon. Each filter value is in a separate box.

For example, in the previous case for MDRM CRSAR040C180, the applied filters are Consolidation Code and Reporting Line Code. Currently, the Consolidation Code filter is selected and the required filter values for the same are 100.

In the case of multiple values, the filters are displayed as follows with an arrow mark.

Figure 65: Multiple Filter Values

Description of the Multiple Filter Values window follows This illustration shows the Multiple Filter Values window, you can select the Move icon to view the filters.

The filters in case of not in condition are highlighted in red are displayed as follows.

Figure 66: Not in Condition Filters

Description of the Not in Condition Filters window follows This illustration shows the Not in Condition Filters window, where the filters that are not in condition are highlighted in red.