Product-Org OLAP
Product-Org OLAP provides a set of models for online analytical processing for product-license usage by an organization over time. In Cognos, the Product-Org OLAP folder contains three subfolders:
| • | Product Monthly—Report will use monthly data. |
| • | Product Daily—Report will use daily data. |
| • | Product Hourly—Report will use hourly data. |
Product-Org OLAP folder in Report Studio (Cognos).
Within each of the Product-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.
Both 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.
Product Monthly folder expanded to show the levels (namespaces).
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.
P-M Level3 namespace expanded to show query subjects