Model Contributors set the foundation for success.
You go by many names—from New Model Builder to Junior Model Builder to QA Support Analyst—but your mission is the same. In your role, you act as the Anaplan point of contact for your end users.
On this page, you’ll find resources to support you in your daily activities, and beyond. Whether you’re supporting user access or activities like data imports and troubleshooting, we’ve got your back! Pick your path and find what you’re looking for in one, consolidated space.
Hi, I have a module with a time range as a dimension. I've set it with a daily time scale, but Anaplan's way of showing daily dates is for example "1 Jan 37" and I need it to be in numbers because when I export it excel doesn't recognize it as the date format that I've set in Windows (OS) (when a date as two digits it's…
I can't seem to get my module to match what the learning center is showing. Any idea what I could be missing in dimensionality etc.? I've looked back through the previous lesson and can't find any clues. Learning center shows: And mine looks like this: What am I missing in the setup below? I made several back-to-back and…
Hi All, I have poked around through the forum looking for an answer on this issue, and most of the threads end with no solution. I have had no problems mapping the other stuff so far, no idea what is going on here. Yes I am mapping by code, instead of Employee name. Yes I have edited the start and end date, tried yyyymmdd…
Hi All, I want to address an query related to exports, In Output model, which is read access for all users & roles.user want to have dynamic export depending on user selection of multiple regions. So for selected regions , they will be able to see the data only for selected regions. Thanks,
Kindly assist me to load data into the model.
Author: Chris Stauffer is the Director, Platform Adoption Specialists at Anaplan. My kids and I enjoy code-breaking games, and so I wondered if I could build one in Anaplan. Over the years, there have been many versions of code breaker games: Cows & Bulls, Mastermind, etc. The object of this two-player game is to solve your opponent’s code in fewer turns than it takes your opponent to solve your code. A code maker sets the code and a code breaker tries to determine the code based on responses from the code maker. I came up with a basic working version last year during an Anaplan fun build challenge. Here's a short demo: https://play.vidyard.com/4rWNr9rRHuPtyhKNokW3Ah If you would like to build it yourself, the instructions on how the game works and how to build it are below. Game start: Code maker input Player 1 code maker starts the game by going to the code maker page and choosing a secret four color code sequence using a grid drop down list. Code makers can use any combination of colors, including using two or more of the same color. You could set up model role and restricting access to this page using page settings to ensure the codebreaker cannot see this page. Player 2 code breaker input The code breaker chooses four colors in the first row attempting to duplicate the exact colors and positions of the secret code. The code breaker simply clicks the first row in the grid, uses a list drop down to make color guesses and then clicks the Submit? button. A data write action writes a true boolean into the code breaker module to turn on the module logic checking, turns on DCA to lock the row submission, and provides an automatic calculated code maker response. Unlike the real board game, the code maker does not have to think about the response nor drop those tiny black and white pins into the tiny holes in the board — the calc module does the work automatically and correctly every time! I’ve been guilty of not providing the correct response to a code breaker attempt which can upset the game and the code breaker. First guess Below the code breaker selected blue-red-yellow-blue and clicked the Submit button. Since two guesses are the right colors AND in the right column position, the calculated response is “Black Black”, telling the code breaker that two guesses are in the correct position and are the correct color. A black color indicates a codebreaker has positioned the correct color in the correct position. A white color indicates a codebreaker has positioned the correct color in an incorrect position. No response indicates a color was not used in the code. Second guess In the second row, the code breaker input green in Spot 1, but kept red-yellow-blue and now only has one color in the correct position (yellow spot 3), but gained insight that there are now three correct colors with two in the wrong position thus the black-white-white response. Third guess The code breaker selected blue-yellow-green-yellow and now has all the correct colors with only two out of position. Fourth guess You have to be a little lucky to break the code on the fourth guess, but hopefully by now you get the idea of how the game works in Anaplan. The winner of the game is the player that solves the code in fewer guesses than the other player, so each player takes a turn as code maker and code breaker. Conclusion The model uses a lot of conditional formulas, text functions (&, MID, ISBLANK, FIND), and custom matching logic, to identify right color and wrong position matches (white) and right color right position matches (black). A very simple couple of UX pages makes it easy to allow for two player game. You’ll have to create the model roles for code breaker and code maker and set up the page security settings. Attached is the line item export in case you are curious or want to build it yourself. There are probably multiple ways to build the logic or make the formulas more elegant, but it was for me a fun diversion. Code Breaker Game - Line Items.xlsx Enjoy!
Dear Hive Mind, Do we have a way to get the history of a particular List Item, from its creation into a model up until its removal ? I am trying to chase when / how an item has been added into a model and how / when it would have been deleted and then recreated with the same code. Is there a pattern (manual or API) to get this ?
Description of the enhancement: Currently using the TEXT function it will convert the underlying number. For example, if you have: Line Item 1: Number format, set it to 5 decimals - value: 0.0000005 Line Item 2: Text format, Formula: TEXT(Line Item 1) Result: 5-E07 Desired Result (in TEXT FORMAT): 0.0000005
Hi, I have a module with a time range as a dimension. I've set it with a daily time scale, but Anaplan's way of showing daily dates is for example "1 Jan 37" and I need it to be in numbers because when I export it excel doesn't recognize it as the date format that I've set in Windows (OS) (when a date as two digits it's 2000-onwards), so because it is a text, it doesn't consider that region setting from either excel or windows, and it translates it into 1/1/1937 which is wrong. I did include a line item to show the date but it's not a solution to my problem, and it actually doesn't align with the way the model or the specific module is set up, as I want the dimension to have MMDDYYYY format (or whatever date format but with YYYY) and do not want an additional line item. If anyone has a solution to this problem, that'd be really helpful Thanks
I try a movingsum function but i get always the next message This is the function that i try And the location that i try to aggregate Why do i get this message the module has a day scale?
Model Contributor training
Model Contributors should have completed Level 1 Model Building training in the Anaplan Academy and be familiar with the concepts and applications of this course. Additionally, below are some relevant micro-lessons that Model Contributors may find valuable as a refresher for typical activities.
It looks like you're new here. Sign in or register to get started.
