-
11.3.2 Activity: Import Data into P&L Actual and Budget
In 11.3.2 Activity: Import Data into P&L Actual and Budget I cannot import any data to the Budget version as it seems like only Forecast and Actuals version exist in the new model I have created. However I cannot tell why the budget version is not there? My systems module for version looks like this: And versions is set to…
-
Level 3 Model Building Sprint 2 Territory Data
Hello, Many of you have probably finished the Level 3 Model Building Certification. As I start Level 3, Sprint 2, I got confused with the below instruction: My questions/clarifications: 1. In Sprint 1, the Level 3 Model is connecting with the Data Hub, and there was an option to download a New Data Hub or Use the Data Hub…
-
Why is my RANK function changing result when I perform Bulk Copy Action?
Hello, In short, when I perform a Bulk Copy, my RANK function is changing and giving different result than what it should be. Detail: I have a raw data source import file that is a listing containing all of our retail locations and their respective royalty rate that they pay us. The majority of the locations have one…
-
Level 1 Model Building - Learner SurveyQuestionnaire
how can i find Level 1 Model Building - Learner SurveyQuestionnaire as i have completed my level 1 exam as my exam status is still not updated
-
Export Subset information
Hi, Is it possible to export details of all the subsets as is possible with the general lists table? Chris
-
Limit on adding cards in Anaplan APPs
Hi Team, Good day! I just would like to check if it's possible to add up to 10 consecutive cards in Apps horizontally as currently, it only allow 6 cards. Any response will be greatly appreciated. Thank you! Rachelle
-
Blank sections in Start Date and Time (UTC)
Why are there blank sections in the Start Date and Time (UTC) column in the actions tab and actions settings? Surely the first time the action was run would log a date and time stamp? If not, then what is the cut off period when this becomes blank? Chris Heathcote www.HeathcoteAndHerran.com
-
How does using a module as a filter works?
Lets see if i can explain my self, I am giving support to a Model which in the UX of the app has filters on top that come from a filter module, they requested me to add a new filter to filter by rep and there is already like 3 filters with that description, but when I add them to the card they don´t work. Filter Module:…
-
Level 1 Lesson 11.3.4 Activity: Add Formulas to Profit and Loss Report Module
Hi I have a problem in fixing the formulas for the above lesson. I have attached the screen shots for the first formula I was supposed to create which is for Headcount. REP03 Profit & Loss Headcount FormulaError message displayed for the formula Further, I would like to know whether the formula repeats itself for all the…
-
Conditional Formatting on "No Data" Format Line Item
Hi all, can conditional formatting be added to a line item formatted as No Data. If possible, please kindly explain. Regards
-
Automatically sum line items of a module
Is there a way to sum all the line items in a module? Let's say I have 20 line items in a module at the moment and I want to sum it all up in the 21st line item. (1) Is selecting 20 line items one by one to get the total the only way? (2) Is there a way to ensure that if a new line item is added somewhere between 1st and…
-
Anaplan Way Certification
Hi All, I want to enroll for Anaplan Way certification but it is showing to enroll in classroom classes. Kindly guide me on this how to enroll for Anaplan way. It would be helpful. @Misbah Thanks , Ayush Srivastava
-
level 1 exam activity 5
added all the formulas for bonus ,car allowances,medical...but adding all car cost, medical are showing zeros
-
How to look up first instance of a numbered list
I have a module (Module A) that applies to a list. Job Title Salary Bob John Katie I have a different module (Module B) that uses a numbered list. The display names of the numbered list matches the names in the regular list. How do I look up the first instance of the "Job Title" in Module B so Module A shows Bob's Job…
-
Allocating 53rd week to previous 4 weeks of the same year?
I have a scenario where in a module I am getting 53 weeks of data but the client does not want the 53rd week to show instead client wants that the data for the 53rd week should be distributed to the previous 4 weeks. Could you guys please explain how can I achieve this. Thanks a lot in advance. @Misbah any inputs on this.
-
Error message L1 model building - 6 Module 6.6.5
The formula for 'SYS01 Time Settings by Year'.Forecast Year? is invalid: Forecast Year? = 'SYS00 Time Settings'.Forecast Period? 'SYS00 Time Settings'.Forecast Period? is not a recognized line item or list member I received this error message when I try to enter formula to the line item Forecast Year And I am also not sure…
-
Sprint 3 Beginning Inventory Formula not working, getting an error
HELP! I'm currently doing Sprint 3 and I'm getting error with my Beginning Inventory formula. IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory I'm getting the error below. What can I do to fix this? Is my formula incorrect?
-
BREAKBACK - Is it possible to release one cell that have just been hold
Hello Anaplan, Using breakback we can hold cell by cell to keep an amount. We can then "release all" hold cells of the grid. But is there a way to release only one cell ? Exemple : Hold cell 1 Hold cell 2 Finally release cell 1 only
-
How can I maintain past data when changing formulas?
Hello, Anaplanners. I hope this message finds you well. I wanted to discuss a challenge I'm facing while working on an activity-based costing model in Anaplan for my end-of-study internship project. Unfortunately, my professor has expressed doubts about using Anaplan for this purpose. The main concern raised by my…
-
Synchronized selection issue
Hi Anaplanners, So I have a Region List (R1) and project list (R2) rolling up to these Regions. Within R1, we identify special regions using a boolean line item in a separate module. I have a NUX page where all the attributes of only the 'special regions' that is R1 filtered with the above line item, dsiplayed for the end…
-
Sum function not working correctly
Hi, I have a data module with Dimension E3-Emp. This data module has following dimensions as List type Line items (Site, Tier, Rate, Tenure) When I try to create a module to group Emp HC by Site, Tier, Rate, Tenure and E1-Emp Class ( Super Parent for Emp). The result doenst look good. My formula 'DATA01 EMP Roster'.HC[SUM:…
-
Find occurrences of a Dimension code without hierarchy
Hello all, I'm stuck on something. I have a Job dimension that has Job code and Job name. (100 - Tech I) That Job flat list is not in a hierarchy. But I've created another list called JobL5 that has the Department as a Parent. Each dept will have several jobs listed underneath. And the same job can be in several depts. I…
-
How to avoid counting multiple times when summarizing
Hello everyone ! I came to ask a question here with a case i'm sttrugling with, i hope i will be clear enough with my explanation, don't hesistate to tell me if it is not clear. To contextualize a bit : i'm working basically with two hierarchical lists that goes from : GP0 Zone, GP1 Region, GP2 Country, GP3 Store P1…
-
DCA Logic on selection line item
Hi Anaplanners, I have a module where I want to apply DCA on "a" line item. The logic should be that if no region is checked, all regions should have write access, but if any region is checked, only that selected region should have write access, and the other regions should only have read access. The "Region" list used in…
-
target with more dimension than source
Hi I have source module by GEO and ORG, However, I have target module by GEO and Time dimension. In the source module there is a mapping between GEO and ORG, So the line item is list formatted. How do I get the mapping to the target module. For example, if GEO 1 is mapped to ORG 1, I should get that in the target…
-
Level 3 Sprint 4.5 Finalize Assignments Action Button
In the screen shot for 4.5, there is an action button for "Finalize Assignments". I have read through the user stories and the in the build steps and I cannot find any reference to this. What does this action do?
-
How to Count the recurring combinations of List Members
I want to Count the recurring combinations of Time, Employee, Project and Fund but the issue is that the List is too big to use Sum function, I need some other means as I cannot even create a TRID for it due to lot of List Members and also I am unable to create a Staging Module or anything like that to do the task. I want…
-
Entity or Country First
Hello, We're considering launching into a new country, how would be best to structure this in the organisational hierarchy? Country first, then entities; or entities, then countries. For reference both entities will be trading in both countries. e.g. Total Company > UK, Germany > Entity 1 - UK, Entity 2 - UK, Entity 1 -…
-
How do we take the Current User and apply a filter on a view?
We have created a module SYS11: Current User with dimension Users. Per the instructions found we set in Blueprint Users List = Show all users:Off Now we want to take that user and apply a filter to Sales Detail on UX page to show only the transactions related to that logged in user. We are struggling to figure out how to…
-
SYS00 Time Settings'.Forecast Period? is not a recognized line item or list member
Hi team am receiving an error