-
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…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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
-
Unable to drill down: transaction module and line items must apply to a single list.
Dear Community, Does the drill down to transaction work only when then source has limited dimensions (e.g. one list, time, and line items)? My source contains: one list, time and line items. I was able to use drill down to transaction in my summary module. Then I added a dimension to my source module (a synthetic version…
-
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…
-
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…
-
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…
-
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…
-
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…
-
Filter line Item
So I have a module wherein there is 13 line items. 1 is a Text Line Item (text formatted) and the other 12 are Jan Feb.. Dec (12 months number formatted). I'm not using the native Anaplan time. I however want to filter the display of months based on the version selected (not native version). Say if it's Version 1+11 which…
-
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…
-
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
-
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?
-
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