A Framework Manager model may be designed to incorporate Dimensionally Modeled Relational (DMR) objects, designed to offer the end user OLAP behavior when navigating dat

Question

Options

• AMeasures and Dimensions can reside in the same query subject.
• BThe DMR structures need to resemble the objects in the star schema.
• CThe order of the Determinants drives the hierarchy levels.
• DEach level in a hierarchy must reference a text-based attribute for its caption.

• A
  80% (16)
• B
  5% (1)
• C
  5% (1)
• D
  10% (2)

Explanation

In IBM Cognos Framework Manager, DMR design allows both measures (facts) and dimension attributes to coexist within the same query subject - this is the defining feature that enables OLAP-style navigation on relational data without requiring a strict separation of fact and dimension tables.

Option B is wrong because DMR explicitly does not require a star schema structure; its purpose is to provide dimensional behavior on relational data that may be normalized or otherwise non-star-shaped. Option C is wrong because while determinants define granularity and help with correct aggregation, they do not dictate hierarchy levels - hierarchies are defined through scope relationships and query item properties. Option D is wrong because text-based captions for hierarchy levels are a best practice, not a strict requirement - numeric or other attribute types can serve as captions.

Memory tip: Think "DMR = Dimensions Mixed with measures in Relational" - the whole point is that the traditional fact/dimension boundary is relaxed, so measures and dimensions sharing a query subject is the key behavior to remember.

No community discussion yet for this question.