IBM Cognos Cube Designer Course Offered by DataClarity

The long-awaited IBM Cognos Cube Designer is here!

This is a two-day, instructor-led course that is designed to provide participants with the knowledge to model metadata using the IBM Cognos Cube Designer and its related tools. The course takes students on the journey from planning and project creation, to publishing dynamic cubes, all the way to authoring reports and analyzing data. This comprehensive course allows the students to assume several different roles across the two days. The student will perform task of a Database Administrator, Data Modeler, Business Analyst, and Cognos Administrator.

The course has been added to our Q2 2016 course schedule and more information can be found here:

Here is a sample topic from class:

IBM Cognos Cube Designer is a 32-bit cube modeling application. When installed, it is a separate environment from the 32-bit Framework Manager metadata modeling application. However, beginning with Cognos version 10.2.2, Cube Designer is able to leverage Framework Manager metadata. The cubes created within Cube Designer can be referenced from Framework Manager and used by other Cognos reporting components.

Dynamic cube models perform most effectively when they are based on an underlying star scheme data structure or a snowflake star schema. Modeling a dynamic cube based on a normalized OLTP (Online Transaction Processing – is a class of information systems that facilitate and manage transaction-oriented applications, typically for data entry and retrieval transaction processing)  designed databases can have a significant detrimental impact on performance within the IBM Cognos environment.

A Cube Designer project, once created and saved, consists of a single XML file with a *.fmd file extension (e.g. Product Sales.fmd). This differs from a Framework Manager project which is comprised of several files housed in a project folder. The Cube Designer project file is in ASCII format and can be easily opened and read in a text editor. However, the project should only be edited and saved from the Cube Designer application.

A Cube Designer model is created within the Project Explorer section of a project. A project consists of a single model. Dimensions and measures are assembled within a model. A Dynamic Cube is created in the model based on a single fact table of a single grain. However, a Cube Designer model may describe many cubes, and all dimensions in a model can be shared among the cubes.

Two cubes can be merged or linked together to form a virtual cube. Virtual cubes can contain facts at different grains and have different query and refresh characteristics. For example, a virtual cube can combine sales at a daily grain with quotas at a monthly grain, or historical data refreshed once a month, with current month data that is live.

Key Points:
  • Cube Designer is a separate modeling environment from Framework Manager
  • Models work only with Star or Snowflake schema databases for optimal performance
  • Each base cube is created from one base fact table and many dimensions
  • Aggregate fact tables can be integrated easily into the base cube model
  • Several cubes can exist in a single model and share dimensions
  • Two cubes can be merged into a single Virtual Cube and Virtual cubes can be merged

Cube Designer Interface

IBM Cognos Cube Designer user interface is a Windows application launched from the All Programs area. The launch link is located in the same shortcut folder as other 32-bit applications such as Framework Manager, Map Manager, and Transformer.

Entry into Cube Designer begins with a Getting Started Page, which prompts the modeler to select one of three possible actions:

  • Create New from Metadata – create a new model by first selecting a metadata source
  • Create New Blank Project – start by first creating a new blank project, then search for and import the metadata necessary to build the project
  • Open Existing – open an existing project by locating the project FDM file in the available files systems

Any of these three options can be chosen from the face of the Getting Started Page or by making selections from the File menu    or Get Metadata  .

The application has a drag-and-drop interface divided into three sections to help users understand what they are modeling.

You can find this two-day course, and many others, on our website. The link to our course catalog is:

You can access our course catalog at this location and register for courses here as well. Please contact us if you have any questions at all about the course, the schedule or just general education questions. Use the “chat” feature in the lower right hand corner of the screen.

Looking to get schedule updates and Education Services news? You can follow us on Twitter: @DataClarityEdu.

Thank you for considering DataClarity Education for your training needs and we look forward to having you in class!

By |March 9th, 2016|Education|0 Comments

About the Author:

Leave A Comment