IBM Cognos Framework Manager model logical layer

The logical layer contains query subjects that draw data from the database query subjects and present it in a more consumable format.

Attributes are renamed to eliminate underscores and to use sentence case. In some cases, physical entities are combined into one query subject. In particular, the following snowflake dimensions are combined together to accommodate master data reporting and avoid cross product result sets:

• Query subject Profile Variable contains attributes of profile_variable, measurement_type, profile_calculation, resource_type (profile_variable), and material_type (profile_variable).
• Query subject Material contains attributes of material, supplier and material_type.
• Query subject Production Batch contains attributes of production_batch and product
• Query subject Related Batch contains attributes of production_batch, batch_batch and production_batch (related).
• Query subject Resource contains attributes of resource, resource_type, location (resource), and group_dim_1 to 5.
• Query subject Event Observation contains attributes of event, event_observation, and event_resource.

The query subjects are organized into a folder for dimensions and a separate namespace for each logical fact. The fact query subjects contain additional calculated attributes that are included in dimensional layer measure dimensions.