-
Getting 4x the value of import in target module
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, Johan
-
How to make DCA line item go blank when FALSE
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 otherwise. Approve is a list-formatted line item with 2 list items (Approve, Reject) and DCA driven by the Submit line…
-
Accessing Data in other module
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 v21 52yk2v22v2262yk3v23 The formula for key2_value is IF key = "k2" THEN value ELSE BLANK Module B has name as rows and line…
-
Shipping time weeks data not showing
'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method] I have used the abovementioned formula for SHipping time weeks but no data is showing please guide what am i doing wrong
-
Level 1 model building exam - model building activity 2
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 module".
-
Level 2 Sprint 3 Module INV01 : Formula for Shipping Method
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 SYS08 SKU Details'.Supplied By ..pls guide
-
INV01 - Beginning Inventory off by 2
Hi all, I've been wracking my brain on INV01 and just when i think i have it, I notice that my numbers starting in Week 3 for beginning Inventory are off by 2. See screen shot attached from my module - in Week 3 FY 20 i'm showing 8,904 and in the example 3.3.5.3 Check Your Work it's showing 8,902. I'm also seeing my…
-
Monthvalue in Anapedia
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 boolean (which works) I was baffled by the Anapedia guidance that states it must result in a number. Is it a platform change…
-
How to post a Month from current year to previous year
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 Line item -entry is jan 19 , Result - Want to post jan 19 in Jan 19 (though I input in FY 20 as dimension) Post /lag works…
-
How to show only the last uploaded data from a module in a dashboard
Dear Community, Could anyone please help me to implement a requirement? We are getting a monthly file from various manf. locations that tells the available inventory bucket values for various product lots. Here is a sample of the file we are getting I am loading the file every month to a Data module dimensioned by…
-
Order / Sorting on a List
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://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Actions/Order-list.html This is a video of it in action…
-
INV01 - Final Shipping Time Weeks and Final Shipping Amount
Hi all, In 3.3.5.1 while creating the INV01 Inventory Ordering module, we are asked to create 13 line items, none of which are "Final Shipping Time Weeks" or "Final Shipping Amount". Maybe i missed something, but where is the instrux to create these two line items? Here is the screen shot from the training: I moved ahead…
-
show summary with Selective access enabled
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 to show the summary at B(at parent of C) , attached the screenshot for reference Please suggest if this approach is not…
-
Need help for the optimizer error
Hi Team, We are getting error while running the optimizer. Can you please guide whether the error is due to time or some constraints or some data issue? Please find attached the image for your reference.
-
Model couldnot be restored
Hi team, I have problem about restore data in production model, first i sync form dev to prod but after sync i want to restored data before i sync and i have pop up like this How to fix it? regards, Panji
-
HyperModels Group
Hi All We have created a group for all things HyperModels https://community.anaplan.com/t5/HyperModels/gh-p/HyperModels This is an open forum for you to ask questions, post experiences, migration paths, best practices, etc. David
-
Matrix Grid Help
Hi, I currently have 2 entity lists (identical), and a module which maps the entity 1 list to entity 2 list. What I'm trying to do is to create a matrix with entity 1 as rows, and entity 2 in the columns (i.e. an entity matrix). 1. How do I create a formula which states if Entity in row = Entity in the column, select…
-
Formula help
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 benchmark performance (see screenshot below). Products may track performance against more than one metric (e.g. Returns A and…
-
Mapping issue - only populate Manager that is from that Department
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: Departments (List-format with department which is populated based on a formula using the lookup function). Module Mapping:…
-
Parent to Child Lookup/Selection
Hoping someone can help me with this one. The target line items are Split 1, Split 2, and Split 3. The target module is named 'Sales Pursuits' and is dimensioned by a list named 'Pursuits.' The source line item is 'Split Rank'. The source module is named 'Pursuit Team Split' and is dimensioned by 'Team Members' which has…