Hichert Partner Logo

Follow @ibcs_a

EX 1.2  Use Appropriate Table types

A table is a communication object in which data is arranged in two dimensions, i.e. (vertical) columns and (horizontal) rows. The row header (row name) describes the content of a row, the column header (column name) the content of a column. The data are positioned at the intersections of rows and columns called table cells.


“One-dimensional tables” (tables with one or more columns but without row headers) are called lists and are not covered here.


Table types are defined by a set of columns and a set of rows in order to fulfill specific analytic and/or reporting purposes.


Column types

Column types are columns with similar content falling under similar column headers. Typical column types are time columns (with monthly or yearly data), scenario columns (with actual or plan data) and variance columns (ΔPL or ΔPY). More...


Row types

Row types are rows with similar content falling under similar row headers. Typical row types are measure rows (e.g. sales, cost, profit) or structure rows (e.g. Italy, France, UK). More...


Table types

Table types are distinguished by their analytic purpose in variance tables, time series tables, and cross tables, see figure SUCCESS rule EX 1.2. Tables serving more than one analytic purpose are called combined tables. More...




© 2015 IBCS Association. Except where otherwise noted licensed under Creative Commons BY-SA 4.0 International.