-
Anaplan Excel addin and windows 11
Hi Please advise: Quilter is migrating to windows 11. However, the Anaplan Excel addin - Check your software versions and settings for the Excel Add-in | Anapedia (anaplan.com) only supports: Windows version compatibility The add-in is compatible with: Windows 8 Windows 8.1 Windows 10. Self-Service Security Assertion…
-
Modeling probleme
Hi all, Can you please help me with the following model? I want to create a model to calculate my budget for the next year. Here's the list of components: List: Product: Family => Subfamily => KSU Distribution Network: Global => Distribution Network Local Brand: Brand X and Y Input: Sales history in quantity and revenue…
-
Automated attribute change capture
Anaplanners, I had a query, I had created a mailto functionality for various projects based on the location for example if Project is based out in London then mail should automatically pick out the Europe mail address and so on for other countries based on region, the mailto functionality is disabled by the receiving team…
-
Get values from a line item looking for a market zone = X, separate column Market zone = Y
I have separate columns of forecast and typology each divided into different market zones. Forecast EMEA, Forecast APAC .. Typology EMEA , Typology APAC The data is with one line item with all market zones dimensions I need to split it into separate values, I am having trouble with the formula. I am trying to get Market…
-
How do you build crediting modules?
Hi Anaplanners, Does anyone know how to build the calculation modules that would assign the business rules to the transaction details? My current method involves me building a boolean module to fetch the correct combination, and then creating views to import the "Sales Rep" to the correct transaction level account.…
-
Adding new list failure
Hi guys, I have a system generated numbered list concatenated with an attribute. It is marked as a PROD list. I created a form in the NUX to enable the user to add into the list but I keep getting failure What could be the issue and is there a workaround to resolve this issue? Thanks in advance
-
App Dashboard Exports
Hi Anaplan Community, I am wondering if there is a way to do a mass export of multiple exports and combine them all into one excel file with multiple sheets. It would be one sheet for each export, but they would all be in the same excel file. I am hoping I could publish this process button to my app dashboards. Thank you!…
-
First Non Blank within Hierarchy
Hi, how do I get the first non blank, or min, or max on the date here within the hierarchy. The first 3 lines should all have the same date 9/25
-
PlanIQ Blank Output
Hi, I'm facing an issue with PlanIQ output. Everything was running smoothly, without errors. Otherwise, I can not see any forecast results. ( Seasonlity, trends and predictions) Would someone help Please ? Thank you !
-
Applying a TRUE boolean across all months when a single month is TRUE
Hello, I have a module with three relevant dimensions: Position ID (FLAT Position ID) Component (FLAT Components) Time (monthly) For a component under a position, if any month is marked true in an initial line item, every month should be marked true in an associated line item. Screenshot attached, but in the example if TBR…
-
changing dimentions in a view
In a view if i alter the dimentions (not just rearranging but actully change what the dimention applies to ). Does this affect the original view's dimentions?
-
How to bring values from the same module into different rows
Hi, I'm trying to bring a value entered by the user in the line Item 'New Price for Original Product' which is a value entered in the product B row into the 'Final Price' Line item in row for Product A. 'Original Product' line item is a subsidiary view that brings the original product as text. The first thing I tried was…
-
How to check how hierarchy will change before implementing
Hello, Does anyone have a quick way to check in the Data Hub, of what the impact to spoke models will be? Example: I have a 5 level hierarchy in my Spoke model and I create the codes in Data Hub. Then I can export to build the relevant lists. We want to change the hierarchy mappings in the Data Hub as business needs…
-
Error
-
SG&A Forecasting
Hi All, Based on your experience, can I know how you do the forecasting for SG&A in Anaplan? ( except driver-based / scenario-based) are there any forecasting methods available for finance SG&A forecasting? Thanks.
-
Check if there's a value in any version
I'm trying to build a filter that will only show list items that have values in them regardless of the version. Is there an elegant way of checking for a non-zero value in any version? The two ways I know of doing this is to create line items for each version using [SELECT: Versions.version] and adding them up. Or using…
-
L3 Model Building Sprint 2 - User Story 3.3
Hi Community, I was able to match my Target with the screenshot provided in the training. But after applying the commission and attainment % to Quarterly Target and then using Quarter Apportionment to divide quater values into monthly interval. My screenshot doesnt match the check your build. Commission% for Janell is 10%…
-
Absolute value of year value
I would like to sum an absolute value of a monthly line item. Might for example have values -2 i january, -3 i february and +5 in March. Would like a line that calculates the absolute yearvalue of this as 2+3+5=10 (not -2-3+5 = 0)
-
Modeling Questions
Hi all, Can you please help me with the following model? I want to create a model to calculate my budget for the next year. Here's the list of components: List: Product: Family => Subfamily => KSU Distribution Network: Global => Distribution Network Local Brand: Brand X and Y Input: Sales history in quantity and revenue…
-
Data loss issue
I've encountered a strange issue in our model. To give you the context - We run a scheduled process through REST API to copy data from one version to another version. We tried running this using cloudworks, it did not work (I'm assuming because once of the action in the process has filter based on User Write Access). So we…
-
Issue in LIS where one line item is shown as a parent of another.
Hi, I have created a LIS from two different modules with a total of 3 line items. The two line items I selected from the first module however are having a parent child relationship when I use the LIS as a dimension in another Module. This should not be the case as all the line items are independent. The First Image is the…
-
How do I audit a specific line item that is used for DCA access?
Hi, I am trying to trace all line items in a model that reference a specific line item in a specific module for DCA access. Is there a function in Anaplan that allows you to do this?
-
Filtering for Month or Quarter or Annual Totals
I'm trying to do dynamic filtering of the periods in a report based on another module where I enter report start and report end date. I want the option to: Show only months between date 1 and date 2 Show only the qtrly totals between date 1 and date 2 Show only the annual total between date 1 and date 2
-
Dimensions & Lookup
Anaplanners, Been struggling on this particular piece: We have a module where we have a Country Dimension and Serial Number list, as each country has a fixed number of 10 agents and some attributes (line items). Refer Snip: Agent Name & Agent Role are list formatted Line Items. "Country" and "No." are lists. Requirement:…
-
Erlang C- Application
Hi! I am leveraging Erlang C for a staffing model. As I use Erlang C the service level that Anaplan is calculating is producing inconsistent results. Has anyone had this similar problem?
-
Need count to work dynamically depending on the list size
Hi, I have a requirement where in a module i have 4 dimensions (2 as page filter, 2 in the rows), Also line items are on column. (No time as dimension) I need to have a formula where it should reflect count of the line item starting from 1 to as many as the line item count is. And this should be dynamic based on the…
-
Anaplan Login Landing Page
Is there a way to set a default login page for a user? Like when a user login. It takes him/her to a certain page of an app
-
End Users being able to see all Users in a User dimensioned module
I did think that this didn't used to be the case but it would seem that a module that's dimensioned by user an end user can only see themselves when viewing it. If you're a workspace admin you can see all the users - which when you want to push out user-level DCA isn't particularly helpful. Clearly I can create a fake user…
-
Import action failed while running through Cloudworks
According to the given screenshot, error thrown by Cloudworks is - "Hierarchy import has both Name and Code unmapped". Although, manually the import action is running fine. Need some help. Thanks,
-
Look up question
Hi team, I need assistance with pulling values from one module to another. As you can see, some of those fields are related (in the same color) so all I need is to pull the Opp # from Module 2 into Module 1: Thanks a lot in advance.