Finding the Dirt: tricks for rapid Prototyping with Essbase Studio - Developing Essbase Applications - page 105

Figure 3.41 Produc.rul opened in a text editor.
4. The clear text in the Load rule is the SQL generated to build the dimension.
This SQL can be copied out and leveraged as the basis for the SQL in the SQL
Interface-Based Load rules.
Note: making any changes to the SQL in the Load rule in the text editor is not a
supported action. yes, this is a hack, but a cool and useful one.
3.7.2 To Stream or Not to Stream
one of the often-overlooked capabilities of Studio is data and metadata streaming.
Studio performs its modeling tasks using JDBC (Java database connectivity) drivers.
however, when you deploy a cube using the Cube Deployment Wizard, that build is
handed off to the Essbase SQL Interface and oDBC (open database connectivity) con-
nections. That means that the Essbase server must have the proper drivers installed and
oDBC connections setup prior to deployment (Figure 3.42).
If you are running in a stand-alone environment where you have control, ensuring
the oDBC connections are in place is easy. however, there is a very good chance that the
Studio and Essbase servers are on separate physical boxes. If that is the case, you may
not have access to either, then create an oDBC connection on the Essbase box or set up
the required oDBC connections.
Studio provides the option to force (or stream) the entire deployment process to run
from the Studio server and the JDBC connections. Streaming is controlled in the Studio
server.properties file. to enable streaming add the following line to the Studio server.
properties file:
server.essbase.streamingCubeBuilding=true
Note: In general, streaming provides slower build and load times as compared to the
Essbase SQL Interface. Also, in newer versions of Studio, you also have the option, as
shown in Figure 3.43, of having Essbase dynamically generate the oDBC connections
at time of deployment. This uses the built-in drivers on the Essbase server and the con-
nection information in Studio.
Note: When using the oracle database as a source, you have the option of leveraging an
oCI connection to optimize processing.