-
LVL2 CONCLUSION Export of Beginning Inventory
I have a question regarding Export of "Beginning Inventory". It all look ok and I can do the export to csv-file with correct columns, rows and data. However, since as I understand it the export shall include P3 SKU code, and instructions tells me that we dont need to create a "Code" line-item, so if that is the case how…
-
Workflow and Dynamic Cell Access
Hi, I would like to set up process control for forecast planning. For example, after operating unit users submit operating units' report, they can not edit any more. Then division users review and edit the operating units' report and then submit total divisions' report. And division users and group users can see the…
-
Forecast an amount every 'x' periods
Hi, I need to take a committed contract amount and forecast it going forward as if the contracts will be renewed for exactly the same amount once the contract expires. Contracts can be month to month, quarterly, annual, or bi-annual. The image below shows a mock-up of committed contracts in green text and how I would need…
-
Active Version
Hello Community!! I have created a Custom Version list (v1, v2 and v3). I have a module with Accounts list and Versions list applied and a Active boolean line item which have few Accounts as true in V1 and few other Accounts as true in V2 and like vise for v3. We have another line item which is All Active which should show…
-
Map list items for importing to a module
Hi, I am mapping the list when I import into a module from a saved view in another model. As shown below, the source list (left) contains an item "Distribution" that actually does not exist in the list, while "Distribution total" (that exists in the source list) cannot be mapped to any target items. I made some changes…
-
Catering for Jagged Hierarchies
Just ramping up on lists and from my previous experience many clients have jagged hierarchies (i.e. there is not a consistent level of parent-child relationships). Just looking at composite lists these require the hierarchy to have a consistent level. How would jagged hierarchies be catered for?
-
Dependent dropdown using flat list
Hi, Is it possible to do dependent dropdown using 2 flat list. Eg. I have one flat list for levels (l1 to l5) and one flat list of exhaustive list items of l1 to l5. Now I want to do dependent drop down based on the first flat list which is levels list that if I select L1 then I am able to see L1 items in the drop down.…
-
Production List Node selection
Hi All, I have 2 Module, One used Level 1 hierarchy(as dimension) and 2nd one uses (L2 hierarchy as dimension). In second Module Line item, I want to pick value from Module 1 line item but from a specific member. As my Lists are Production enabled , I can't use select function or Item() in this case. Is there a way to…
-
Level 2 Sprint 3: INV01 Module Line Item Formula Details
Dear all, on this section is required for those line items: Confirmed PO Delivery line item Confirmed Purchase Order Receipt line item to use the formula OFFSET, but I am not able to manage the proper result using that formula but I was using the formula POST and please refer to the print screen The tips on the training is…
-
Copy Down/Across
Currently I have transactions which run in Lakhs. I am trying to bring in a comment again every transaction by copying down but Anaplan has a limitation saying that only 10000 rows can be copied at a single time. Even I tried the conventional method Ctrl+C and Ctrl+V but still its the same issue. Is there any workaround…
-
Line Item Filter based on Page slector
Hi All, Can I filter my line items on a module based on my dimension page selector. Say on Total Org Level I want to view different line item and when below levels are selected I want to see different line items. Thanks Madhu
-
Products with different Unit of Measure
Hi How to create products with different unit of measure(UOM) and any feasibility to take UOM Conversion, is there any workaround for UOM conversion. Thanks Sri Nitya
-
Cross referencing List values in module through Lookup?
Hello, I have list C_L4 costing materials containing material under multiple org- profit centers Ex: Material: 136699 Profit Center: 100050: Sales Org: 2020- C_L4 Code: 136699_100050_2020 Material: 136699 Profit Center: 200050: Sales Org: 3030- C_L4 Code: 136699_200050_3030. (Cost attributes are being calculated from…
-
How to show line item data with time in columns parallel?
Hi, Just wanted to check, can we show line item data with time in Columns in parallel?(apart from using total all periods) Attached screen for detailed understanding Thanks, Dileepkumar B
-
Tooltip for Cells
Hi Team, Is there anyway to create Tooltips for individual cells? I know you can create them for a module but I require more detail @Hayk I saw that you requested this in the Idea Exchange & also you mentioned a workaround involving involving a formula which displays in the drill down window....any chance you could explain…
-
Issue in fetching data from one module to another
Hey Everyone, I am facing a problem while taking datas from one module to another module. I have to Fetch data from detailed level to aggregated level. My Source File is containing more detailed data and my Target module is supposed to have the aggregated data from source. As my target and source file is containing almost…
-
List Item Limit Reached
Hi everyone. Sorry to drag this topic back up to the top but I encountered a rather strange issue today. My standard list hit 1B list item record limit even though there's only 12 million list items. So I checked all my standard lists and saw that the record limit is growing on all of them after each import. Did I…
-
Minimum value through out a 12w period of time
Hi! Hope that you all are doing fine with this crisis! I have a line item that, for each reference, calculates the balance between need and stock for each week. I would like to create another line item, without the time dimension, that gives me the worst situation in the next 12 wks for each reference and (another line…
-
Dynamic reporting for weekly and monthly
Hi All, I need a suggestion on below requirement. I want to create a P&L report where by current month data should be shown at a weekly level for current month and show the month total and the remaining months in R12 will be planned at a monthly level Can this be possible in a single grid(single module), to publish as a…
-
"ask every time"
HI All, I have an action that exports data into a specific format. Is there a way of getting the action to dynamically link to the version selected or do you need to record an action for each version? (also specifically asking for an APP on the UI as that seems to default to the one selected at the time of setting up the…
-
Optimal Design
Hi All, I have the excel files which has to be uploaded in Anaplan at each quarter levels so we are uploading this file four times in an year, each file contains many columns which are lists in Anaplan. There are about 12 Lists (columns in file) and the each file has nearly 40K records. I have created an Input module with…
-
Compare Descendent Row Data
What's the recommended function/formula combination to compare the Period and Final Amount data in order to identify duplicates? Note: The items being compared are in a composite list and share a parent. I would only want to compare items that roll-up to the same parent. In this example I want to flag any rows with the…
-
Unable to Change the Summary of Line Item from Sum to Formula: Time, Sum
Hello, I'm getting an error when changing a line item's summary from "Sum to Formula: Time, Sum": "Invalid combination for line item 'Sales' of summary method 'Formula' with formula using LOOKUP and/or SUM (or other summary function)" The formula of the line item does indeed have a Sum function, and I'm getting it from…
-
lookup not working
Hi, Can anyone please explain why the below formula is not pulling any data? I wanted to fetch the details into LoS from SYS13 using LoS(numbers) as driver LoS >> Line Item List(Length of service) I tried converting the LoS(Numbers) into Text & tried vlookup again but it didn't fetch any details Thanks
-
Level 2 Sprint 4 Conclusion - Importing DEM04 to DAT02
Hi Team, @einas.ibrahim I am facing difficulty while importing DEM04 saved view demand data in SC into DAT02 volumes data in FPA. I am not getting data in SKU, LOCATION CODE as can be seen in the IMPORT01 file. Also, my Demand numbers are coming up as weird numbers. Is that because I choose SUM as a summary method in…
-
Anaplan HyperModel
Hi All, If we have multiple workspaces which we want to put in HyperModel and want to allocate the space from some WS to others, then is this possible? - Is there any limit on increasing one WS in the Hypermodel? Thanks
-
Level 2 Sprint 3 - 'Inventory Ordering Modules'
Hi, I believe I have completed the Inventory Ordering Modules section, but I'm not 100% confident with all my formulas. Below is an example of what my outcome is when I do an override suggested order amount in week 1, along with a shipping method override. Does my outcome look correct? If you need to see the thinking…
-
Level 2 Sprint 2 DEM03 Growth Rate % line Item
Hey there, Anaplanners! I am on Level 2, Sprint 2 and am having difficulty with the Growth % line item in DEM03. Growth Rate % line item With this line item, build a formula to pull the Volume Growth Rate % from the DEM02 Volume Growth Rate by Weeks module. I understand that I need to look up the SKU to get the Parent…
-
Is color coding General list name possible?
Hi We have a bunch of general lists in use out of which few need data input from users , from time to time. Just to highlight those lists, is it possible to highlight their name in color for the benefit of the users? If that is not possible, then can we group those lists separately within the General list ? Thanks Regards…
-
Data split possibility while loading into Data hub based on region or company code?
Team , We have integrated multiple data objects from SAP to anaplan data hub for one region . We have set up filters and parameters in our middleware system(CPI) to filter data for the region and the data loads into data hub . Now in order to integrate the same data objects for another region i would like to use the CPI…