-
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 :…
-
Move data between Anaplan & SAP
I am looking for possible & efficient ways which can be used to move data between Anaplan & SAP. In the past i have used SSIS to do same between Anaplan & MS Dynamics365/SQL Server, by using Anaplan API to execute import & export actions. Is there a tool which can give me a similar approach for SAP as well?
-
When to use lookup/sum versus when to refer cells in anaplan
I find a little bit confusing on when we would use the lookup or sum function rather than refer the cells in anaplan. Can you help me to explain more about this? I also note that lookup is for looking up non-repetitive value on the source file, while sum is for summing up repetitive value on the source file. Depending on…
-
delete
-
How to flag SKUs based on the lowest revenue
Hi, I have a module Target Setting with 3 dimensions: Brand, Category, Time. Users make an % input to indicate how much each combination should increase Revenue for the next Year. Then, the Target SKU Reduction line item is calculated within the same module to inform how many SKUs should be discontinued to meet the target…
-
Is there a way to reset the List Ids to reorder it correctly?
Hello everyone, I am building a date range filter to allow a use to select weeks and then have it filter to the days belonging to each week. I did this by having a report days being a child of Report weeks and using an Time calc to set up the range. It is working like I want by showing the correct list items. But they are…
-
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…
-
Browser Slowness when Model Building
Has anyone else noticed that after 15-30 minutes of model building activity (opening modules, opening lists, updating formulas, opening split views, toggling from blueprint to module view, etc.) that browser tabs slow down and stop responding, and has to be restarted. Been an issue for a few weeks now. Hardware and…
-
Summing a line item with a formula summary method
Hi I have a module that is calculating correctly for each line item when I apply the Formula summary method as its based on the dimensions listed in the context selectors. I need to return the sum of this line item (highlighted in yellow) in another module but it obviously returns zero. I am sure I am missing something…
-
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…
-
How to get Range of Values between two Booleans that are time formatted?
When the user select Two Boolean Check the range is defined so I want to get the range of values respective months.
-
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…
-
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…
-
native time and snapshot period
I have two different modules. Source is dimensioned by Study top level & using snapshot time (only previous month will populate at the end of every month). My target module has native time with a subset of active Study. I want to get the data in my target, if any study has a value in my source that should populate in my…
-
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…
-
I need to add new item to Tree View (General List)
There is no option to enter a name to 4060 item line. Can someone help please?
-
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…
-
Drive dimension selectors from undimensioned module
Hi, Is there a way to drive dimension selectors from a module that has no dimensionality? I have 2 modules: Select Dimensions no dimensionality, just line items that are formatted by dimensions entity and department, etc Income Statement dimensioned by entity and department. End-users would like to make entity and dept…
-
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?
-
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…
-
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…
-
What is the maximum number of dimensions (aka list) per each Anaplan module ?
-
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…
-
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…
-
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…
-
Mapping modules dimensioned differently
I want to be able to pull over my Snapshots from SYS: Snapshot Lookup into my time module via lookup using my Week Number and the Code since they are both text. My lookup module isnt dimensioned by time but it shouldn't have to be, what am I missing?
-
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…