-
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…
-
Write Access Driver also blocking Reading
Hi, I'm using an access driver for a Start Date: if a start date is past its modules time-dimensioned end date for that month it should be possible to edit, otherwise not. The boolean for this was created and looks good as it is checked/marked for all up-coming start dates and blank for past ones. But when I select it as…
-
reporting system between manager and employee by workflow
I want to make reporting system between manager and employee by workflow. For example, I want to manage bussiness case by project(A,B....). Person in charge predict the budget for project and input the budget(for employee) in table. After the employee(Smith) input the budget, Smith report it to Harry(manager) . After Harry…
-
SwitchOver on Model Explanation
Hi, I would like to know if I'm explaining and thinking about Switch Over correctly in the Model that I'm building. Please advice. My explanation: For my Version's Budget, Forecast, and Sandbox after September 2020, my Actual's will show for everything before that date, but after that date my new Version will show? Thank…
-
Apply conditional format on Top Level Item
Hi all, Can someone teach me how to apply the conditional format to only the Top Level Item? Picture below is showing that I am trying to highlight the lines that that not equal to 100%(I have a line item with the equation that if total All Station is =1 then 0 else 1). But I only want to apply the condition format to the…
-
Level 2 MB Sprint 2 DEM03 Growth Rate % Formula
Hi! I am working on the DEM03 Growth Rate % formula. I feel confident that the formula involves a lookup to SYS08 to find the Product Family, and I think the source is DEM02 Growth Rates by Week. Below is the formula I have tried, and it returns invalid. Does anyone have any hints on what I'm doing wrong? Thanks!
-
Anaplan Live!—Your Opinion Matters
We're getting ready for our next Anaplan Live! event. As active Community members and model builders, your input is extremely valuable. Our mission is to bring you content to boost your model-building skills, no matter what level you're at today. Take this brief survey, and let us know what you want to learn more about.
-
Restrict User Input in a Field to a certain range
Hi I want to get user input in a certain line item related to number format but want to restrict the user input between 0 and 100. If the value input is between 0 to 100 then this value must be used as it is. But if the user input is <0 or >100 then it should return an error or must convert the value directly to the limit.…
-
Line item - drop down list
Hi, For your assistance please. I want to add a "Description" in the column to identify the particular input item and will show as a dropdown list (description, example #1 - consumable item ). At first, I added in the line item but it should be in the column. Is this possible? Thank you.
-
Establish Relationship between two dimensions
Hi All, I am trying to figure out the mapping that can exists between two dimension that gets exported from the data base. One dimension is Profit Center and other Customer Code. These two columns appear as every time data is downloaded. How can i determine the relationship between both? Is it one to one Mapping or One to…
-
Job Aids During Discovery Phase?
Hi Everyone, Are there any documents/job aids that summarize the key questions to ask clients during the Discovery Phase? I'm referring to more specific questions than the broad overview in the Anaplan Way. For example, there are great posts here with questions you could ask a client when figuring out what dashboards they…
-
Level 1 Model Building - Lesson 9.2.5 (Add fomulas to price growth rates)
Good Day Attached I have tried adding the 'LOOKUP' formula to REV05 Price Growth Rates Staging Module. However it gives me the attached ERROR MESSAGE. I have checked the dimensions however the mapping doesn't match any dimension of the result. Can anyone please assist? thanks
-
Cannot Create Boolean based on LOOKUP for Write Access Driver
Hi, I'm trying to build a module with a line item boolean looking if a Manager is in a specific Cost Center to later work as a Write Access Driver if a Manager can do certain actions in relation to that Cost Center: Target Module: Module dimensions: Manager, Cost Center. Line Item: Is Manager in Cost Center? (Format:…
-
Day Of Week
Hello, I want to count the number of weekends between two dates. Do you have a solution for this demand ? Thanks a lot
-
Check Which Range a Value Falls in, and Return an Appropriate Value
Hello, For each list member in SYS78 (screenshot 1; "Rows") there is a corresponding Baseline value. I want to have the system compare the Baseline value for each list member to the Minimum and Maximum values in SYS77 (screenshot 2), and depending on which range it falls within I want to pull the appropriate Factor. So,…
-
Formula to count the unique values in a column
Hi In the attached screen shot of my dashboard,I want to count the number of unique values in the Item column and display the count value near the title 'Comp Reservation Details'.Any help for the formula/workaround is appreciated. Thanks Regards Prabakaran
-
Time and Calendars
Ok, I know I am going to open the flood gates here, but we are looking at the functionality of the whole time concept in Anaplan. I'm asking for help in capturing the challenges with the current concepts of time and the model calendar and specifically when we have to use a list to represent time Please could you reply with…
-
Level 1 Model Building - Lesson 8.6.4
Hi Community I have included the formula as requested into the formula line of Revenue however it's giving me the attached ERROR MESSAGE which I can't seem to rectify. Any assistance regarding this would be greatly appreciated. regards
-
2.3.11.2 Create DEM03 Saved View for Global Demand Assumptions UX Level 2 sprint 2
What am i doing wrong that only one line item is showing in my view after putting filter ? I have put the filter to view months only
-
Line Item Formula for Stock Expectations
Hi, I used the following formula and it says the dimensions do not match. 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM:'SYS07 Distribution Center Details'.Country] After that I used the the following formula to have the dimension of P2, and still not correct 'INV01 Inventory Ordering'.Safety Stock Exception…