Tier-Feature-Org OLAP

The Tier-Feature-Org OLAP provides a set of models for online analytical processing for tier-based license usage by an organization over time. This is for use by enterprises who use Autodesk products.

In Cognos, the Tier-Feature-Org OLAP folder contains three subfolders:

•

Tier-Feature Monthly—Report will use monthly data.

•

Tier-Feature Daily—Report will use daily data.

•

Tier-Feature Hourly—Report will use hourly data.

Tier-Feature-Org OLAP folder in Report Studio (Cognos)

Within each of the Tier-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.

Tier 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.

TF-M Level3 namespace expanded to show query subjects.

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