
Modeling
Modeling
Discussion List
- Hello. Can anybody help? I struggle with the Level 1 model building exam. "in the level 1 model , update the REV02 volume inputs module to include a formula to pull data from the DATA 02 SKU Volumes m…
- Just in case you'd missed it, the functionality for Ordering a List via an action was launched two weeks ago It has been a great success (used 2,300x since then) Details of the feature are here https:…
- Hi, I'm importing OPEX data from a datahub to a spoke model with the same dimensions but are getting 4x the values for every cell in the target module. Does anyone know why this might be? Best regards…
- In module 2 sprint 3 it says keep the reorder flag referencing to Suggested order amount. WHile my formula for reorder flag is OFFSET(Ending Inventory, Shipping Time Weeks, 0) < 0 I cant get it Pls cl…
- HI My final figures for Forecast Demand in Inventory ordering s not matching with the one shown in training module LEvel2 sprint 3 .Please find attached the screen shots training and mine.i know figur…
- Hi, I have 2 modules say A and B Module A has id, name, key, value, key2_value For example: id name key value key2_value 1 x k1 v1 row_numidnamekeyvaluekey2_value1 1 xk1 v11 21xk2v12v1231xk3v13 42yk1 …
- Hi, Module: I have created a module to submit and approve new employees. Line items of interest: Submit, Approve. Submit is boolean formatted and is TRUE when a person is submitted for approval, FALSE…
- Description: Unhide specific columns instead of the only available current feature of unhiding all columns just to see one or a few specific columns Example of enhancement: Currently, in any module, u…
- hello. is there anybody, who can help with the LEVEL 1 Model Building Exam? I do not know what formulas to write in the model building activity 6
- My figures in Inv 01 ordering is not matching with one given in training module I have attached both figures and formulas used please guide whta I am doing wrong
- HI I am using the above formula but getting an error. I understand I have to look into SYS07 Module(Distribution Center Details) for Default Shipping Line item looking up SYS08 SKU Details'.Code and S…
- Current Timescale Selection * Current UX: Selecting a year (e.g. FY20) in the page filter will will sync any worksheets to January - December. There's no native way to show something custom like the t…
- Hi I'm confused by the guidance in Anapedia on Monthvalue and Yearvalue functions whilst doing the Level 2 Model building. Having been advised to use these as part of the training to result in a boole…
- This one is simple. Anaplan's recommended export file type is CSV, yet the export dialog defaults to Excel / XLS. Yesterday we had an integration mysteriously run for 7 hours, later realizing it was b…
- Hi, I have a scenario where I have to post a line item which is month formatted from current year and post it in previous year . Module is by Year dimension . for example - I select FY 20 as dimension…
- Hi All, Can I show Summary when selective access is enabled at children level? there are lists in a hierarchy say A(PARENT) B(Children of A) C(Children of B) Selective access is enables at C but want …
- There are peculiar scenarios like mergers or acquisitions when the Master Data of the company changes. Name and/or Code gets changed in the source system, and we want to update the hierarchy with thes…
- Hi, I'm wondering how to only get the name of a person who is part of a department in a module that has department as one if the dimensions. SYSTEM Module for Users: Dimensions: Users Line Item: Depar…
- During a typical implementation, it’s common to have multiple model builders build use cases and accomplish tasks simultaneously. During this critical time in the project, it’s important to plan for a…
- HI Not sure what I am doing wrong in Activity 2.4.11 create role and test as end user. Did following steps 1.Create new role : Product Family Manager, 2.Assign Role > Modules like DEM01 Volume Growth …
- For those of you who have touched HC or resources planning might be able to relate to the example below. Composite hierarchy is very useful, however, in some cases it is significantly easier for end u…
- Hello all, I have a list of employees without alphabetical order in my model. On the dashboard, I can create a new employee in the list but I want the whole list to become ordered alphabetically when …
- With the introduction of the new Notificaiton capability in the New UX (which works great when tested), it would be great to expand it to include 'Anaplan Roles' instead of Specific People in the emai…
- Hi, I need some help with a formula/modelling. I have a module dimensioned by Products and returns (row) and measurement periods (columns) (1 yr, 3 yrs etc). My line items are actual performance and b…
- Hi all, I am trying to calculate the total of a Line Item to use in a formula (for example: totals are listed at top or bottom but I need to use this total amount in a formula). I have tried to use a …
- Hi all, I want to understand, can an Anaplan APP source pages from workspaces across data centers?