10 Anaplan Subsidiary View Best Practices
If you're working with multiple subsidiaries in Anaplan, it's important to follow best practices in order to keep your data organized and accurate. This article outlines 10 best practices to follow.
Subsidiary views are a powerful tool in Anaplan that allow users to view and analyze data from multiple perspectives. With subsidiary views, users can quickly and easily create a single view of their data that is tailored to their specific needs.
However, there are some best practices that should be followed when creating and using subsidiary views. In this article, we will discuss 10 Anaplan subsidiary view best practices that will help you get the most out of your data. We will cover topics such as data security, performance optimization, and user experience.
1. Create a new model for each subsidiary
Creating a new model for each subsidiary allows you to keep the data and calculations separate, which helps ensure accuracy. It also makes it easier to manage permissions and access levels, as well as maintain version control. Additionally, having multiple models can help reduce the risk of errors due to incorrect formulas or data being shared across subsidiaries. Finally, creating a new model for each subsidiary will make it easier to track changes over time and identify any discrepancies that may arise.
2. Use the same data source to load all subsidiaries
Using the same data source ensures that all subsidiaries are using the same version of the data. This helps to ensure accuracy and consistency across all subsidiaries, as well as reducing the risk of errors due to discrepancies between different versions of the data. Additionally, it makes it easier to troubleshoot any issues that may arise, since you only need to look at one source for the data. Finally, it simplifies the process of loading data into Anaplan, since you don’t have to worry about managing multiple sources.
3. Use a single master list with a subsidiary attribute
Using a single master list with a subsidiary attribute allows you to easily manage and maintain your data in one place. This eliminates the need for multiple lists, which can be difficult to keep up-to-date and accurate. Additionally, it makes it easier to create reports that span across subsidiaries since all of the data is stored in one place. Finally, using a single master list also helps ensure consistency across subsidiaries, as any changes made to the master list will automatically be reflected in each subsidiary view.
4. Build a common dashboard for all subsidiaries
Having a common dashboard allows you to quickly compare performance across subsidiaries, identify trends and outliers, and make informed decisions. It also helps ensure that all subsidiaries are using the same metrics and KPIs for reporting purposes. This makes it easier to track progress over time and spot any discrepancies in data or processes.
Finally, having a common dashboard can help streamline communication between subsidiaries by providing a single source of truth. This eliminates confusion and ensures everyone is on the same page when it comes to understanding the company’s overall performance.
5. Enable users to select their subsidiary on login
By allowing users to select their subsidiary on login, you can ensure that each user is only seeing the data relevant to them. This helps keep your Anaplan model organized and secure, as well as ensuring that users are not overwhelmed with irrelevant information. Additionally, it allows for more accurate reporting and analysis since all of the data is segmented by subsidiary.
Finally, enabling users to select their subsidiary on login also makes it easier for users to find the data they need quickly and efficiently. By having a drop-down menu or other selection tool, users can easily switch between subsidiaries without needing to navigate through multiple menus.
6. Set up security at the user level
By setting up security at the user level, you can ensure that each user only has access to the data they need. This helps protect sensitive information from being accessed by unauthorized users and reduces the risk of a data breach. Additionally, it allows you to control who can view or edit certain parts of the model, which is important for maintaining accuracy and consistency in your data. Finally, it makes it easier to track changes made to the model since you know exactly who made them.
7. Use a shared module for consolidation
A shared module allows you to consolidate data from multiple subsidiaries into one view. This makes it easier to compare and analyze the performance of each subsidiary, as well as identify any discrepancies or issues that need to be addressed. Additionally, a shared module can help reduce errors by ensuring that all subsidiaries are using the same version of the model.
Finally, a shared module helps streamline the process of creating new views for additional subsidiaries. By having a single source of truth, you can quickly create new views without needing to manually enter data from scratch.
8. Consider using a separate model for consolidations
Using a separate model for consolidations allows you to keep the data in your subsidiary views clean and organized. This makes it easier to identify any discrepancies between the consolidated numbers and the individual subsidiaries, as well as quickly spot any errors or inconsistencies. Additionally, using a separate model for consolidations ensures that all of the necessary calculations are performed correctly and efficiently. Finally, having a separate model for consolidations also helps ensure that the data is secure and protected from unauthorized access.
9. Use an import action to consolidate results
An import action allows you to quickly and easily bring in data from multiple sources into a single view. This is especially useful when dealing with subsidiaries, as it eliminates the need for manual entry of data from each subsidiary. It also ensures that all data is up-to-date and accurate, since any changes made in one source will be reflected in the consolidated view.
Using an import action also helps reduce errors, as there’s no need to manually enter data or worry about typos. Finally, it saves time by eliminating the need to manually enter data from each subsidiary.
10. Don’t forget about currency conversion
When you’re dealing with subsidiaries in different countries, it’s important to make sure that all of the data is converted into a single currency. This will help ensure accuracy and consistency when analyzing financials across multiple locations.
Anaplan makes this easy by allowing users to set up currency conversion rules within their models. This way, they can easily convert any foreign currencies into their base currency for reporting purposes. Additionally, Anaplan also allows users to create custom exchange rates if needed.