nerdexam
Microsoft

70-466 · Question #47

You are developing a multidimensional project that includes a dimension named Organization. The dimension is based on the DimOrganization table in the data warehouse. The following diagram illustrates

The correct answer is D. Set the AttributeHierarchyVisible property to False for the Organization attribute.. In SSAS multidimensional models, each dimension attribute automatically exposes an attribute hierarchy. To hide this hierarchy from end users without disabling its internal functionality, you set AttributeHierarchyVisible to False.

Build an analysis services database

Question

You are developing a multidimensional project that includes a dimension named Organization. The dimension is based on the DimOrganization table in the data warehouse. The following diagram illustrates the table design. The Organization dimension includes a parent-child hierarchy named Organizations. The dimension includes the following dimension attributes: - Organization, which is a key attribute - Organizations, which defines the parent-child hierarchy - CurrencyKey, which is a regular attribute When users browse the dimension, three hierarchies are visible to them. You need to ensure that the Organization hierarchy is not visible to users. What should you do?

Options

  • ASet the AttributeHierarchyDisplayFolder property to Null for the Organization attribute.
  • BDelete the Organization attribute.
  • CSet the AttributeHierarchyEnabled property to False for the Organization attribute.
  • DSet the AttributeHierarchyVisible property to False for the Organization attribute.

How the community answered

(32 responses)
  • A
    3% (1)
  • B
    13% (4)
  • C
    3% (1)
  • D
    81% (26)

Why each option

In SSAS multidimensional models, each dimension attribute automatically exposes an attribute hierarchy. To hide this hierarchy from end users without disabling its internal functionality, you set AttributeHierarchyVisible to False.

ASet the AttributeHierarchyDisplayFolder property to Null for the Organization attribute.

AttributeHierarchyDisplayFolder controls which folder the hierarchy appears in within client tools, not whether it is visible or hidden to users.

BDelete the Organization attribute.

The Organization attribute is the key attribute of the dimension and cannot be deleted without destroying the entire dimension.

CSet the AttributeHierarchyEnabled property to False for the Organization attribute.

Setting AttributeHierarchyEnabled to False disables the attribute hierarchy entirely, which can break dependent objects such as the parent-child hierarchy that relies on the underlying attribute being functional.

DSet the AttributeHierarchyVisible property to False for the Organization attribute.Correct

Setting AttributeHierarchyVisible to False on the Organization attribute hides that attribute hierarchy from client tools and browsing interfaces while keeping it enabled for internal use. This is the correct property to control visibility without affecting the attribute's ability to support the parent-child hierarchy or other dimension functionality. The parent-child Organizations hierarchy remains unaffected and visible.

Concept tested: SSAS dimension attribute hierarchy visibility control

Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/attribute-properties-configure-attribute-types

Topics

#AttributeHierarchyVisible#parent-child hierarchy#dimension attributes#SSAS dimensions

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-466 Practice