Modeling

'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.
Make the round function work as intended
Description of the enhancement required: The ROUND Function is not working as expected. An example of the enhancement: Make the ROUND Function work as intended. A story for why they want the enhancement, (how would it help their business process): It has been documented on Community…
New UI
Hi Team, I am currently working on new UI, developing one the Dashboards. I didn't find any Action Buttons for uploading data or to run a Process while creating Board for my already existing Dashboard in older UI.
LEVEL 1 MODEL BUILDING : PART 12 DASHBOARDS
I am on Part 12 Activities : Create Saved Views. On Create Saved Views for REP02 module, I was trying to make a new view for REP02: Chart DB just as guide shown below. Saved View Name: REP02: Chart DB Filter: n/a Pages: G2 Country, Line Items Columns: Time Rows: n/a I am having a problem with item 'Size'. If I go to…
Automatically re-open modules after a session timed out
Hello All, As a new model builder I have experienced some frustration with tracing back where I was at if my session times out. This is especially true during the development stages and the solution is moving fairly dynamically and several developers are working on it. It would be a nice improvement if Anaplan could cache…
Logging in to the last state where you last left the Model / App modules dashboards selections
Hi Anaplan, As a model builder or end user its is quite a common instance that you are on the Anaplan platform and then you have to leave what you are doing to attend something else. In the current state, Anaplan in most cases will log you out of the platform or close your session because of the time out procedure. I…
Default Settings for new Line Items, Summaries, for Model and Modules
There are two other ideas that exist already one that are by default set sums to off and another that is to set defaults by module. Why limit to just as a whole product or module, why not give a default for builders or similar added to the Model Setting. All models are set to default none for all summaries and line item…

Modeling

Discussion List