Modeling

Dependent dropdown
I have one dimension "Employee" and want to assign two products A and B. Product A and Product B are two line items formatted as Product List. It is perfectly fine if employee is assigned the first product however, when the employee is assigned product B, then product A should not be visible in the dropdown as the employee…
Enter Saved View on Saved View Creation/Save
When creating saved views, it would be great if Anaplan enters the saved view immediately after creation. Currently, anaplan returns to the default view of the module. This can be a bit annoying if you need to make a quick change to the view, such as adding a filter or showing/hiding columns.
Date Conversion
Hi Guys, I have a simple one to ask. I am loading a Period with a Text format to a Year and Month with a Number format. Example: I loaded a date of Jan 13 to a Period column. Then I need to convert it to Month 1 and Year 2013. I tried loading it as Time period which is the right way but for some reason it is not loading…
Variance Analysis between versions without using select
Hi, I am trying to create a variance Analysis for users so they can compare price & volume between to Anaplan versions (i.e Budget & Forecast, Budget & Actuals). This idea is for user to select Version 1 and Version 2 to decide which versions they want to compare. Similar to: Select V1 : XX (i.e Budget) Select V2: YY (i.e…
Set default file to everyone
Would be really handy if Anaplan did either one of the following actions for import data sources: * Set the default file type as everyone or; * Permanently saves files regardless of default file type selected. This would really assist in debugging and remapping import files.
How to calculate cumulative results
Hi,everyone. I would like to calculate the cumulative result of a line item. I think I should use the TIMESUM function, but I don't understand how to use it. I want to get the cumulative result from the date of FROM to the date of TO. Could you tell me the best solution? Best regards. Taku
Dashboard View Error
Hi , we sre all getting this error on some dashboards, and can noit work out how to stop it Any suggestions please? thanks
Display the Latest Revision Tag for a Model in the Manage Models Dialogue
When you have multiple versions of a development model it is not easy to see whether the model is up to date without either opening it or trying to run a Compare and Synchronise. It would be helpful to display the last revision tag of any deployed model on the Models dialogue so as to avoid this.
Ability to add .txt file to a Revision Tag
I think it would be beneficial to have the ability to upload attachments to a revision tag as supporting information for a development change. It would not need to be any more complicated than uploading a .txt file against each revision tag. Currently, we have the ability to add a title and description for each revision…
Blueprint View of Saved View
When a saved view is open, it would be really useful to have the option to open the blueprint and only show the line items in the view, rather than the full blueprint. In modules with a lot of line items, when the view has only a small selection of them, it is time consuming to find the respective line items
nth occurrence text function - finds nth time a character occurs in a string
I would like the ability to use a function that allows me to search for the nth time a character or string of characters occurs in a concatenated key. Currently, we import text string keys from source systems and derive business information from these strings. For instance, we might have the transaction key…
Anaplan to be supported in Microsoft Edge browser
I hope Anaplan could be supported in MS Edge other than IE 11 or chrome/firefox and safari. We are using edgeand we experience some issues even with just doing data entry on a field with percentage format.
QUARTERVALUE Function
Hi team, I've got 2 simple modules with 2 dimensions, Accounts & Time. The source module has the Model Calender with Month as the Time Scale. The target Module has a Custom Time Range with Quarter Totals selected & has Quarters set as the Time Scale. Both Summaries are set to Sum When I reference the source module using…
Referencing Batches of Same SKU to calculation QTY of expiring materials
Hi All, I've been racking my brain over this one and I can't think of a good solution. I want to calculate the amount of inventory that will go expired for a given batch of materials, but as we cannot reference another rows easily like I can in Excel, I can't think of a good way to do it. Here are my basic assumptions and…
Using Python's statistical capabilities to Manipulate data already in an Anaplan Model
I want to leverage Python's statistical capabilities to manipulate data already in an Anaplan model. Has anyone done this before / had any experience with this? I know I can use Python as a data integration tool, but would like to also use it for calculations.
Is it a Bug?
I have a dimensionless module with two line items Line Item 1: Amount (No TimeScale, No Versions applied) - Number formatted Line Item 2: Absolute (No TimeScale, No Versions Applied) = Absolute value of Line item Amount Change the Formula Scope of the Line item Absolute from "All Versions" to "Actual Version" or "Current…
Migration to new SKU code
Hi All, One of my client is under IT systems restructuring and migrating to new ERP system. Because of that the SKU codes for ~6000 SKUs will change to 18 digit in a couple of month. In Anaplan we currently have old codes for SKU and there is another numbered list of SKU-Customer combination code of around ~100000. What is…
Upload - Non Mapped Source Items Identification
Hi team, Is there a way to identify Source Items in a list that have not been mapped to an item in the target for a Upload to a module in Grid Mode? I am aware you can manually identify the non-mapped items by scanning the Mapping tab but this seems inefficient and error prone (especially with large data sets). When you…
Cumulate Issue
Hi All, I just need a little opinion whether excel is wrong or Anaplan. See below. So i only copied the values so there is no formula. Excel Driver Cumulate formula it adds the Excel Source value and Excel Source Plus value. So its like Sum(Value, PLus Value). The problem that I have is in Excel Driver when they cumulate…
Input into different hierarchy level and display balances in one module with Hierarchy and COA dim
Hi, I've been digging around all the resources but could not find any solution to my problem. We are trying to build a legal hierarchy tree (ragged) with inputs into each entity in varying levels and then presenting those inputs in one module with 3 dimensions: legal entity hierarchy tree, chart of accounts, and months.…
What's the difference between a model and an algorithm?
What's the difference between a model and an algorithm?
Find the minimum contract quantity falling within a contract range
Hi, Hope you all are having a good day so far. I would like to identify the least contract quantity falling within a price list range. if 10 contract quantities fall within a price range then I would like to choose the least from it. The catch is that the contract quantity is a calculated value and it is calculated for all…
Weighted Average by variable number of weeks
@rob_marshall I am looking for some guidance on how to do weighted averages based on a selected amount of weeks? Our call center planning is in need of looking at weighted averages based on a variable amount of weeks For example, a user selects the number of weeks they want to average the results by and based on that…
Switchover
Hi All, Is there a way to disable switch over in blueprint view for a line item without a time dimension? Thanks N
Ability to copy a List
There are occasions when I need to have a list that is similar in structure or content but serves a different purpose in the application or where I need to have different children but similar parents in the same module. In this case my only options are to export the data, create a new list and add the properties and…
How to calculate % of one row over another row?
Hi guys, I am trying to do the calculation of % of Show Specific / Total Universe and it's not giving me correct %. In the image below, the correct % should be 5401 / 21682 = 25%, but it's showing 4800%. Can someone please advise what I did wrong? Thanks, Jim
Sum based on specific value from another column?
Hi All, For line 3 in my module, I am trying to sum ONLY the lines where Total Inventory = Regular (Dimension), how should I setup this equation?
Update/add
HI, users should add/update the changes in the module.This should reflect in the Target modules while they submit. Like if already there is employee assigned to company and again if we wanted to update the details of employee how do we do that?
Displaying Line items by user or role
Hi, I have an issue I'm trying to solve. I have a module that multiple users have access to. I don't want all the users to see all the line items. I need to hide 2-3 line items for certain users or roles. Another module without those line items is not an option. Is there a way to this? Thank you Ronit
Circular Reference Issue
Hi Guys, I need help in figuring out a workaround for Circular Reference. I recreated the modules the best I can and I hope its enough to understand. See below: This is the driver module and this is already working fine in Anaplan. Lets say Row 1 and Row 2 and then Time Dimension. This is the countif module, this also…

Modeling

Discussion List