How the Data in IRIS Analytics is Structured

IRIS Analytics stores and structures the data from your PS Accounting database in a very specific way, in order to optimise the data for analysis. It is useful to understand the principles of how the data is stored and the terminology used, as this will be helpful when carrying out data analysis and constructing reports.

The following terms are used within the software and are described in the following sections:

Overview of Cubes

Overview of Dimensions

Overview of Members

Overview of Measures

Overview of Attributes

Overview of Hierarchy

Overview of MDX

Overview of Slicing and Dicing

Overview of Roll-up

Overview of Drill-down