Modeling

Retrieve Users with Write Access from User List
We have built a dummy User List in system, selective access enabled, so user can set write access to those users. Is there anyway to directly retrieve the list of users who have write access? Attached pic to illustrate the purpose: User2 was given write access to User1 User3 and User2 itself, we'd like to get a list of…
Intermittent Anaplan Interface Error Message
Hello, Former Anaplan Support member here. I was just about to create a Support Ticket for this intermittent error message, I wanted to see if there were others who have run into this message before? 1) I am checking to see if other users are facing this issue. 2) This is not model or workspace specific. I have already…
Filtering text and numbers (NaN) in same module
Hi there, I have one module(saved view) which is the basis for an export to another system. This saved view consist of number and text (format), the export in the other system blocks when one of the number returns a NaN. Therefore we need to exclude these NaN. We thought we found a solution by creating a Line Item List…
Importing data with dates and multi-currencies
Hi please refer the following attached screenshots: 210325 Line Items 210325 Line Items (alternative view) 210325 Line Items (Data Import) 210325 Import with Failures 210325 Import with Failures Details Situation: To import data from a flat file comprising dates, names and billing rates in different (foreign) currencies…
TAR01 Detailed Sales Targets
Hi, I want to make sure I'm understanding the intended logic of the TAR01 Detailed Sales Targets module. From the user story it says, "I will know this is complete when I can see the percentage of the country’s actual sales revenue by product family that each account’s actual product sales contributed to per quarter." So…
lookup and error message
Hi Please advise on what this error means : lookup error - please see image attached - thank you IF Employed? THEN 'EMP03 Employee Drivers By Role'.Car Allowance[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 data type mismatch : format other than LIST or DATE being referenced as…
4.6.7
Every time to run my import it says that there are errors and my order for the source is column 1: Product Code, column 3: family code and column 1: product code and I know this is right because this is the same thing that other people have used and they got it right but when I run it it says that there is an error and the…
Trouble Finding a way to Convert Values from Half Year to Weekly Values
I am working through Level 2 Sprint 3 training and I am having trouble with creating a formula to convert data stored on a half year time scale to a weekly time scale. I would assume weekvalue('SOURCE Line Item') would be the correct function but I am not getting any values. I have changed the time summary method on the…
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?

Modeling

Discussion List