Both modeled and cubed sheets in Workday Adaptive Planning offer the ability to add dimensionality to the model to further enhance data visualization. Dimensions and their values are often needed to be updated and maintained. While this could be seen as an inconvenience, Adaptive offers a feature that enables the user to edit the dimension directly on a cubed or modeled sheet rather than having to navigate through modeling to the dimension home screen.
If you navigate towards the back end of your cubed or modeled sheet and press on column and levels, you will see your dimensions. Select the dimension you want to enable the feature on, and check the “Edit dimension on sheet” checkbox circled in red. Save your changes.
To use the feature, navigate to the front end of the sheet you are working on. Hover over the cell you want to edit under the correct dimension column, and click the drop down arrow. You will then hit the “Edit Dimension” button that is circled in red.
Next, the window below will pop up. Circled in red is the button to add a new dimensional value directly onto the sheet. This will also be updated on the main dimensions tab as well. Additionally, you have the ability to rename an existing dimension in this same window.
This feature is also available for text-selectors and follows the same process as dimensions.
Revelwood is an award-winning, Platinum Solution Provider for Workday Adaptive Planning. We build solutions for the Office of Finance that minimize your risk by seamlessly incorporating business analytics into your everyday thinking. By combining the software with our best practices and out-of-the-box applications, we help businesses achieve their full potential with Workday Adaptive Planning.
Read more Workday Adaptive Planning Tips & Tricks:
Cube Sheet Restrictions in Workday Adaptive Planning
Workday Adaptive Planning Tips & Tricks: The User Access Calculator
Workday Adaptive Planning Tips & Tricks: Machine Learning Predictive Forecaster: Lever Sheets
