-
Copy last entered cell value to all
Hi, I am facing a problem, can someone solve it, please. I have a module which has Employee, Time Range(FY01 to FY15) as Dimensions Line Item - IP(List format), Growth % (Number Format) IP Line item is user input, by selecting a list item from a dropdown. Growth % - Value(Name(IP)) - Will change to number format. Let's…
-
Previous function in a if then statement
Hey there, I am trying to figure out the calc logic where the user has the ability to input a percentage in which will then be applied/reduce to the number. However i need a logic statement where the reduction is applied from previous quarter to next quarter. For example i have 100 in Q1Fy19 and then will have 99 in Q2…
-
Fp&A case study access
Hi, I am not able to access 299 FP&A case study. Please provide the access for the same. Thanks Nitin
-
Switchover workaround
Hello! I have a question on best practice with regards to version and switchover date... My model uses 3 separate data sources for Salary, Income and Other Costs, which are stored in 3 separate modules. Initially, I built the model assuming that each of my 3 data sources will be actualised to the same time point. At the…
-
Level 1: Create Saved Views for EMP02 module
Hi, I have moved on to the save dashboards section. I am trying to create the EMP02: Forecast Periods. The instructions ask to filter by forecast months only. However, it is not clear to me how I can filter based on that when I create a filter. The only time options in filter are about start date. I tried to set that to be…
-
Regarding Successful and Unsuccessful login
If we have a SSO model . We want to gather the details of Successful and Unsuccessful login for last 6 months. Is there a
-
Level 1 SYSO8 Errors ( but not for date, salary, or commission)
Hi, I receive an error message after I import Employee details into SYSO8. I got the dates, salary, and commission to work. However, it says other fields have errors. I want to ensure that I have done things right before proceeding. It did not give me an option to match dep code, country code, and Active?. Am I missing…
-
Linking formula
Hi, Please see details on the attachment. Regards,
-
Level 1 model building #E2 List Upload
Hi, I cannot seem to fix my employee list import. I keep getting the same error. If I select code, it will not let me import and if I select #name it will fail. The steps in a previously answered question were not clear. I also notice in my import source that display name property is missing even though I have it in my…
-
Certification Level 01 / Level 02
Hi everyone, I've recently passed both Level 01 and Level 02 trainings (Previously, I had 101 and 201). I did it online, is it enough to justify the official Model Builder certification? I received the 2 diplomas. Also, I plan to get the official Solution Architect but I have no clue on how to obtain it. I've been told…
-
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…
-
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…
-
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
-
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
-
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…