Modeling

Export selected list members
I need to export only few list member details. Can someone suggest which will the possible way to do so?
Selective List Export
Can you please tell me is it possible to export particular two List Members and corresponding Line Items?
modelling
Hello, I have one scenario where i have to select start date and date. my requirement is end date should not be selected before start date and end date should always greater than start date. Thanks,
What Anaplan Does Distinctively?
Many many things, though few to spotlight as thoughts of the moment: * Delivering an enterprise-level planning analytics applications without any dev-ops process. Unbelievable! * One-stop solution to hosting data, making transformations, managing hierarchies, and providing real-time reporting. Completeness! * Data View/…
Anaplan Lookup Question
What could be the underlying reason behind allowing lookup only through list formatted line items, not through a normal text formatted line item?
Production Optimization
hi I am working on production optimization.I am getting error regarding C3 constraints. I have attached screenshot of formulas. Please guide me.
'Is Organization'
How can I edit the "Is O
Are Star Schema principals a good approach to modelling in Anaplan?
From my viewpoint and understanding: * It can help a lot to cut down the model size * It can make models more sleek and high performant * It will also add to the maintenance of highly complex models * It will add the greatest design value of Unified modeling Would love to hear about these bullet points from community…
Anaplan Account Registration Process
Hi Team, How do I create my Anaplan Account? I need to integrate with Anaplan REST APIs. Thanks Anuja Agrawal
Will Anaplan have ability to run scripts in future?
To Anaplan Product Leaders, Will Anaplan have scripting (i.e. running python scripts, writing your own functions) capability in the future to build logic beyond formulas. Like providing programmatic access to data. Anaplan Enthusiast, Hemant
OEG Best Practice: SFDC Lightning migration
Migrating from the classic SFDC platform to the Lightning platform can create unintended issues with some Anaplan models. This article covers issues with SFDC objects and the steps to correct them. Challenge: When migrating from the classic SFDC platform to Lightning, the SFDC domain name/ URL changes. In our example,…
Sharpening The Anaplan Saw
Sharpening the Anaplan Saw Some experiences to share from Anaplan Learning Curve: * Have a look at Anaplan App Hub and only read the description of apps in Anaplan App Hub first. This will build an unparalleled excitement, enthusiasm, and energy. * Read about Anaplan in Gartner Magic Quadrants' reports to realize the…
PROPER() Functionality
When we are dealing with Text formats in Anaplan it is case sensitive and it throws unexpected results if we don't do it exactly the way it should be. Although we can achieve this by amalgamation of LOWER, UPPER, FIND, LEFT & RIGHT functions. Having PROPER function would greatly reduce the need to do so.
Ignore Value Parameter for MIN Function
When using a minimum function, it would be ideal if we could exclude specific values, or a list of values, to avoid returning zeros or another value. For the aggregation function x[MIN:y] you may want to exclude zeros from the formula. Currently the workaround is to use a large number in place of zeros, eg: "IF x = 0 then…
Data Store
Hi Experts, May I please know how calculated data is stored in Anaplan? For Example, we have 3 line items A, B, C. A and B have values 10 and 20 in a module. We write a formula for C = A+ B in the module. So in the backend, does Anaplan store the values of A and B only without storing the calculated value of C in the disk,…
Optimiser
Hi Problem Statement: we are trying to minimise the fuel requirement to provide a given amount of energy. As all the input datas are in month wise for all the fuel except the demand in which month wise aggregated demand of all fuel has been taken. Error: We will be able to run the process sucessfully. But we are not…
Is there a way to set a numerical goal and track its progress throughout the quarter on a Dashboard?
I am looking for a way to communicate a sales goal by product and channel on a monthly basis. Please let me know if you have any ideas, Thanks!
Data load for duplicate rows
Hi All, I was trying to load data into a module, but my data file has duplicate rows. when I load the file, I was expecting the duplicate rows to be ignored or flagged as duplicate record value but it getting added in the member value. Example: Dimension Line item(amount) row1 ABC 10 row2 DEF 20 row3 ABC 30 row4 DEF 40…
New UI
Hi Team, How can we publish Selected Line Item to Dashboard in New UI? Please help.
CUMULATE WITH LISTS WITHOUT CUMULATING WITH TIME
Hi, I am having a module having a list dimension and weekly time scale. I want to cumulate the values of a line item w.r.t list items without cumulating it w.r.t time. Is there any way to do so ?
Workspace access
Hi, I'm a student. How can I get workspace access? Thanks!
Community Vlog #2: UX Design—Greg & Mark
The Community Vlog is back for December! Through these short video interviews between two members of the same team, you’ll get to know some of the people that work directly with our customers and behind the scenes on our platform. In this second Community Vlog, Greg Meek (@greg_meek) and Mark Boyes-Smith (@mbs) discuss…
Count back for turnover
Hello everybody, I've come across a task to count some KPI's based on count back method. For instance, I need to count how many days it takes a company to cover its Account Receivable (AR) amount with monthly Revenues. It means that if a company has AR at Jan end = $ 2000 and Revenues as: current month (Jan) = $ 200…
model builder leverl 1
Hi, i'm a student, how can I get access to the model builder level 1 course? thanks!
Determine if List Item has been used in List Formatted Line Item
Hi team, I have a list of #Employees & am allocating a #Job Role to each of them (results in module EM23) & want to highlight which list items in the #Job Role list have not been allocated to a #Employee in module EM23 I tried using FINDITEM (see below in EM43) but this not returning anything due to it being…
Circular reference with previous value
Hi, I have two line items in my module. The first value in the first line item is picked up from an another module, but the second value is first value of second line item and so on. My second line item is a product of first with some number (x) When I use Yield = Starting Yield Coupon * X - I get a circular referencing…
Connected Planning Playbook
Is there any link from where I can download the Connected Planning Playbook ? Currently it is just online - and has separate lessons under separate tabs.
Related to anaplan app hub models
Hello Team, Recently I analysed 2 app related to insurance industry ie., Planning budgeting and forecasting for insurance and premium modeling. So I would like to know if there is any connection between those two apps.
Please fix opening a menu from the drill-down view (i.e. to open the source module)
Hi, Currently, if you drill down through several layers of modules and try to open the menu of a module to open the source module it appears as if the menu has not opened. I have learned from experience that the menu does actually appear, but seemingly in a random position further up from the drill down tabs, and floats…
Anaplan Optimizer
Hi Team, I am currently working on Optimization Exercise Model. In Network Optimization Objective/Variables Dashboard, I ran the Process Network Optimizer but I didn't see any results in below Grids. Please let me know where did I go wrong.

Modeling

Discussion List