Creating data modules from OLAP cubes

Starting in Cognos® Analytics 12.0.3, after successfully establishing a connection to an OLAP data server, you can browse its cubes and use them to create data modules.

Data modules that are based on OLAP cubes can be used to create reports, dashboards, stories, and other Cognos Analytics content in the same way as packages that contain OLAP cubes are used.

Before you begin

A successful connection of type IBM Planning Analytics, IBM Planning Analytics as a Service, Microsoft Analysis Services, Microsoft Azure Analysis Services, or other supported OLAP data server connection must already be created. For more information, see Creating a data server connection.

Procedure

  1. In the Cognos Analytics welcome page, from the Open menu icon Open menu icon in the application bar, click New > Data module.
    open menu screen capture
  2. In the Select sources dialog box, click the Data servers and schemasSource view icon folder.
  3. Click an OLAP data server to view its cubes.
    Note: Only cubes for which metadata was loaded are available to create data modules. For more information, see Loading OLAP metadata.
  4. Select one or multiple cubes, and click OK.

    In the data module user interface, the cube data is shown in the Data module panel.

  5. Save the data module in Team content or My content.

Results

The data module is created in the location that you specified.

What to do next

Use cube-based data modules to create dashboards, reports, explorations, and other Cognos Analytics content.