nerdexam
Microsoft

70-466 · Question #102

You need to meet the browsing requirements for the Products hierarchy. Which property should you modify?

The correct answer is C. HideMemberIf. The HideMemberIf property in SSAS controls whether hierarchy members are hidden during browsing based on defined conditions, enabling cleaner hierarchy navigation.

Build an analysis services database

Question

You need to meet the browsing requirements for the Products hierarchy. Which property should you modify?

Exhibit

70-466 question #102 exhibit

Options

  • ADefaultMember
  • BAttributeHierarchyDisplayFolder
  • CHideMemberIf
  • DRootMemberIf

How the community answered

(25 responses)
  • B
    4% (1)
  • C
    92% (23)
  • D
    4% (1)

Why each option

The HideMemberIf property in SSAS controls whether hierarchy members are hidden during browsing based on defined conditions, enabling cleaner hierarchy navigation.

ADefaultMember

DefaultMember specifies which member is pre-selected when a dimension is used in a query, not which members are visible or hidden during hierarchy browsing.

BAttributeHierarchyDisplayFolder

AttributeHierarchyDisplayFolder organizes attributes into folders within the dimension's attribute list in client tools, but does not control member visibility within a hierarchy.

CHideMemberIfCorrect

HideMemberIf is an SSAS attribute property that specifies the conditions under which a member is hidden when users browse a hierarchy - for example, hiding a member if its name equals the parent name or if it has no data. This directly addresses hierarchy browsing requirements by suppressing redundant or irrelevant members from the user's view. The property accepts values such as Never, OnlyChildWithParentName, NoName, and ParentName to fine-tune visibility.

DRootMemberIf

RootMemberIf determines which members act as root nodes in a parent-child hierarchy, affecting structure definition rather than controlling whether members are shown or hidden during browsing.

Concept tested: SSAS HideMemberIf property for hierarchy member visibility

Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/attribute-properties-hide-an-attribute-member

Topics

#attribute hierarchy#HideMemberIf#hierarchy browsing#dimension properties

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice