官术网_书友最值得收藏!

Intelligent cube

Intelligent cubes are multi-dimensional, in-memory copies of data that can be queried and accessed by many different documents and reports. Basically, the cube is allocated on the Intelligence Server machine and uses either memory or disk to store the definition and perform fast data retrieval.

We can treat it as a database where data is pre-cached and quickly accessed. To improve the report execution performance and response time, it's good to run the report with significant wait time and high usage against intelligent cubes. We cannot include custom groups, consolidations, derived metrics, prompts, or view filters in an intelligent cube.

The steps to create an intelligent cube are as follows:

  1. Navigate to the folder where you want to create an intelligent cube; the best practice is to create it under Public Objects | Reports.
  2. Select the report from which you want to build an intelligent cube. Edit and enter the report editor.
  3. Select Data | Intelligent Cube Options | Convert to Intelligent Cube.
  4. Click Save and Close, and enter an intelligent cube name.

This gives us a cube, but it has not been processed so it cannot be used for reporting. To make it usable, right-click on a cube and click Run. Once execution completes, it shows an Execution complete screen, giving us the provision to create reports out of a cube.

We can publish intelligent cubes as follows:

  • Publish manually:
    1. Browse to the intelligent cube that needs to be published.
    2. Right-click the intelligent cube and click Run.
  • Publish with schedule:
    1. Select Administration | Configuration Managers | Subscriptions.
    2. Right-click and select Subscription creation wizard.
    3. On the welcome page, click Next.
    4. On the specify characteristics screen, select the project that contains the intelligent cube and select Cube refresh as the delivery type. Click Next.
    5. On the Choose Report/Document screen, browse to the intelligent cube to be published and click the right arrow to move it to the selected objects pane. Click Next.
    6. On the choose recipient screen, select Schedule or Run Subscription Manually. Click Next.
    7. On the Specify Subscription Properties screen, select Expire Subscription if subscription should expire on and the recipient email id who receives mail after the intelligent cube runs. Click Next.
    8. The summary page is displayed; review the information and click Finish creating a subscription.
  • Alternate way to publish an intelligent cube:
    1. Right-click the intelligent cube and select Schedule Delivery To | Refresh Cube.
    2. In Refresh Cube Subscription Editor enter the Name, Schedule, Delivery Notification and click OK.

Based on the schedule selected, the intelligent cube will be refreshed.

Republishing an intelligent cube using the preceding options will reload data from the data warehouse causing existing data to be overwritten. To avoid this, we can use the incremental refresh intelligent cube option.

Incremental refresh type options are:

  • Update: Add new data if not in a cube, or else just update where applicable
  • Insert: Add new data if available
  • Delete: Based on the filter or report definition, data is deleted from the cube
  • Update only: No new data is added, it is just updated where applicable

Types of object used for incremental fetching:

  • Filter: This is used for incremental refresh; data returned by a filter is compared to an existing cube data
  • Report: This is a template for an intelligent cube, and the cube is populated based on the report's data

To create an incremental refresh:

  1. Right-click on an intelligent cube and select Define Incremental Refresh Report.
  2. Select the options from the following screen for incremental refresh:

An example:

Let's say we have an intelligent cube which stores weekly sales data, so we would like an intelligent cube to update weekly sales data by the end of the week. We can use incremental refresh so that the data for one week is added without affecting the existing data.

Enabling and disabling intelligent cube usage

By default, reports can use an intelligent cube within the project, but we can enable or disable this as follows:

  1. Right-click the project | Project Configuration | Intelligent Cube | Dynamic Sourcing:
  2. Select data | VLDB properties | Dynamic Sourcing:
主站蜘蛛池模板: 安康市| 应用必备| 高安市| 龙海市| 六枝特区| 神池县| 厦门市| 吉安县| 抚顺市| 合作市| 桃园县| 甘孜| 万山特区| 延安市| 麻城市| 潼南县| 凤冈县| 兰州市| 吴堡县| 桐庐县| 汉寿县| 洛川县| 青冈县| 师宗县| 新晃| 老河口市| 灵宝市| 林西县| 巩义市| 青田县| 平顺县| 个旧市| 临泽县| 象山县| 常德市| 德阳市| 施秉县| 大埔区| 长白| 凌源市| 怀来县|