-
Sum values from all Versions
Hi, I am trying to sum the total value from one line item for all versions. The source module contains versions and the module containing the calculation does not have versions. The formula I used references the source module and line item and returns the value from the current version only. Is there a formula that can be…
-
Level 3 - Sprint 1 (4.6.5) - Lookup isn't working correctly
Hi, I'm a little stuck on Level 3 print 1 section 4.6.5. The formula I'm using looks correct but the lookup to accounts section isn't returning the correct values for me. 'Data_01_ FY19_Sales_Revenue'.Actuals[LOOKUP: 'SYS03 Account>Product Details'.'A1 Account', LOOKUP: 'SYS00 Time Settings'.PY Qtr] This is the formula I'm…
-
List properties in a Module
Hi All, I am working on a model where I have a list with 3 properties(B,C , D). List AProperty BProperty CProperty Duxyz In a module with Dimension as List A the below mentioned format is to be generated where in a column corresponding to the above mentioned list items all 3 properties can be brought: Module with Dimension…
-
Reference next item in a list
is there anyway to reference the next or previous item in a list by using a formula? I saw a post a while ago that inferred that this was not possible without quite a bit of conversion logic. thanks, josh
-
Sum data from a module with line items to another module with a matching list
Hi Could someone suggest a solution? screenshots attached also. I have a module (PER01) where I have these line items - the data is by employee (from employee list): - base salary - incentive scheme - other social costs I have another module (PER02), where I want the above data to fit in with only 1 line item called…
-
INV01 inventory ordering Foreast Demad line item.
Hi, In INV01 Inventory Ordering module I am getting the below value for forecast demand , where as in Training Material it is showing 2048. I have checked a couple of times of this value but not able to track the issue. Please let me know where I am going wrong here. Forecast demand value I am getting fromt this module…
-
Dimensionality
Hi, I would like to know what is the best approach for building when you have repeated Line Item's. How should you Dimension your Module? Attached is a screen shot of what I'm trying to replicate in Anaplan. Thank you
-
API Python Workspace and Model IDs
Hello, I have successfully setup my Python environment. I did have a question around a specific requirement. https://community.anaplan.com/t5/Best-Practices/Using-Python-3-with-the-Anaplan-API/ta-p/33150 From the above link, I have tried the “get models”, “get modelinfo”, and “getworkspaces” Python scripts. What I am…
-
Automated List Code creation logic based on Form inputs
I'd like the ability to allow users to fill out a Form in the new UX and create a code for the new item (automatically) based on the inputs - as well as flag the inputs as not possible if the item has been created before.
-
Level 2 Sprint 3 SYS01 line items
I am struggling with the beginning inventory formula. I feel confident with the later part of the formula but I don't see how I am going to rule out that it is the first week of the year. Should I add a line item to my module?
-
Applying Boolean formula from a time dimensioned to a non-time dimensioned model
Hiya, I have 2 modules: Meldaliste Sales - 2 flat lists, time System_Product_Filter - 2 flat lists The flat lists in both modules are the same. I need to create a boolean formula in System_Product_Filter that says if there is a blank cell in Meldaliste Sales then false else true. This formula isn't working because I have a…
-
Function similar to PREVIOUS for Line Item
Hi, Can we have an another function similar to PREVIOUS so that it can bring the value of previous line item. Example: There are two Lists and three line items (Op Bal, Exp and Cl Bal) in columns. Page Selector (List 1) : D1, D2 and D3 Row (List 2) : F1, F2, F3, F4 and F5 So when I go to D2, the Op Bal should equal to D1's…
-
Unsupported Media Type : POSTMAN
Hi, I am trying to upload a ".csv" file into Anaplan using Postman. Below is the API used. PUT https://api.anaplan.com/2/0/workspaces/((workspace_id}}/models/{{model_id}}/files/{{file_id}} But it is throwing an error of "Unsupported Media Type". Below images(also uploaded) are the configurations used. Can someone help me…
-
L3 Sprint 2 : '5.5.1 Data Hub Model' File not downloadable
Hello, I am section 5.5 in L3 Sprint 2, where we are asked to - "In the Data Hub model, create an Employee Details system module. Then, download the Employee Details data file and import into the Data Hub module. " The file link doesn't give me a downloadable file. Can that please be shared here? Thanks! Richa
-
DAT02 PY Revenue to CY module
Hi, I am having trouble with the formula in the DAT02 PY Revenue to CY module. Steps I have performed thus far: 1. Pulled from the Historical Data in the Data Hub into the DAT01 module in the Sales Planning model (dimensioned by A1 Accounts, P2 Products and F19 Time Range) 2. Created DAT02 module in the Sales Planning…
-
Highlight Duplicate rows including first one
Hi All, I have a requirement to highlight rows with duplicate line items in a Module. I have tried using the ISFIRSTOCCURRENCE along with conditional formatting but was only able to highlight the 2nd duplicate row. I am using Concatenation to check duplicates within a unique key of 4 line items. Would be great if someone…
-
Parent child list to ragged hierarchy
Hi, I am looking for a way to automatically create a ragged hierarchy for all possible combinations. The input is a simple file with only the parent - child combinations. I've attached a screenshot of the parent child combination and how the ragged hierarchy should look like. I think it is possible to do this when I…
-
Add Filters/Dropdowns in Modules Panel
Adding filters/dropdowns to the modules panel would be a simple solution to help model builders locate modules. Something similar to the excel functionality would be perfect. I believe this solution would be both easy to implement and substantial help to model builders. I very often export the modules panel to excel just…
-
Control Time Period drop down selections
Hi Anaplanner, I have a scenario where the time period(year) should be selected from the dropdown for a line item. The model calendar holds 9 years and a time range holds 3 years. I require the dropdown to show only the years included in the time range. Is there any way to setup a dependent dropdown and not by creating…
-
8.8.3 while setting up a time dimension in rep02 module
I am facing difficulty in setting up time (months ) dimensioni.e to include only months in time dimension in REP02 size margin report .can anybody who has done this help me out on this
-
Import from a module with multiple list members
Hi, I am trying to import from a source module applying to a scenario list, to a target module that is independent of this list. Can I select which scenario to import from? I know that if it is the opposite, i.e. importing from a module without the scenario list to a module with scenario list, it can be set as "ask which…
-
Stock Exception Count (Sprint 3, Level 2)
Am I supposed to get so many exceptions? I looked at the suggested template, which only shows 1 here and there. Mine has loads. The instruction was this: I've summed it - and given the stock runs out for every product, why wouldn't there be many?
-
Rolling Allocation Problem
Hello Gurus, We have an allocation problem. We have Shortages(Demand) and Supply by month. We have to allocate the oldest supply to the demand ie FIFO. Also, there is an expiry period for the supply, beyond which it cannot be allocated. The same is illustrated in this example, you may note there is a 1-many, many-1 and…
-
Retrieve Model ID and Workspace ID via API then load as CSV?
Hello All, I was wondering if it is possible to retrieve Workspace ID and Model IDs of any given Model which then can be pulled into a CSV file? Then imported into my current model? What I am looking for is something like this: 1) Retreive Current Model Details via API, extract into CSV. *Looking for ways to grab either:…
-
Summary Filter
Hi, Any tips as to hide HY/FY view UNLESS you have all 6/12 months - is this a simple formula in the time modules and then used in a filter? Would that be against best practice for having >1 filter for a column/row? Kiraikawaii
-
3/20 Platform Update - Any Ideas What Changed?
Hi team! I was hoping to see the image in a grid support and the row height adjustment for word wrap in a grid. Does anyone know what actually got implemented yesterday, and did these two make it into the upgrade?
-
Level 1 Model Building - Estimated Exam Time
Hi - I'm ready to take the Level 1 Model building exam. From the instructions it seems I should plan on completing in one session. I'm planning my week, how much time do you recommend setting aside to take the exam?
-
Select first week of the time scale by user
Hi, Current I have designed like this to select first week of the time scale. But I am wondering is there a way in ANAPLAN That If I select one check box for that Line ITEM, it will disable all other check boxes for that same Line ITEM and If I uncheck it , it will enable all other check boxes? Here I have maintained a…
-
2.3 DAT03 Historic Volumes
Hi, I have historic figures for volume in DAT03 for FY19 that have been offset to give me baseline forecast for FY20. How do I achieve the same for baseline forecast in FY21 as currently my baseline demand ends at Dec 2020. I also cannot seem to enter the ROUND formula correctly in DEM03 to get the Initial Demand Forecast?…
-
Mapping the products.csv file in level 1 training
Hi, I created a hierarchy of product family and products. I need help with mapping the products.csv file. Please find the screenshots attached.