Loading Intelligent Cubes when Intelligence Server Starts
When Intelligence Server is started there are various tasks that are
processed to prepare a reporting environment. You can include loading
all published Intelligent Cubes as one of the tasks completed when
Intelligence Server is started. This affects when the load time required
for Intelligent Cubes occurs.
It is always useful to consider whether to load Intelligent Cubes at Intelligence Server startup or when a report is executed that accesses a published Intelligent Cube are described in the table below:
The procedure below describes how to enable or disable loading Intelligent Cubes when Intelligence Server starts.
Below are the steps to enable or disable loading Intelligent Cubes when Intelligence Server starts
- In Developer, log in to a project with a user account with administrative privileges.
- Right-click the project and select Project Configuration.
- Expand Intelligent Cubes, and then select General.
- Select or clear the Load Intelligent cubes on startup check box to enable or disable loading Intelligent Cubes when Intelligence Server starts.
- Click OK.
It is always useful to consider whether to load Intelligent Cubes at Intelligence Server startup or when a report is executed that accesses a published Intelligent Cube are described in the table below:
Method
|
Pros
|
Cons
|
Loading Intelligent Cubes when Intelligence Server starts
|
|
|
Loading Intelligent Cubes when a report is executed that accesses a published Intelligent Cube
|
|
|
The act of
loading an Intelligent Cube can require memory resources in the area of
two times greater than the size of an Intelligent Cube. This can affect
performance of your Intelligence Server as well as the ability to load
the Intelligent Cube.
Comments
Post a Comment