Deployment Scenarios and Streaming Cube Building Property Considerations

For cube deployment, Essbase Studio provides three data-retrieval mode options:

Use of these modes depends on how you have set the streaming cube building property, server.essbase.streamingCubeBuilding, as described in this topic.

For information about setting the server.essbase.streamingCubeBuilding property, see server.essbase.streamingCubeBuilding.

Nonstreaming mode, with the connection string derived by Essbase Studio Server (the default)

server.essbase.streamingCubeBuilding=false

In the Cube Deployment Wizard, select ODBC (Essbase dynamically creates ODBC connection string).

This option allows Essbase to conveniently establish connection to a data source during deployment and assumes default values for all connection attributes. In this case, Essbase Studio uses ODBC drivers during deployment.

Nonstreaming mode, with user-provided ODBC DSN

server.essbase.streamingCubeBuilding=false

In the Cube Deployment Wizard, select ODBC (Enter ODBC DSN name), and enter an ODBC DSN that you have previously set up.

This option allows Essbase to take advantage of the attributes specified in an ODBC DSN. For example, if the Essbase model that you are deploying is based on a Unicode data source, you can create an ODBC DSN with “N-CHAR Support” enabled, and then specify this DSN at deployment time.

Streaming mode, with the connection string derived by Essbase Studio Server

server.essbase.streamingCubeBuilding=true

In the Cube Deployment Wizard, select “ODBC (Essbase dynamically creates ODBC connection string).”

This option allows Essbase to conveniently establish connection to a data source during deployment and assumes default values for all connection attributes. In this case, Essbase Studio uses JDBC drivers during the deployment.

The following table provides guidelines on deployment modes and possible deployment scenarios.

Table 5. Guidelines on Deployment Modes and Possible Deployment Scenarios

Deployment Mode

Deployment Scenario Examples

Nonstreaming with connection string (default)

server.essbase.streamingCubeBuilding=false

When the data source is relational, and you have no special requirements to adjust the default ODBC DSN connection attribute values

Nonstreaming with ODBC DSN

server.essbase.streamingCubeBuilding=false

When you want to change default values of connection attributes. Examples:

  • When an Essbase model is based on Unicode source database, “N-CHAR support” must be enabled

  • If you want to enable data compression to improve data transmission performance, “Wire Protocol Mode” can be set to 2

  • An encryption option is selected as an authentication method for IBM DB2 data source connections

  • On Windows, when Essbase is started using OPMN, for cubes built from Oracle BI EE data sources

Streaming

server.essbase.streamingCubeBuilding=true

Examples:

  • Essbase model is built from an Performance Management Architect data source

  • Essbase model is built and deployed to Essbase from Performance Management Architect

  • Essbase model based on Unicode source database (N-CHAR support)

  • Authentication Method of an IBM DB2 data source connection is an encryption option (Encrypt Password, Encrypt UserID and Password, or Client)

  • On Windows, when Essbase is started using OPMN, for cubes built from Oracle BI EE data sources

  • When the Essbase model being deployed contains a calendar hierarchy