How can you report on alternate level groupings within Adaptive Planning that reflect the ones maintained in a financial system of record such as Workday?
A.
Select the box 'For reporting purposes only' within Level Details on the alternate parent rollup.
B.
Use level dimensions or level attributes to represent the alternate hierarchy structure.
C.
Suggest a change in the system of record to only have one single structure matching the Adaptive Planning one.
D.
Include the existing levels within a new level rollup that includes 'Alternate' in the name and code.
Workday Adaptive Planning supports alternate reporting hierarchies through the use of level dimensions and level attributes, which allow users to tag and classify levels according to groupings that exist in external systems of record such as Workday HCM or Workday Financial Management. This approach preserves the primary level hierarchy while enabling reporting along alternate dimensional structures without restructuring the core model. Level dimensions enable slice-and-dice reporting across dimensions that cross-cut the standard hierarchy, while level attributes allow metadata tagging of individual levels for grouping in reports and dashboards. Neither modifying the system of record nor creating parallel rollup structures represents a maintainable or scalable solution. The 'For reporting purposes only' checkbox applies to specific use cases but does not comprehensively support alternate hierarchy reporting across the model. Level dimensions and attributes are the recognized, official design pattern for multi-hierarchy reporting in Adaptive Planning. Reference: Workday Adaptive Planning — Level Attributes, Level Dimensions, Alternate Hierarchies, Reporting Configuration.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit