1Z0-1080-26 practice question 20 of 25

Which two statements are true about using anchor and nonanchor dimensions with cell-level security?

Full set: 118 questions
Answer options
A: Anchor dimensions are always required in the cube that is used in the cell-level security definition. Correct answer
B: Anchor dimensions are never required in the cube that is used in the cell-level security definition.
C: By default, nonanchor dimensions are not required. Correct answer
D: By default, nonanchor dimensions are required. You can change this setting later.
Correct Answer:
A. Anchor dimensions are always required in the cube that is used in the cell-level security definition.; C. By default, nonanchor dimensions are not required.
Explanation

Cell-level security rules define access rights to specific data cells. These rules are built using anchor and nonanchor dimensions. Anchor dimensions are the dimensions explicitly included in the rule's definition to specify its scope; at least one anchor dimension is always required to define the security context. Nonanchor dimensions are all other dimensions in the cube not specified in the rule. By default, the system assumes the rule applies to all members of nonanchor dimensions, meaning they are not required to be specified for the rule to be valid.

Why Incorrect

B. This is incorrect. A rule without any anchor dimensions would have no defined scope and would be invalid.
D. This is the opposite of the default behavior. Nonanchor dimensions are not required by default; the rule applies to all their members.

References

1. Oracle Corporation. (2024). Administering Planning for Oracle Enterprise Performance Management Cloud. Chapter 10: Securing Planning

Section: "About Cell-Level Security". "Anchor dimensions are required. Non-anchor dimensions are optional."

2. Oracle Corporation. (2024). Administering Planning for Oracle Enterprise Performance Management Cloud. Chapter 10: Securing Planning

Section: "Defining Cell-Level Security". "By default

non-anchor dimensions are not required. If you don't select members for non-anchor dimensions

security is applied to all members of the non-anchor dimensions."

Scroll to Top