-
blue toaster - on large models
Hi Team, As we work with larger and larger models - Data Hub and now Hyper Models the instances of blue toaster errors are becoming intolerable for most people. Even the slightest error can result in blue toaster for 10mins per time. It other forms of IT there is a distinction between verbose error handling and truncated…
-
Copy a Process
I am frequently encountering cases where i need to copy and existing Process then edit it slightly. Current example is a DEV model is being rolled out to many regions. I need to have a suite of Processes per Region as they are slightly different in the way they update from Data Hub. Right now i have to create a record of…
-
Working with Processes and Actions
Hi Team, Placing these here as a bulk request: 1. Would like edit/view contents of Action when I find it in a Process. Today I have to abandon the process then go find it from the Actions list. 2. Search Actions when building a process: When building a Process we have to scroll up and down the list of Action (which may not…
-
How to pick the value from specific version data without SELECT
Friends need your help !! I am trying to optimize the model with the help of cross-references so that can remove most of the formulas from the model (multiple modules will be optimized if successful). Source module with 2 months data April & May months data: Looking for below result in the Target module Note: No version;…
-
inputable table and calculated column in 1 module
Hi Community, I would like to ask some guidance and idea from you guys. I have an input module: Problem: How can I keep FY 19 FY20, FY21 and FY22 inputable while FY 23 to DY 26 will be calculated. Is that even possible in 1 module or do I need to publish 2 modules separately to achieve this? And also for the FY 23 onwards…
-
Month to Date Format
Spoiler (Highlight to read)I have monthly date as Jul 21, I want that to converted in last date of the month in 07/31/2021 format, is there a specific formula for the same?I have monthly date as Jul 21, I want that to converted in last date of the month in 07/31/2021 format, is there a specific formula for the same?
-
10.2.5 Activity: Add Employee Expenses Module
Hello, In this module, I see employee details as a code such as #3, dont see actual employee name. Where can I change it? Thanks in advance,
-
Circular Reference in Open Orders
Hi All, I am working on a stock rationalization logic where I have Orders as dimension and have to see how the SKUs will get distributed as per the requirements. Attached is a case representing the logic. For the first 3 days, the supply is pooled and then allocation happens for the SKU. However, for Day 4, the closing…
-
Formulas Creation.
Dear All, I just feel nervous when it comes to making formulas. I don't know how to get rid of this and be confident about making formulas. Can anyone please guide me how to create formulas easily and practice them successfully??? Hope someone may guide me!!! -Muizz.
-
Average of the previous 3 months data
Hello, I have a question, If i want to pull the average of the previous 3 months, how can i do it? Thanks
-
Formula Help
Hi, I'm trying to create a formula that will output the date based on a TRUE/Checked Boolean. We are looking to be able to bring in the date for the Line Item '10th of the Month' based off of the Boolean. Please advise on how to make this possible, Thank you
-
g1 list
please need help with this @Misbah
-
Add a hierarchy within existing list
Hi, My organization recently has gone through a re-org and as a result, our employee hierarchy has changed from 3 level (VP, director and manager) to 4 levels (CDO, VP, Director, manager). We used to have VP as the top parent for the list. I added another list and changed the new list as top level (parent) for the…
-
Export Actions in a Process
It would be useful to be able to export the Actions contained in a Process. Currently the only way to extract them is to highlight them all copy and paste into Excel. Add a column numbering 1 to x and then sort on the action name to get rid of the "Remove" labels and then re-sort back on the key to get the Actions in the…
-
Calendar Setup in anaplan
Hi Team, I am having trouble in Calendar Setup, I need a 4-5-4 Setup and my Current Fiscal Year is (FY21 :26 Sep 2020 - 24 Sep 2021). This Setup works fine for FY21 & FY23 as it's 52 Weeks but for FY22 as its a 53 Weeks calendar, Q4 of FY22 is 4-5-5 instead of 4-5-4 as regular setup, Is there a way to account for this.…
-
Level2 (Activity 1.3.10.3)
It seems I am missing the "s G3 Location: Distribution Center" column after I did my import. How do I get that included when importing?
-
unable to create a model in level 1
unable to create the new model in level 1,please provide the solution.
-
Level 1 Exam Activity 4
I believe I have uploaded the EMP02 Employee Expenses and EMP03 Employee Drivers by Role correctly but when I go to change the formulas in EMP02 Employee Expenses for Bonus etc. I receive an error. IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP:…
-
SELECT/LOOKUP formula
Hello, I need to write a formula to taka data from one module, but only for current month. I can not use LOOKUP function, because dimension doesn't match. e.g. When the formula includes selecting a specific month by SELECT: Month.October everything works, but I want to give the user the option to select the current month.…
-
Allow Pivot = New UX
Hi - I can't turn this setting on. What elements are affecting this?
-
Baseline Forecast in DEM03 Demand Forecast Module is 0 - Level 2 Model Building
I feel like my formula is correct but for some reason I am only seeing zeroes as values in the DEM03 Demand Forecast module. Is this an issue with the DATA03 Historic Volumes module? To my understanding, the values in Baseline Forecast should be the volume values from FY 19. Does anybody know where I am going wrong? Here…
-
How to restrict user to enter unique names in numbered list?
My requirement is to create numbered list and to restrict user to enter duplicate values for display name property. Please assist how can I achieve this functionality?
-
hide values in cell based on bolean check
hello guys, i have this module dimensionned by a list. The list is made from differents families and the row axis is made of many lines item and whenever an element is added by the user it insert itself on top of the its parent(family). so the parent is the total line of his elements, what i want to do is to be able to…
-
L1 Act 5 Error: Data type mismatch: format other than LIST or DATE being referenced as a relation
Update: Thanks to the community. I have completed and passed the Level 1 test. I think I entered the correct formula for editing the formula, but I am getting the error above. I think I get it that there is a mismatch in the format, but I am not sure where to look for it I also think that each data type I checked are all…
-
using lines sum in another formula
hi guys, i would like to know how i can do this in anaplan ( image). i have a module dimensionned by one list. the module is published in the new ux as a worksheet filled by the end users using a form to create a product line. some user will create an "others product" line. what i need to do is to create a line for each…
-
Division wrong output -- Results of division are multiplied by 4
Has anyone else encountered this problem? Tried using both DIVIDE(x, y) and x / y, results are always multiplied by 4. Odd Division Output
-
Missing data in forecast version of REP03 module
Please help. I am Missing data in the forecast version of the REP03 module and cannot figure this out. I feel like I've checked everything three times, and don't know why the data isn't populating.
-
Breaking apart SUM/LOOKUP
Hello all, My team is working on breaking apart a particularly complicated SUM/LOOKUP formula that was built 4 years ago. Looking for guidance anyone may have out there. Here's what the scenario is: - 5 SUMs & 2 LOOKUPs in same formula - 2 of the 5 SUMs & the 2 LOOKUPs are traditional SUM/LOOKUP combos (so the dimensions…
-
Difference between SUM function and LOOKUP function
Hello, I am struggling to figure out how to distinguish the usage between SUM function and LOOKUP function. Could anyone explain the meaning of the "list-formatted" such as list-formatted line item/property in the context below? (quoted from this page) SUM or LOOKUP? Determining whether to use SUM or LOOKUP depends on how…
-
Level 1 Model Building certification exam: help on formulas in Employee Expenses
For some reason I can't figure out the formula set up for questions 3 & 4 bonus and phone costs by role. I am wondering if my references are mismatched. Any help on this is appreciated as I feel like I am struggling by myself here and can't ask anyone or anything to help me out.