instantOLAP Online documentation 2.2.7 - Importing other models

Importing other models

Model imports are used to make models easier to administrate because often used dimensions can be defined once in one or more master models and then be used in multiple other models. Therefore you need to define frequently used dimensions (like the time-dimension) only once and can use it in a large number of other models.

Also, using imported dimension can save system resources, because imported dimension allow to share the physical dimension between models. Imported dimension don't have to be synchronized by the importing models and they do not use memory or disc space in the importing model.

Imported dimensions

Each model can import an arbitrarily number of other models. From each imported model all dimensions except the fact dimension will imported and be available for Cubes and queries using the dimension.

If a imported model contains a dimension which is already defined in the importing model or a previously imported model, it will not be added to the importing model.

Imported dimensions

Importing models can be nested. If you import a model which already imports other models, your model will contain all dimensions being defined in the imported model or the models imported by this.

Importing models will only import their dimensions together with their access rules. Facts, Cubes, Caches, Formulas and so on will not be transferred into the target models.

Using the Web-Frontend
Using the Workbench
Using the Query-Editor
Using the Config-Editor
Models and configurations
Models
Configurations
Dimensions, Keys and Hierarchies
Facts
Cubes
Formulas
Caches
Stores
Importing other models
Starting the Config-Editor
Query properties
Chart properties
Configuration properties
Expressions
Formats
SQL-Expressions