-
How to review model build
Hi Anaplaners! In our organization we review models built by junior and middle analysts. Checking every formula and finding inaccuracies takes a lot of time and energy. Could you share the way you deal with this? Thanks, Kostya
-
Changing parent in numbered list
In this numbered list if we select Parent from the drop-down list the department(parent) of the selected employee will change and will be reflected in all the module that has referenced this List. How can I make an action to publish it on the dashboard where the user can change departments for the employee, should I create…
-
Level 1 Activity 6
How close am i here??? The formula for 'REP04 Employee Expense Summary'.Salary is invalid: Salary = IF Employeed? LOOKUP :'SYS08 Employee Details'.Current Salary[LOOKUP: 'SYS08 Employee Details'.Role LOOKUP: 'SYS08 Employee Details'.Region] ELSE 0
-
New Level within Hierachy
I have an established hierarchy and need to add a new level within the middle of it. Currently, the hierarchy looks like M1>M2>M3. I will be adding a new level between M1 and M2. The current M2 and M3 will be children of the new M2. My concern is around the formulas already associated with the levels in their current…
-
Adding a top level hierarchy list within existing hierarchy
Hello, In our current model, we have an existing hierarchy with let's call A and its child B. We want to add a new hierarchy list as X, and X will be the parent of A. As far as I know, adding a top hierarchy list should not cause any issues for the current modules with list A and list B dimensions and shouldn't ruin any…
-
Error when Exporting Text formatted Number: Missing Leading zero
I have a text formatted line item called Company Code = "0505" When I export the module, I noticed that the Company Code becomes 505 instead of 0505. Why was the leading zero removed when I exported it? To solve it I created another line item thats number formatted and called it New Company code = VALUE(Company Code) The…
-
Formula - not pulling anticipated results
Currently attempting to pull data from a calculation model that created into a separate module that we use to export data - essentially referencing using an export code and a currency conversion selector - which using the latter, should only pull one of the values , either "Constant" or "Latest" through, however it seems…
-
Certified Model Builder - Certificate
Hi, I completed Level 1, Level 2, and The Anaplan Way. How can I get the certificate "Certified Model Builder"? I found this article, but the link in the article does not seem to work - Certified Model Builder Certificate Thanks!
-
Level 2 Sprint 1, Create a filter to show only half-years. (Hint: Use a system module)
Can anyone offer guidance as to how to create the filter to show only the half year view? (for 1.6.3.3 Create Saved View for Export.) I have this now: So in order to hide the FY20 and FY21 columns to meet the requirement, the hint is to filter using a system module. So i tried this: But this resulted in hiding all the…
-
Using Bulk Copy for Custom Versions list(Production List)
Hi Community Members, We are using the custom versions list in our model and looking to utilize the Bulk Copy functionality. Since a human will not have workspace admin in production, we were looking to create a Bulk Copy Action but it only works on the non-production list. Does anyone else have an alternative solution?
-
Scenario planning across multiple models
We have 3 to 4 different models that feed from/to each other where we need to perform connected scenario planning across all models. For those who have had to develop this functionality. I wanted to check how you've implemented it, pros and cons of what you did and if you could do it again if there was anything you would…
-
User wants to change the employee's department.
Hi, There are lists (Department and Employee where the Department is the parent of Employee). I want to make a UX page where the user can select the employee and change his department, therefore details of the employee such as salary will reflect in the new department. Please let me know how I can achieve this. Thanks in…
-
Incremental Load
How to do incremental load when there is change in any one of the list properties?
-
Import Data Sources / Imports
When in the actions area, there are a couple of different tabs and I've performed some changes previously in terms of updating source models, etc when we have archived old ones, however I would appreciate guidance when looking between Import data sources and Import tabs - I've added elements to Import Data Sources, how do…
-
Avoiding Circular Reference
I have a list of Manufacturing Plants. The output material of one plant becomes the input for the next plant. The cost at which a material is transferred from one plant to the other is the weighted average of opening stock cost, production cost and cost of materials transferred from other plants. Since the cost of one…
-
native time and snapshot period
I have two different modules. Source is dimensioned by Study top level & using snapshot time (only previous month will populate at the end of every month). My target module has native time with a subset of active Study. I want to get the data in my target, if any study has a value in my source that should populate in my…
-
Level 2 Data Hub Historic Volume Importing Data Error
I need some help with these columns mapping can anyone guide me is this correct or not cause it's giving me An error ?? screenshots attached.
-
Different Numbers after selecting different version
Hi All, I have a module with native versions that has different forecast versions for scenario planning, one issue that I have is that when I select a different forecast version it shows different output than the others. What might be the reason for this and is there any workaround to fix it? The output is expected to be…
-
3.3.5.3 Check Your Work - I don´t understand were I´m wrong.
I have done all formulas and checked my work against the course examples and everything was good until I review the Nutzo Bar_En selecting the Submit Purchase Order Request? I get the following: The example given in the course says that the confirmed Purchase Order Receipt for Jan20 should be 8,194 but I get 8,396 (same as…
-
help
In REP03 Profit and Loss Report module some of line items showing correct results but some are incorrect like headcount and car cost please help to figure the issue .
-
Options for Override
Hi I have a module of manually entered data that needs to be reviewed and adjusted by an end user. The values often need to be overridden and there is a high possibility of the overridden value being zero. Also the overridden data will often be copied and re-used within the module across different dimensions What options…
-
How to rank values of a list item across Time
I have module with List A and Time Dimension(Months) Line Item - Value I want to rank Values to display only top 3 contributing across time period for each list item. In the screenshot below I want to display only Apr 20, May 20 and Feb 20 for Item 1.
-
Calculation based on the cell value
-
Certified Anaplan Model Builder Course
Hello please provide me the Link for Certified Anaplan Model Builder Corse
-
SYS02 Region Details
I am stuck in 6.8.1 I can not see region details, my model is not same the screenshot, please guide. Thanks,
-
Need help connecting text values between two modules
I have two modules with a common text formatted line item Employee ID. The modules are DATA03 and ADM07. In ADM07 there is a corresponding text line item called C4 Code. I want to bring the C4 Code value into DATA03 into the C4 Connect line item based on where the Employee ID line item matches between the two modules. What…
-
Remove the circular reference
Hi Anaplaners, Is there any way to remove the circular reference from the below scenario? Line item A = Previous(D) Line item B = Input Line item C = Input Line item D = A+B+C
-
Calculation Cell value based on the other
-
Regarding YTD
My current period is set to May 23. I am calculating YTD by taking it in time dimension, but it is calculating YTD by taking values upto May 23 and I want to calculate by taking values upto April 23. How should I do it ?
-
UX Page ability question
Hello, I am trying to figure out below two things for UX pages Is it possible to add status of a running import job on the page. I have user action button that starts a cloudworks integration job. Anyway to show status of the job like its running or is complete? Also I notice that once the import is finished, the data on…