-
Copy month data
Dear, I have two questions regarding an implementation I'm currently working on. To give a little background information, it is a financial planning model for the coming 3 years and has a budget version and 4 different forecast versions. My questions are the following: [list=1] * Copy data from one month into all months* I…
-
Semi solution
I have been thinking about the issue and I found a solution, however to keep it feasible with formula's limiting the IF-function, I need a bit more help. Currently my solution is to recalculate the percentages in the final module, however I need IF function for every line item, as all of them are calculated differntly. For…
-
Synchronization using ALM
Hi, I want to move a structural change (adding properties to a list) from one model to another using ALM features. I'm not sure how to operate that, so are step-by-step instructions and screenshots on comparing & synchronizing available anywhre in anapedia? It would be very helpful for me. Thanks and regards, Maki Yasuda
-
Salesforce Connector
[img alt="Harisha.Mo" height="40" id="_x0000_i1025" style="border-radius: 5px; height: auto; line-height: 100%;" width="40"]http://www.gravatar.com/avatar/8794d4330529f879433f7490a8f5c294?size=40&default=https%3A%2F%2Fassets.zendesk.com%2Fimages%2F2016%2Fdefault-avatar-80.png&r=g[/img]Hello, How can I add a Salesforce…
-
Merit Increase Formula
Does anyone have formula string they like to use to calcualte merit increases in a specific month? As an example, if my merit increases every March, I would want my wages line to increase automatically by a % every March.
-
Compare Display names of two numbered lists
I've two numbered lists Numbered List 1 (storing a set of product codes) and Numbered List 2 (storing another set of product codes). - Product codes are stored in Display Name property Two modules - Module 1 based on Numbered list 1 and Module 2 based on Numbered list 2. In module 2, I've a line item which needs to check…
-
Filter on specific text in text formatted line item
Hi, I'm trying to filter on a text formatted line item. The source of the text is from another module through the textlist formula. In the text formatted line item there are several descriptions of transactions and I need to filter some words out of the string and then use the result to predict descriptions for…
-
Salesforce Native Integration Module Import
Hello, Has anybody had success using the Salesforce Native Integration to import data directly into a module? We have successfully connected the integration and can import data into lists, but not modules, just wondering if anybody else has tried this and if it is a platform limitation or something wrong with our setup,…
-
Integration with Microsoft Access Database
Hi, I need information on how Anaplan can be integrated MS Access for importing & exporting data to lists and modules. Also, need information on how the same can be automated based on certain triggers or on the click of action buttons. Thanks, Aseem
-
Comparing Line Items which has Numbered List Format
Hi, How can I compare two line items of two different modules (Format: Numbered List)? How to check whether a single entity/ entry is present in two Numbered Lists? (Both lists are Numbered Lists) Thank you
-
Conditional Formulas
Hello, I am attempting to make my budgeting model easier to roll out to every country my company is located in. To do that, i need to make one page where all the settings are per each location (for example: taxes for specific locations/countries, location specific benefits, etc...). Bascially I want this to look like is…
-
Anaplan Error for Assign Action
I am trying to Assign Support to another individual for quota purposes. When I run the action, I keep receiving the error: 'Model commit: cell reference is not writable.'. This only occurs on this one level but not any of the other levels (they are currently working). Why would this error appear for this level and also…
-
Delete List Item Action on Dashboard
Can I publish a "Delete List Item" action to a dashboard? Thanks, Mark Peck
-
Open a Different Dashboard Depending on List Property
Hello Fellow Anaplan'ers ! I have a requirement wherein I need to open different dashboards with the same action, based on list property. I use the native functionality provided for this; however for all different values of the list property, the button opens the default dashboard instead of the relevant dashboard. I also…
-
Product Hierarchy
Hi there! We have one prod hierarchy but we would like to introduce a new one that is linked to the top level but splits afterwards. One business unit should be able to see the other and vice versa. Currently, we have : -All products -Commercial Business Unit ---Prod Line -----Prod Fam ------Prod Sub-Fam -New BU ---Prod…
-
Data not clearing out
I have an issue with a decimal showing up in a formula that's supposed to generate 0. Line Item A: 48250.4 Line Item B: 65810.4 Line Item ClearAB: A+B-45250.4-65810.4 yields 0 Line Item ClearABAlt: A+B-(45250.4+65810.4) yields 7.275957614183426E-12 All items have same numeric format.
-
Issues with the Summary
Hello, I am having issues with the summary. I have an item that multiplies a tax rate, this taxe rate is unique per subsidiary, but when i select the total subsidiaries level, the multiplication instead of taking the rate assigned to its subsidiary takes the sum of all the rates. An example: Subsidiary 1- Amount: 100 rate:…
-
Selection of Version used in Module
Hi All, Does anyone knows how to select the current version being selected(not the one which is marked as current in VERSION) for the particular module , which is selected .
-
Large data deletion at once
Hi, If I want to delete large data in a module at once, how should I do? When I selected a lot of cells and then hit the delete key, Operation Unavailable message was shown (as attached the screenshot). In what kind of situation is this message shown? Also, doesn't Anaplan have all data deletion command? Thanks and…
-
How to give selective access to Drill Down Function
Hello, Anaplanner 🙂 I'm conducting the implementation of ANPLAN. In this project, Many companies give their data (ex: Purchase order, Reply order, Inventory etc) to one ANAPLAN model. We collect the detail data and make dashboard by combining that. so we have to give selective access to each companies. (See Attach)I thiink…
-
Freezing Data
Hello, Is there a method within Anaplan to freeze a version i.e stop it from being rules calculated, whilst retaining the data? For example in a module I have two versions - Fcst 1 and Fcst 2. The same rules apply to Fcst 1 as they do Fcst 2. However, at a future point I would like to freeze the data on Fcst 1 whilst Fcst…
-
Dashboard Bursting
Hello, I am curious to know how we can create and export individual products/sub region dashboard to PDF without creating it one by one . ( similar to one like report bursting) Thanks, Suneesh
-
Get prev year result
I'm quite new to Anaplan and I would like to know if this formula is possible instead of IF Current Month THEN Variable Name[SELECT: TIME.'Nov 15'] this IF Current Month THEN Variable Name[SELECT: TIME.'ADDMONTHS(CurrentPeriod,-12)'] Is it possivle and am I using the correct syntax. Chris
-
historisation of data
My client wishs to backup data and not loose it when the time periods change. To do this I envisage modules with not applicable time and containing 2 lists: one the months of the year, the other the sequential years that he wishs to save. My difficulty is to transfer the data to these modules. In the source modules, in the…
-
Transaction Roll Forward on a Custom List
Transaction Roll Forward on a Custom List
-
Selective Access
Hi, For example, Selective Access is applied the list labeled 'Samples1' which has 4 list items and the top level item of 'list total' like the screenshot attached. In the module using the 'Sample1" list, I want to give some users read access to AA, BB and list total (No access to CC and DD). However, when access is given…
-
Formula for comparison of previous quarters and months
I am looking for a correct formula where, in a destination module, if I do a time selection on a specific month I get the periodic value and the ytd value of that month and the previous month. But in the same line item the formula should hold when I select a quarter. So when selecting a quarter it should give me the…
-
Workspace Space Evaluation
I am wondering if anyone has any helpful tips to use when evaluating space within a model or workspace. For example, taking into consideration our current data loads, lists, dimensions pulled into reporting etc, how much space adding 1 fiscal year would take without doing anything else. Any information regarding this would…
-
Time filter per project when project are in rows
Hi everyone, I'm facing the following situation. I need a different time filter per project (WBS-Elementen), but my projects are in the rows and so are my line items. When I try to filter the timedimension using a timefilter (boolean) I need to select a project, because there is no 'Current page'. Is there a way around…
-
Hiding subtotal lines
Hi, Where two lists are prepared in a hierarchy structure, is it possible to hide the parent's subtotal line in a module? For example, where the two lists of product category and products are prepared (screenshot_1.png), I want to get the results without product category subtotal lines in the module whch calculates sales…