-
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 !
-
How can we create action to load Existing items line item to Applicable Products line item.
This is the screenshot of the module containing both boolean line items.
-
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…
-
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…
-
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
-
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?
-
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.
-
Automatic Export of 60 pages
Hello guys! Can anyone solve this? I have a module with 60 pages, and I need to export each one of those pages into a different excel file. Does anybody know a way of automate this process? I mean, facilitate the manual process of selecting pages 60 times and export each one of them individually? Is there a way to iterate…
-
How to count the number of times a month shows up minus 1?
Hi, I'm trying to create a logic into the line item "End". My goal is to count the number of times a specific month appears without including the first occurrence. If November appears 4 times, I would like the "end" line item to display 3. Similarly, if December appears 5 times, I want "end" to show as 4. I want to use the…
-
Delete Multiple Users from the Model in one shot.
Hi, Is there a way to delete the multiple users in one shot from the model. Thanks, Ashoka GK
-
Data import
Here is the table i want to import to anaplan Here is what i have in the blueprint mode May I know if i set this up correctly? I have been having issues loading things in.