Strategy One

Create Intelligent Cubes

Creating an intelligent cube is similar to creating a report. You can add data for your intelligent cube by including objects such as attributes, metrics, filters, and so on, as report objects or report filters. For a list of objects and features that cannot be included in the definition of intelligent cubes, see Supporting various features using Intelligent cubes.

You can also create an MDX intelligent cube.

Since intelligent cubes are used simply to share a set of data, no data or report results are displayed when you execute an intelligent cube. However, executing an intelligent cube publishes the intelligent cube, which can then be accessed as a set of data for multiple reports. See Publishing Intelligent Cubes for more information.

The Intelligent Cube Editor uses the Modeling service infrastructure. Make sure the service is properly configured and running before using the Intelligent Cube Editor.

To view an existing cube, you must have the following minimal privileges:

  • Use analytics

  • Use Intelligent Cube Editor

  • Modify the list of Report objects (use object browser).

To create cubes, you must have the following additional privileges:

  • Use Architect Editors

  • Create application objects

Use the Intelligent Cube Editor to access all of the features and functionality for creating cubes. The Editor and Filter panels are stacked together by default.

  1. Open the Workstation page.

  2. In the Navigation pane, click Data.
  3. In the top right corner, click Create New Dataset.
  4. Select Intelligent Cube or Live Intelligent Cube, then click OK.

  5. Use the Objects section to search for the desired metrics and attributes and drag them into the Editor panel.

    Toolbar Provides the most commonly used tools, including Save,SaveAs, Publish, and allows you to set the cube Refresh Type:

    • Replace Old data is completely replaced with new data, retrieved by executing the current intelligent cube, using its current template and filter.

    • Dynamic Refresh Inserts new rows from new data, and removes non-overlapping rows from old data by comparing the old and new intelligent cube data filters.

    • Upsert Inserts new rows from new data and overwrites overlapping rows between old and new data.

    • Insert Only inserts new non-overlapping rows from new data.

    You can also set the cube partition and publish language.

    Cube Template Only available when creating a new cube. Allows you to select a cube template, copy it over, and continue modifying it.

    Objects Use the Objects section to search for the attributes, metrics, hierarchy, or system prompts you want to use in your intelligent cube. The Objects section only displays objects that are supported in an intelligent cube. For example, custom groups do not display since they are not supported.

    Editor panel Displays objects that have been added to the cube. Drag objects from the Objects section to the Editor panel to add them to the cube.

    Filter Panel Displays the filtering options for the cube. Drag objects from the Objects section to the Filter panel and continue defining their qualifications in the lower pane.

    SQL and Execution Status Panel Displays SQL for the current saved cube or even passes of published cube caches with proper admin privileges.

    You must have at least the Web Report SQL privilege to access this panel and view the SQL.

    Data Preview Panel Allows you to quickly preview data, with a 1,000 row limit, after publishing a cube.

    You must have the Web Define Intelligent Cube Report, Define Intelligent Cube Report, Web Publish Intelligent Cube, and Publish Intelligent Cube privileges to access this panel.

  6. Click Save and Publish.

  7. Click Publish to see the data preview.

  8. Switch to the SQL Query panel to view the associated SQL.