Dimensions are lists of related terms used to organize data and are used to construct Cubes, the modeling structures used for planning, analytics, and reporting on data.
The first step is to build Dimensions. One of the significant features of Olation® is that it permits a user to create a Dimension using common relational database components: tables, queries, and views. From relational tables, we define the component Members and configure other attributes for Dimensions. Again, as mentioned earlier, we will be creating four Dimensions from the existing SQL tables: Account, Version, Month, and Region.
Click the appropriate links to easily navigate to the corresponding sub-topics under this section: