-
Dynamic Cell Access (DCA) with subset
Hi Guys, I am trying to create a DCA access control module and noticed something . Wondering if someone can shed some light on this So i have a list and the list has a subset eg below I have 3 modules -First one "lets call it module" has above list as "Applies to" with 1 line item "Read" as Boolean and Formula as "True" .…
-
Day Count Convention (YEARFRAC)
Hi, has anyone found an alternative to Excel's YEARFRAC-Formula? The formula has various day count conventions such as Actual/Actual, US 30/360, Actual/360, etc. I am trying to get the year fraction for different time periods but it's quite complicated in Anaplan. Best, Evgenij
-
Re-ordering list item subsets in the list setting section
Hi Anaplan community, I believe I have just encountered an Anaplan bug but wanted to share if anyone has experience the same issue and whether it is a known bug. When creating a list item subset I have attempted to change the order of the list item subsets but even after changing the order and returning apply the list item…
-
Mapping Data Based on Combination of Codes/Number
Hi All, I would like to hear your idea or case regarding the topic. What needs to be build is to map the code based on combination of codes/number (please refer to the attached image that describe mapping logic table). I can create such logic but too much complicated to maintain(Use tons of IF, LEFT, and such). The table…
-
Difference between Top Level Item, Parent Hierarchy
Hi, I would like to know the difference between top level item and parent hierarchy. Is the top level item necessary when there is parent hierarchy?. Also, when would one use Parent in the list without having Parent Hierarchy and/or top level item? Would appreciate some clear egs. Thank you, Cheng Hong
-
Count with time dimension
Hi, I would like to ask something with regards to count with time dimension. The details are in the attachment. My apologies, i had to recreate the file since I was informed that I cannot post actual screenshot of data from client. Please see attachment for details. Regards,
-
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…