instantOLAP Online documentation 2.6.1 - Good model design

Good model design

A good model design has an important impact on the performance of your queries and the whole system. Here are some basic rules you should have in mind when creating new models:

Contents of this chapter:

Make models reusable
What should become a dimension, attribute or fact?
Naming conventions

Using the Web-Frontend
Using the Workbench
Using the Query-Editor
Using the Config-Editor
Concepts
A quick overview
Models
Structure of a query
How instantOLAP works
Good model design
Make models reusable
What should become a dimension, attribute or fact?
Naming conventions
Query properties
Chart properties
Configuration properties
Expressions
Formats
SQL-Expressions