Model Properties

Unknown macro: {scrollbar}

The Properties Pane include the following sections that clasify the model information:

Description
General
Redundancy
References
Build Actions
Properties

These sections are common to both types of models created with the O3 Designer.

The Description Tab

Property	Description
Name	The specified name identifies the Model in the Designer. It will be suggested as the default name for the cube when building from inside the *O3 Designer*. It is recommended to use a short, significant name.
Description	Use the description to further identify the model, its contents, utility, etc. This is especially useful for cubes model shared among several users.
Namespace	Label that allows models to be grouped together under a given name

The General Tab

The General Tab defines general configuration aspects such as Null values, Parameters, Memory optimizations, etc.

Property	Description
For Null Values Use	Indicate the alternate label to substitute for null or blank values in fields from data source files or queries.
Error Mode	When generating a cube, you may encounter data inconsistent with the defined model. Choose the Ignore error mode to skip the data and continue Choose the Abort error mode to stop and indicate the problem Choose the Append error mode to include the data anyway in the cube
When Building Use Input Set	Choose the Input Set you want to use when building the cube from inside the O3 Designer. Only the Input Sets of type Full can be selected. For using an Incremental Input Set you must use the O3 Builder. If only one Input Set of type Full is defined on the cube model, the option will be disabled. See About Input Sets.
Parameters	Define parameters to use for: Substituting values in the data sources definition (for example: the path for the text data source files) Substituting values in a Virtual Field definition Substituting values in a Derived Measure definition Controlling an incremental build processThe parameters uses default values (assigned on the cube model definition) or values assigned during the build. Defining a build parameter includes declaring the name, the default value, the type and whether it is used in controlling an incremental build. It is possible to use expressions when defining the default value (for example: =today() )
Input Sets	Each data source must belong to at least one input set, and each input set must include all necessary sources for a complete cube build. You can define Full or Incremental input sets. See About Input Sets.
Block Size	It defines the block size used to transfer registers between the disk and the cache.
Min Cache	It's the minimum size of cache memory that will be used to build the cube. It's measured in blocks, of the size given by the Block Size parameter.
Max Cache	It's the maximum size of cache memory that will be used to build the cube. It's measured in blocks of the size given by the Block Size parameter. This parameter specifies the possible maximum number of blocks in the memory while the cube is being built. It's also the maximum cache size that will be used when running the cube in Standalone mode and the default maximum cache size when running the cube in an O3 Server. The administrator can modify it at runtime from the AdmServer tool when running in an O3 Server.

The Redundancy Tab

Redundancy is a mechanism that allows O3 to optimize queries by storing pre-calculated data at build time.

O3 can define redundancy in several ways that, depending on the particular needs, can be chosen from when optimizing the cubes.

More details about the redundancy mechanism can be found in the section Optimizing query performance.

Property	Description
Redundancy Method	Each redundancy method defines a redundancy policy for the cube. Some of the methods are completely automatic, while others give more control to the cube designer. Apart from the predefined methods there's a manual method in which the designer can define the redundancy levels to be included in the cube one by one. The redundancy methods available are: None Top Most Fixed Level 1 Fixed Level 2 Automatic Manual
Estimate Total Number of Tuples	The designer can indicate through this option "and estimate of the total of tuples to be included in the cube, to be used instead of the algorithm's estimate. To be used with the Automatic redundancy method only.
Maximun Tuples to Scan	The parameter is the maximum number of tuples to scan (and summarize) in the worst of cases to answer a query. This restriction in practice sets a limit to the answering time of any query. To be used with the Automatic redundancy method only.
Redundancy Levels	If you have selected the Manual method, the redundancy levels should be entered in the "Manual Redundancy Configuration" section through the Add Level button. Once the redundancy level has been added, the level number for each dimension should be specified.
Generate Redundancy on Loading Time for Phases Up To	All the redundancy phases between 0 and the value specified here will be calculated while data is loaded in the cube. A different value can be used for incremental loads.
Generate Redundancy After Building for Phases Up To	All the redundancy phases between the value specified for Loading Time and the value specified here will be calculated at the end of the cube building. A different value can be used for incremental loads.

The References Tab

When a model includes references to other public dimensions models, the user can manually declare these references so that they are already available when needed.

Property	Description
Prefix	Displays the prefix associated to the elements in the public dimensions model
Namespace	Displays the namespace associated to the model
Location	Identifies the public dimensions model used

The Build Actions Tab

Property	Description
Use this SMTP Server to send mail	O3 uses SMTP support for sending notification e-mails. Enter the SMTP server name or IP address you are using to send e-mails.
Use this e-mail address as Sender	Enter the e-mail address that must appear as the sender of the messages
Inform After Building	For each possible build finish status in the list, identify the e-mail recipients (persons to be informed)
Retries	For each possible build finish status in the list, determine number of trials, frequency of them (in minutes), and e-mail recipient.

The Properties Tab

Property	Description
Domain	Identify the domain of the Cube, such as the country, using extensions. For example, c=CA indicates the country is Canada.
Password	If you wish, enter a password to restrict access to a Cube. This makes sense only when the cube is going to be used in Standalone mode. The security mechanisms of the O3 Server should be used in other cases.
Author	If you wish, enter the name of the author of the cube model.
Theme	If you wish, enter the expected use of the cube.
Organization	If you wish, enter the organization the cube belongs to.
Category	If you wish, enter information to further describe the cube.
Keys	If you wish, enter additional information to further describe the cube.

Unknown macro: {scrollbar}