Page Comparison

{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{_}*.

h3. 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 |
!O3Designer-PropertiesPane-Description.png|align=center,vspace=10,hspace=10!\\

h3. 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. |
!O3Designer-PropertiesPane-General.png|align=center,vspace=10,hspace=10!\\

h3. 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 [o3eng: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. \\ |
!O3Designer-PropertiesPane-Redundancy.png|align=center,vspace=10,hspace=10!\\

h3. 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 |

h3. 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. |
!O3Designer-PropertiesPane-BuildActions.png|align=center,vspace=10,hspace=10!\\

h3. 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. |
!O3Designer-PropertiesPane-Properties.png|align=center,vspace=10,hspace=10!\\

----
{scrollbar}
{children}
\!O3Designer-PropertiesPane-BuildActions.png\|align=centre\!