Sorting Dimensions
Automatically enforce logical order in Vena hierarchies using a custom ETL procedure, making dimensions cleaner and navigation easier.
About Sorting Dimensions
Vena hierarchies often lack alphabetical sorting, placing new members randomly and slowing navigation. Our universal ETL procedure automatically sorts dimension members using customizable rules, ensuring neat, organized hierarchies for efficient FP&A work.
Learn More
Key FP&A Challenges
Vena’s default settings add new dimension members randomly, resulting in hierarchies that are messy, hard to search, and slow to navigate.
new members added randomly at the bottom
thousands of members lack organization
requires time-consuming manual maintenance effort
unsorted lists slow down user productivity.
lacks uniform alphabetical order for hierarchy members
DSCIM applies a custom, automated procedure to instantly sort all Vena hierarchies by required criteria, ensuring organized and searchable dimensions.
Why DSCIM’s Approach Stands Out
Finalizing Your Vena Implementation Strategy
By working with DSCIM, you will:
- Gain a structured and well-documented implementation roadmap;
- Ensure a seamless transition from manual processes to automated Vena reporting;
- Optimize financial data structures and workflows for long-term efficiency.
Key Steps in Sorting Dimensions
-
Select Dimensions
- Identify specific hierarchies requiring sorting.
-
Define Sort Scope
- Determine levels needing alphabetical order.
-
Set Custom Logic
- Apply rules for element placement (e.g., blanks).
-
Deploy Stored Proc
- Install the universal sorting procedure.
-
Set Parameters
- Configure procedure input based on defined rules.
-
Update ETL Flow
- Integrate the procedure into the daily ETL job.
-
Execute Sorting
- Run ETL to confirm immediate hierarchy changes.
-
Verify Hierarchy
- Check Vena Modeler for correct member placement.
-
Test New Members
- Ensure new additions are sorted automatically.
-
Schedule Job
- Ensure daily job runs the sorting procedure automatically.
-
Monitor Output
- Track ETL execution time and performance.
-
Client Handover
- Transfer ownership for long-term support.
Discovery Session
Have a question or need more information? Contact us!
Contacts
Markham, Ontario, L3R 6G2, Canada
Other Services
We will contact you shortly