-
App analysis
Hello Team, Recently I started analyzing on Sales forecasting app from app hub. I didn't understood the concept of vice president, Area Manager and District Manager. And also their target value is same in Quarterly Rep target module. Thanks & Regards Keerthi
-
Multiselect booleans - how the Hyperblock behaves?
Dear Community, I'm seeking for your assistance with the following topic. In the model I'm contributing to we do have a possiblity that allows turning off/on some features. It's done using simple boolean line item dimensioned by list of features (to keep it simple). Let's say it looks like that: FeatureBoolean…
-
Tracking historical data in a live model without making the model huge
Hi Community, I've built a model where end users input information and it calculates outputs. This tool will be completed by end users on a adhoc basis, some will use it weekly or monthly, while others will it once in a while. One of the outputs, shown below, is based on live information in the model: As we want to keep a…
-
Day time period format
We currently cannot have Daily as a Time Period format for a line item Use Case: Mapping from a fake daily timescale to Real time. Issue: Currently we have to use a date formatted line item and to map from a Fake Daily timescale in the format 1 Jan 2019 to a date requires a lot of text and string manipulation
-
Swtichover set to False driving Formula error
Hi team, I have a Line Item where the Formula Scope = All Versions & Use Switchover = True. When I turn the Switchover off I receive a 'Formula is invalid' error I have tried removing the formula, setting Switchover to False & return the formula by the same error ocurrs I cannot see why this error would be happening. My…
-
Territory Allocation Urgent
-
Certified Model Builder
Hello, I completed Anaplan Way Training and also both Level 1 and Level 2 Model Builder trainings. As Certified Model Builder is a step in Anaplan Training Path for Partners is there an additional certificate or badge for it? Regards, Jarek
-
Rounding function giving different result for similar numbers
I am using rounding function to convert 3 decimal places to 2, but the function is giving different results for similar numbers. Original NumberRound to 3Round to 2 P131.49496$31.495$31.50 P235.49528$35.495$35.49 This should be 35.50 Formula used for rounding to 3 - Round(n,3) Formula used for rounding to 2 -…
-
Limit on Importing using "Combination of Property"
#Gurus, I am aware that we should minimize the use of "Combination of property" and get a unique ID from the source itself. This case is an exception, where the client IT team has turned it off. Is there any limit on number of records that can be processed when we are importing using "Combination of property". Thanks Arun
-
New UI
Hi team, I cannot able to see Action Features in my NUX. but my colleagues have this feature. Could anyone please telll me whats the issue. Action Feature is not visible
-
Import current month data
I already have previous month data. Now I want to import only current month data. Please assist.
-
Transfer Employees
Hi, I was wondering how people handle transfers in their model. I saw a previous post that referred to a doc but I can't seem to find the doc. Any advice? Here is the previous post: https://community.anaplan.com/t5/Locked-Product-Requests-for/Transfer-Employee-Button/td-p/2821
-
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…