3.2 Navigating Tables

Selecting Tables

Once you have selected the tables to be initialised, Report Authority will display the first table in the Tables panel:

Tables can be selected by using either the table selector dropdown box, or by cycling through them using the up and down arrows to the right of the dropdown box:

Working with Tables

Fixed Tables are represented as a series of rows and columns and are generated as described by the XBRL taxonomy:

A table will consist of row and column headers, and the intersection points are called data points.  

Data Points

Valid data points as defined by the taxonomy are clearly indicated and are selectable such as r010c010 above. Invalid intersection points such as r010c020 are represented as a grey cell and cannot be selected.

Row and Column Headers

Row and column headers not only describe the data requirements, they are also a useful tool for selecting or automating data points.  

If you click on the Carrying Amount column header – all data points in that column are selected. 

Furthermore, if you click on the merged Debt Securities row header, all data points in the r050-100 rows for all columns will be selected.

When automating data points with HFM or Essbase (see External Data Connections), dimension members can be dropped onto individual cells, or groups of cells as defined by the row and column headers.  

Data Point Shading

The data point is coloured to indicate data source type.  It highlights which cells are linked to which data sources, such as HFM (red), Essbase & SQL (purple), Excel (green) Manual (white), or Calculation (orange). These are distinguished by colour codes as follows:

In the example above, r060c010 has not been automated, r070c010 is an automatically calculated subtotal, r080c010 is linked to Excel, r090c010 is linked to HFM and r091c010 is linked to Essbase (SQL connections are also represented by purple shading).

Data Point Values

The Value Editor Panel will appear beneath the table when you select a single data point.  The Value Editor Panel controls where the value comes from, what it represents, and how it is displayed. (See Data Point Values for more information.)

Still need help? Contact Us Contact Us