Cognos dynamic cubes administration

Dynamic cubes are published as OLAP data sources to IBM® Cognos® Content Manager. Administrators perform a number of tasks before dynamic cubes can be used by the IBM Cognos studios to create reports and analyses, and can perform additional tasks to manage or optimize the performance of dynamic cubes.

After the dynamic cubes are published as data sources, they can be accessed and configured in IBM Cognos Administration on the Status tab, in the Dynamic Cubes page. They can also be accessed from different areas in Cognos Administration; however, the Dynamic Cubes page is the central location where you can administer all instances of dynamic cube data sources in the IBM Cognos Analytics environment.

If you need information on publishing dynamic cubes, see Deploying and publishing dynamic cubes

Administration tasks

Before you can work with published dynamic cube data sources, you must perform the following tasks:

  • Assign an account in IBM Cognos to access the relational database that contains the data for the dynamic cubes.
  • If you are using multiple dispatchers, define routing rules to ensure that reports are directed to the dynamic query server.
  • Specify access permissions and capabilities required for modeling, configuring, managing, and optimizing dynamic cubes.
  • Add dynamic cubes to the query service.
  • Start dynamic cubes in the query service.

You can perform the following tasks to manage dynamic cubes or to optimize the performance of dynamic cubes:

  • Assign users and groups to security views.
  • Manage dynamic cubes. For example, you might refresh caches or security settings.
  • Edit the query service configuration parameters for dynamic cubes. For example, you might need to edit the JVM (Java™ Virtual Machine) heap size.
  • Edit dynamic cube properties. For example, you might change the default value for the data cache size limit.
  • Create and schedule query service tasks.

After the dynamic cubes are used in reports and log files are analyzed, you can perform the following tasks:

  • Use Aggregate Advisor to view aggregate recommendations.
  • Monitor the metrics of the dynamic cubes added to the query service. For information about system performance metrics, see the IBM Cognos Analytics Administration and Security Guide.