-
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!
-
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