Modeling

Hi I wanted to know whether the below mentioned formulas are right for me to move forward with level 2. attaching the screenshot for the same. shippping time(week) :- YEARVALUE('DAT02 Shipping Metrics'.'Shipping Time (Weeks)') cost per 1000:- YEARVALUE('DAT02 Shipping Metrics'.'Cost per 1000 Units')

I put in the line items and formulas, but I am confused about the summary method to use. I already reviewed this resource and have referenced this.

A csv export of the Import Tab in the actions Menu would be great

I have 2 lists 'BU' and 'Projects' , where Projects is child of BU list. 1. 'Projects Module' is dimensioned by Projects List 2. Another Module 'Bu Module' is dimensioned by BU List The Amount Line Item in this module pulls data from 'Projects Module' summing it up by BU and quarter 3.Here I want to sum the data only if…

Blueprint Analysis Model Analysis techniques using Excel What? A model analysis technique using metadata from your Anaplan model imported in to Excel; utilizing purpose built formulas to identify line items of interest. Why? We do this so that we have some extra information to arm ourselves when trying to optimize a model.…

Hi I am stuck on the calculation for the car costs, phone costs and medical costs'. One should say the following formula would work for the car costs: But I am getting this error: Can anyone help please?

I have a 26 step process in my Model (Process A). I have created a new, 31 step, process (Process B) . I have just realized that I would like the user to always run Process A after they run Process B. Currently this now means editing Process B and individually adding all 26 steps that are in Process A. Request: Allow the…

Hi, I have a small query on Top Level (List). As per best practice, we should try to avoid Top Level for large list. Instead, we should use Lookup for the same I'm trying to use Lookup for a formula & its still asking for Top Level. When I update Top Level, the formula works perfectly (with Lookup). Is there any alternate…

HI, I am created the SYS employees modules setting in that i have line items Start date End date so my doubt is that can i use Formulas to that line items employee start date and end date what formulas can i use in that SYS employees module. please give me the example with it.so it will be helpful to improve myknowledge.

Dear Community I m a bit stucked with the INV03 formula for the Stock Exception My Formula : 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Distribution Center, SUM: 'SYS08 SKU Details'.Product] but i cannot see any amount popping up here and i have some amount in INV 01 Module Do you know…

Hi, I need some orientation on this: I need to look for a text in the column "P2 product Brand" (first photo) in another module (second photo) and if it is there, I need to return TRUE otherwise False this formula should populate the last column of the first photo. Both columns are formatted as lis, and they are populated…

I have a model with sensitive HR data, and I need people which should not have access to identifiers of individuals to be able to enter data. I have a list of employees, and I need, somehow, to build a dashboard which I can give other business areas access to, so they can enter forecast data. The problem is that they…

Hi I have got struck up with the activity attached the same, below is the formula which i have done. please correct me if i am wrong. IF NOT Submit Purchase Order Request? THEN 0 ELSE IF NOT Override Suggested Order Amount? THEN Suggested Order Amount for the Month ELSE Override Amount

Hi, I have to create a user experience page now. When creating a user experience page, I don't know whether I should select board or worksheet. I went for a worksheet and this came up: Now the instruction is this: Include the following: * Time, Account, and Product Family context selectors * Import Volume Growth Rates…

Hello All, I notice that the growth percentage is not being calculated in my model despite my being confident that the formulas are correct. Can anyone suggest why this may be happening?

I am going around in circles with this task. I finally got to a place where I know where the numbers are pulling from into Inv04 module. I need to calculate the beginning inventory by month and distribution center. The data source time dimensions (Inv01) is in weeks and the target in Months (Inv04). Initially, I was under…

I am the beginner so i would to know about the how many dimensions can be used in anaplan and please let me know in details or other market committers have using not more than 30 dimension.

Hello, I have a module which is NOT Time dimensioned. I have a line item named as "Year Filter" with Time scale as years and Boolean formatted, formulae with different conditions in the same module. When I apply the "Year Filter" in the saved view in the same module, I DONT see "Time: Current Period". It shows specific…

Hello all if I need to create and add code to already existing numbered list. What are actions to be taken. I understand list should be exported to excel and then create code and reimport to model but how to create code? What’s the best practice to ensure uniqueness. Thank you 

I am the beginner so confusing the roles of Model builder and responsibilities and he can participate in testing or testing team is different, i am not able to find those answers and i want to know the project team members available. there roles and responsibilities

Dear, I am building a supply chain planning system, which has different order types. Depending on the specific order type it has to hit only specific workcenters in a specific sequence with specific lead times. I have created a list with the different order combinations, e.g. "ProductA_Wood_Black" And also a list with the…

Hi, I am having a hard time trying to convert a numbered list into a text value. I have used the NAME() Function, but as a result I get the Number assigned to the list member. Instead I would like to get the text value of the Display name. The reason why I am trying to do it this way is because I need to Concatenate the…

In short the title explains the proposed improvement. When you have larger models or multiple MB working on a model, giving the ability to quickly find and sort makes finding other places that someone is using the module to complete significantly easier and quicker so you don't duplicate work, can reference other modules…

Hi everyone, We have our large production model, with 100s of modules that are currently feeding our P&L. This houses all of our actual, forecast, and budget data. The rest of the year we will be budgeting in this model for 2023 and 2024, but we want a "Long Term Model" (LTM) where we plan for 2025-2028. Ideally the LTM…

I am the beginner i want to know the information about user stories who will write user stories who will do testing on it and in the project how they implement the user stories

any suggestion on how to resole above error

Hi there, I would like to add a parent column for the list in my module. I want to create the following module which shows the list parent in the second column: At the moment I have the left and right side of the image as that part is a straightforward pivot: Page = volumes line item. Rows = Customer-SKU list, where…

I am stuck in G4T Territory>Account# list in Level 3 sprint 2. A2 Account>Product# list was similar to this one and we imported from data hub. It was clear for me. We assigned combined codes for the intersection cells in account-product matrix then imported it. In G4T Territory>Account# list is confusing. I couldn't figure…

Hi All I want to populate "text line item" which shows string between 1st and 2nd commas of the items in the module. How can i do it. which function should i use here Thank you & regards Yash

Anaplanners, Had a table that displayed different layers of the hierarchy. Layer 4 rolling up to layer 3, layer 3 rolling up to layer 2 and so on. If i as a user select layer 4 then only layer 4 needs to be displayed in the table. I know there is a native anaplan functionality where we can select the hierarchy but we…