Data Model Descriptions

Feature-Org OLAP

Feature-Org OLAP provides a set of models for online analytical processing for feature-license usage by an organization over time. In Cognos, the Feature-Org OLAP folder contains three subfolders:

•

Feature Monthly—Report will use monthly data.

•

Feature Daily—Report will use daily data.

•

Feature Hourly—Report will use hourly data.

Feature-Org OLAP folder in Report Studio (Cognos)

Within each of the Feature-Org OLAP subfolders, there are five levels (namespaces), each of which represents a level in your organizational structure, with Level1 representing the top level. The level you select depends upon which level in your enterprise’s organizational structure you are reporting on.

Feature Monthly folder expanded to show the levels

Within each level namespace are query subjects, some of which vary from one level to the next. When you choose a level to report on, you must work only with the query subjects in that level. For example, the following figure shows the query subjects that are available to work with when reporting on feature license usage using monthly data for Level3 of your organization.

The Feature Daily and the Feature Hourly folders are structured same way as the Feature Monthly folder. The difference is that this model is built on daily and hourly aggregation data, respectively. For the Feature Daily model, the data granularity is one day and, for the Feature Hourly model, the data granularity is one hour.

F-M Level3 namespace expanded to show query subjects.