Modeling

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!
Rolling Sum based on Target days/weeks
Hi, I may be overlooking the obvious, but in the sanpshot below the blue figure is the sum of Demand for 3 weeks (21 days indicated by the Target Stock days) Is there a way i can formulate this? So it Totals the demand based on the number of days in Target (i understand that i may have to use integer(21/7) instead of…
How to show the data directly rather than drill-down?
Hello, Background: I have a numbered list with a property NLIST Name: Genera_Special PersonType <<Property Name John Doe General Bill Gates Special Joe Neighbor General Steve Jobs Special There is another numbered list NLIST Name: Rich_Poor RichOrPoor John Doe Poor Bill Gates Rich Joe Neighbor Poor Steve Jobs Rich What I…
Need to use annual amount in a formula but comparing it to a monthly amount in same module?
I have a requirement to show the following: annual quota * multiplier = target then compare month orders to this target and see if the person exceeded the target. I have a module at a monthly level, and if you go down to the Quarter or monthly level, the quota keeps changing, i need this amount to remain static, and let…
Adding a new column... WHY do i have to SHOW all of them and HIDE again
Hi No idea where the 'suggestions' forum has gone too, so will try posting this here. I have a module with 48 columns, and i have a dashboard where 24 of these columns are visible in a user requested sequence, if i add 1 new column to the module and want to see it on a dahsboard, i have to show ALL 48 columns then remember…
Request for SUMProduct function
Currently only when you use Time you will be able to use PREVIOUS() or alike function. These functions doesn't apply to Lists but at CBRE I have a case where do need a similar function. Today the SUM function, which doesn't allow for Product, therefor my enhancement request to create a function alike Excel function…
Level mismatch on common dimension
When trying to change applies to in the model - I get the error "Level mismatch on common dimension" - essentially switching out a list for another.
Countifs Function
Hello, I've researched this topic but haven't been able to find a clear answer. I'm looking to create a headcount dashboard that tracks historical headcount by function over time (by month). It looks as though I'll need to combine an "IF THEN" and a "SUM" function. I am referencing a module that has: Employee Department…
Poll: Is Anaplan your system of record for plans?
Just wanted to poll the community here - is Anaplan the system of record for your finance/sales plans? Or, do you expect the data you input to be transient and not persisted? (Not asking about transactional data coming from other systems.) Thanks!
Unable to import data for numbered list
Hi, In my model, I have an employee list which has been created as a numbered list with combination of properties (Emp ID & Cost Centre) to identify uniq. Now i have create Employee Cost module to which i need to upload the actuals number. In my source file i have Emp ID & Cost center codes. Can someone suggest me which…
Let end users add Clickable links
Hi Everyone, I'm looking for a way to let end users add documentation complementairy to their input into the model by adding a link to an external document. I created a lineitem (format text/link) in which they can add the link to their documentation. When they click the cell in which the link is posted, the link won't…
Importing data into months within a weekly timescale to breakback
I have data in a module with a monthly timescale that I want to import into a module with a weekly timescale so that it breaks back evenly across the number of weeks in that period but I can't seem to be able to do that via a data import. Is it possible? Likewise - if I wanted to upload from a CSV containing monthly data…
Retrieving YTD value when timescale spans multiple years
Hello, I am having trouble with how to model for multiple time period aggregation combinations. Using units as an example, I want the units for the individual time periods, quarters, and years, however I also require the QTD, YTD, and YTG (Year to go). What is the best practice to incorporate this into a module? I…
Referencing Line Items from Other Modules/Lists (Performance Questions)
Is anyone able to describe the performance impact (if any) of referencing line items from other modules or lists which have the same relevant dimensionality? Particularly using SUM and LOOKUP operators. For example, a model may have a Register A and a Schedule B (over time), both of which have the same dimensionality…
Date Conversion
I have a line item that contains the date in a Text Format(examples below). Is there a formula that can convert these numbers to a Month Format? 2018001 2018002 2018003 2018004 2018005 2018006 2018007 2018008 2018009 2018010 2018011 2018012
Actual vs Last Year
I would like to store last year actual value in version. So my version willl have Actual, Last Year and Act vs LY Variance. Can I achive it using formula in Version setting? Thanks and regards, Maung Maung
Show hidden content
Hi, Is there a way to disable "Show Hidden Content" at the bottom of the content list? I want my users to be able to view the dashboards only wihtout viewing the modules.
How to use the SUM function
Summary: When building Anaplan models, the SUM function is used to add up values that meet one or more specific criteria. Find out how to construct a formula using the SUM function in this short lesson. Course Objectives: By the end of this lesson, you’ll be able to: * Identify source and mapping cross reference data to…
how to apply top 10 filter
Hi, We have list that has around 4000 clients. In the module we have uploaded Revenue of the clients. We have sorted out the list in descending order based on Revenue. Now we need to apply filter to show only top 10 clients. I tried using filter option. I couldnt get the data. Can someone suggest please. Thanks, Sangeetha
Eliminating 0 cells without subsets
Hi, Is there a way to eliminate the cells with 0 from Module in order to reduce the space consuming. I have already gone through 310 - Elilminating Sparcity course, in which recommandation is to create subset for the list & eliminate unnecessary verions or lists used. But in my case i can't create subsets as it is a list…

Modeling

Discussion List