-
List to module, most efficient way?
Hi Do anyone know what the best way to link a module to a list is? Cause in our models we keep databases in lists, to be able to keep track of the history. The end useres are uploading a data file, which is then stored in the list, with needed column data saved as properties. My question then goes on what is the best way…
-
How do I import only 1 occurrence without errors?
I have a DATA module with a line item named "Scenarios." I need to import this line item into a list also named Scenarios list. The data module is dimensionalized by a different list so I cannot use the isfirstoccurence() formula. What's the best practice when it comes to importing this line item into a list as to not have…
-
dimensions look up
I have a REF module dimensioned by a list of vacations: this module represents with a hierarchy, a column of start date and end date. (the "vacation list" is a child of "team"). I have a second module dimensioned by Team, which I'd like to model by day, so that I can boolean-select the days off. I've set a formula of :…
-
link text-formatted line item
Hi All, I have a question from a partner.., Can you please confirm that it is not possible to link to a file destination in Anaplan using a link text-formatted line item. The link text-formatted line-item defaults to http// and the file destination our client uses has a different prefix using backslashes (\\). The links…
-
Query on Efficient List Creation Method
I'm seeking advice on the quickest method for creating lists in Anaplan: using the UX Page "Form action" or the backend Actions for Creating List Item. Which approach is more efficient?
-
Do you feel it will be good to have Supply Chain related functions ?
Since Supply chain use cases are picking up, do you feel it will be good to have supply chain specific functions in Anaplan. If yes, then kindly promote the new idea I posted.
-
What is the maximum number of dimensions (aka list) per each Anaplan module ?
-
Avoiding circular reference using daily workaround to simulate PREVIOUSITEM() function
I'm working on a tops down attrition allocation model. We want to be able to input an annual attrition number and allocate that down to the lowest level (Month, Country, Segment, Attrition Type, and Tenure). Given that attritions have to be whole numbers I've been using MOD() to carry forward the probability of an…
-
SOS : A modeling question
Hello Everybody , I have two lists in Anaplan , let's name them countries with all the countries in it and a second list called products with all the products that a company have. I want to give the possibilty for the user if he check a country , he will see only the products in his country. So my question how we can do…
-
anaplan level 2 sprint 1 activity 1.5.6.1
Hi all, I have problem while importing data into Historic Volumes Module. The csv source file contains data (image 1), but when I run importing into modules (image2&3), there's no data at all (image 4). What should I do to fix this problem? And by the way, I do not get why we select "Column Headers" for "Volumes". I got…
-
Multiple revision tags
Hi All, We can create multiple revision tags in the dev model for specific changes & while performing sync with PROD, these revision tags gets highlighted, however if I select the latest revision tag "add6" - all changes incl. changes specified under "add4" also gets updated. I believe revision tags works cumulatively, if…
-
Convert date to time format
I want to calculate the # of days in a month without using the PERIOD function. No time scale for this module. E.g. 10/15/2015
-
Alternative to SELECT:TIME.ALL PERIODS?
Hi, Is there an alternative to SELECT:Time.All Periods which will allow us to query whether a line containing time contains data not equal to zero across all time periods. The target line item does not contain time. I would usually just use SELECT but I would like to get the same outcome without having to use All Periods…
-
Why is there a round at the end of a number converted from text?
Hello, I am converting a text into a number to do a complex sort. It adds code from several different dimensions to create a large text. Then I convert it using value. When I do this, the final 3 digits are being rounded unnecessarily. Does anyone know how to get past this? Original text: 23921101010004270452 Converted to…
-
Refresh data hub to Spoke model
Hello, I have two lists on my Datahub. On the Spoke Model, I import these lists through a saved view, and on Apps I have a spoke model refresh page that should import me the changes made on the Datahub app. On the Data Hub App: I can add a line to the list and I can delete it. The problem is that when I refresh my spoke…
-
Complex GL Account Mapping to Cost Centre for Allocation
Hi Anaplaners, I want to mapp certain GLs to CCs and vice versa. Additionally I want to map certain cost centre to all GL Account and vice versa. Based on the mapping I would input an Allocation % for those mapped GL & CC. The mapping is done on the lowest levels of the hierarchy. It will also have the Parent of the GL…
-
How to manage Workflow-Approve/Reject
Hi, I am trying to create workflow for my project. My module has product(10 prod), customer(10 customers), channel, & version dimension Product, customer & version list has selective access enabled. I want to create workflow for single quarter, Step 1) Assigner workflow to planner , he will plan everything in top grid and…
-
How to reduce huge dimensions
Hello, I'm having a lot of issues with workspace size, with models going above 150/200gb in size and I'm not sure how to reduce it, to give some context, I have three main lists (size considering subtotals): Products (~1,5k) Countries (>100) Customers (>270) The issue is that if we apply all of them to a module what we get…
-
Public holidays building modules
I want to be able to display a table of public holidays by country on a dashboard. My problem is that in some countries, public holidays can change from year to year (unlike New Year's Day, which is always 01/01). The steps I've already taken: I've created a SYS10 public holidays module where I display the date and a…
-
Prorata Calculation Using Dates
Almost done with my module. I need help in developing a formula to compute the monthly amortization that looks at dates.