In Oracle Planning 2024, cell-level security restricts access to specific data intersections using anchor and nonanchor dimensions. The two true statements are:
A. Anchor dimensions are always required in the cube that is used in the cell-level security definition: Correct. Anchor dimensions (e.g., Entity, Scenario) are mandatory in the security definition to specify the primary scope of access control within the cube.
B. Anchor dimensions are never required in the cube that is used in the cell-level security definition: Incorrect. Anchor dimensions are always required, contradicting this statement.
C. By default, nonanchor dimensions are not required: Correct. Nonanchor dimensions (e.g., Account, Period) are optional by default in cell-level security definitions, allowing flexibility in granularity unless explicitly included.
D. By default, nonanchor dimensions are required. You can change this setting later: Incorrect. Nonanchor dimensions are not required by default, and there’s no setting to make them mandatory—it’s an optional inclusion.
The Oracle documentation specifies that A (anchor necessity) and C (nonanchor optional) align with cell-level security behavior, making them the correct answers.
[References: , Oracle Planning 2024 Implementation Study Guide: "Cell-Level Security Configuration" (docs.oracle.com, Published 2024-09-30). , Oracle EPM Cloud Documentation: "Anchor and Nonanchor Dimensions" (docs.oracle.com, Published 2023-12-05, updated for 2024)., , ]
Submit