Modeling

Find List Item based on Property
This is probably straightforward, but I'm struggling with it... I have a module that includes historical department names, which are combinations of numbers and text, i.e. "5100 Engineering". Sometimes the department names change, for example "5100 Engineering" might become "5100 Core Engineering". I want to create a list…
Pull/Lookup data from general list into module with numbered list
Dear All, Appreciate if anyone can help me on this. How to pull/lookup data (properties data of Total Area sqf) from a specific general list (Detail Project Component list) into a module (Master Tenancy List) that contained a numbered list with parent hierarchy is Detail Project Component? If not using numbered list, yes…
Please allow expandable fields or a preview of content.
Hello, i can not find the section where suggestions are made but please please please can we do something about the inability to see details in a field. Example below, i am quite sure the customer is not importing from the same module to the same module, but maybe they are using a view, it is impossible to tell from the…
Sum to get total sales based on a GL Value by month
Hi, I am pretty new to Anaplan and i am hoping i can get help with a problem i am stuck at. Below is a mockup of my data Module 1Transaction 1Transaction 2Transaction 3Transaction 4Transaction 5Transaction 6Transaction…
Configuring a filter for nodal values
Good afternoon! Tell me, please, how can I implement the calculation of a formula related to text functions with ITEM on a node element? The problem is this: 1)Data HUB was configured, which forms balanced hierarchies (in accordance with the course 305 and this topic in the community). 2) In the basic model it was possible…
Automatic update of Current Period
Hi, this has been posted a couple of times before and I am not sure if this has been solved or not. How do we ensure that we have the time period updated automatically in Anaplan? Should we always do this manually every Week? Thanks Sidd
How to update Current Period automatically
Hi, Anaplanners I'd like to know how to update Current Period of Time setting. I change it everyweek by myself. but if possible, I'd like to change Current Period automatically. If you know how to set it up, Could you share ? Thank you for your help in advance 🙂 Regards, Hirokazu
How can I copy data from one module to another against hierarchy
Hi, I need help with something am trying to achieve in Anaplan. Module 1 Organization List (Organization Hierarchy is L1-Global->L2-Country->L3->Regions) Line Item: Volume Module 2 Organization List (Organization Hierarchy is L1-Global->L2-Country->L3->Regions) Line Item: Volume1 Line item: Select Level of Analysis…
Past 90 day functionality
I am looking for a rolling function that calculates the total value of opportunities over the past 90 days from the current date. Any suggestions or formulas would help! Thanks
Creation date for the record entered
Hello Need your help in finding way to populate the creation Date/time for the new record entered in the General List. Thanks Regards Prabakaran
When a data point extends beyond model's time range
I have run into an issue with correctly mapping monthly depreciation costs to the periods within the fixed asset's useful life. Module A (screen cap attached) contains the user inputs for the fixed asset including the depreciation start and end dates for the asset. In this module there are also two line items that use the…
Daily planning custom time scale
Hi Has anyone ever built a custom time scale that can handle days to day operation? . I try to set time scale for import inventory data in daily level. But model calendar cann't set into daily level. In the model , I need to display and calcutate for daily planning. Please suggest. Thanks in advance
If item is contained in list
I was reading this and on the EXAMPLE section, there is a IF condition as below; IF ITEM(Products) = Products.Widget THEN <... calculation for Widget ...> ELSE <... calculation for other products ...> This made me wonder, does Anaplan automatically compares each items within the list? In Python term, I am thinking Anaplan…
Alphabetize Lists
How can I quickly alphabetize a list?
Does Anaplan have a "contain" function for words?
Hi, I am trying to create a module (line item) from a list formatted as boolean. Does Anaplan have a built in contain function so that I can select the words that I want ? i.e. if column 1 contains "SKY" then TRUE else FALSE Thank you!!
How to create "One employee reporting into two managers" as a list(hierarchy)?
Hi, Is there a way to set up a list (hierarchy) in Anaplan when the hierarchy is built the following way: One person and two managers. ManagerEmployeeLowest level in the HierarchyManager AEmployee ACost Center A Manager BEmployee ACost Center B Any help is greatly appreciated! Thank you.
How can I copy data from one module to another
Hi, I need help with something am trying to achieve in Anaplan. Module 1 Organization List (Organization Hierarchy is L1-Global->L2-Country->L3->Regions) Line Item: Volume Module 2 Organization List (Organization Hierarchy is L1-Global->L2-Country->L3->Regions) Line Item: Volume1 Line item: Select Level of Analysis…
Adding dimensions to the Statistical Product Forecasting APP.
Hi everyone, I would like to expand the Statistical Product Forecasting App with another set of dimensions. The model now only models the dimension of the products (hierarchy L3) and time. I would like to add another dimension, for example: contract sale and a non contract sale. Does anyone have expierence with adding an…
Look up values in a module that stores data against a list
Hi Anaplaners, I am new to Anaplan. Please help! Module A: Lisy Y: List of years Line Items: LIA1 Format: Number Value(Has a value stored for every year) Module B: Line Items: LIB1 Format: List Y Value 2018 LIB2 Format: Number Value 2 LIB3 Format: Number Formula: 'Module A'.'LIA1' [LOOKUP: (LIB1+'LIB2')] I want to get the…
Restoring Archived Model
Hi Experts, Could anyone please tell me, is there any we can un archive the model which is in deployed mode. I want to roll back my production model which is in deployed mode. Also, needs to do a compare and sync from test environement with un archived model. Not sure will it be compatabile if I do the compare and Sync…
Changing seperator in csv export to semicolon
Hello everyone, I would like to change the seperator in the CSV export from a comma to a semicolon. Does anyone of you know if this is possible? Kind regards, Ralf
Data Export with Filters
Hi, I have a module with a time as a page selector, it holds a forecast data snapshot, and if i choose 'Mar 18' it shows the data i need, i have saved this as a view, and then I export the data to a csv file. If i change the selector to 'Feb 18' and then run the saved export action, it exports the data, still using 'Mar…
Convert a date from a TEXT formula to quarter
Hi there, I would like to create two new items for calculating “Renewal Date” and “Renewal Qtr”. I am able to figure out the calculation of “Renewal Date” but not the “Renewal Date” into quarter. Sales Type (Format: TEXT) Date 1(Format: TEXT) Date 2(Format: TEXT) The formula of “Renewal Date” is: IF Sales Type =…
List view with list and metrics in rows
Hello experts, is it possible to model a list display that can show list items and metrics repeated in rows. Please see attached picture. In an excel pivot, this would be dimensions and "Values" in rows. I tried looking at the complex, sub-list list types, but couldn't figure out a way to model this. Thanks for your help. T
Break data equally into Weeks from Months in 445 Distribution
Hello All, We have requirement where user will enter the numbers at Month level and the same has to be broken equally to the week level. All the rest of the data resides at Week level and hence the distribution used is 445. Is there any simple way to get this done. Need urgent help. ! Thanks
Saved Views in Dashboard
Hello, I have a module with 6 views saved, and have published one to a dashboard, however I would like the dashboard to show any of the views, but only one at a time, chosen by the user, if this is possible?
Remember field status before importing new data
Hello, We import a rolling 4 week view of orders (from external) into a numbered list very week, this list is then used as a soruce for a model. In the module there is a booelan for 'approved' the user ticks orders that are aproved so they dont have to check again. We clear the list each week and import fresh data. I want…
Collect and Select
Hi all, I have a question concerning the combination of the formula Collect() and SELECT[], let me first explain my setup: - Attachment 1: I have a module 3 collecting various information from several modules for every row item (code2: Mortgage loan fix, Mortgage loan variable, ...), now this module works perfectly and all…
Identify Children of a List Item
Is there a way to determine which items are children of another item? For Example, if my hierarchy has the following structure: World - Americas - - USA - - Canada - Europe - - UK - - Ireland Is there an association I can use as a lookup to determine this relationship in another list or module? For example, I select…
Some one experience connecting to Anaplan via the API?
Hello Folk's I followed the guidelines on docs.anaplan.apiary.io/#reference/export but still have some questions concerning these exports I'm connecting to: how are they updated with Qlikview? Can I connect directly to the tables, or do I always need this intermediate level of exports to get to the data? Thanks!

Modeling

Discussion List