-
Import/Upload restrictions on Flat List and Flat List Modules
Hi All, I have a flat list which is a concatenation of Lists - Company Code, Costcenter, Costelement and KPI, ex - IN11_CC2222_CE3333_PL50. There are more than 5000 list members. We already have a module based on this flat list. Users from different regions upload Planning data to this module using offline csv files. The…
-
年度リスト→日データに適用
4月~3月を一つの年度として、認識させたい。 まず、年度のリストを作りました。(2024.2025…. そのリストを、日データ（2024/4/1→2024）につけたいです。 年度算出まではできたのですが、その後どうすればいいか詰まってしまいました。。
-
Bulk Copy Run Not Visible
Hello, has anyone ever encountered this before? I am trying to execute a bulk copy from one version to another and when I come to the "Are you sure" page the run / ok button is not visible, therefore I am unable to execute the action.
-
Most efficient way to apply bandings to employee list
Looking to apply the bandings below to employee list depending on what salary is and whilst I know could do this by using combination of IF and AND statements I'm thinking there must be a more efficient way to do this calculation wise - any tips or suggestions would be much appreciated.
-
LOOKUP Problem!!!
Hello community, I am going through something with Lookup formula as below. I have a module (say module1) dimensionalised by Account list with Account code column. I also have a List (say list1) with account code, employee code and names. In the module 1, I have created line items for employee code and name. For which I am…
-
Unable to show tax rate which is a 2-variable lookup from another module
Hi guys I am facing a problem and thought any kind soul here might be able to help out. In this module HR02, I am unable to display a "Tax" rate which is essentially a look-up from TAX01 Any idea what would cause the lookup to not work? Thanks!
-
Field no showing on Add Entry screen for some users
Hello, we have a Dashboard and there is a New Entry form, we added a field (unrestricted) for currency in the module, and added it to the entry form. Some users are seeing the old list of fields to add Others are seeing the new field included I cannot work out why this is not showing for all users as there are no selective…
-
Filtering Actuals based on selected Version in UX
I have (simplified): Actuals Module - dimensioned by Time only Forecast Module - dimensioned by Time and (let's call it) Version List (not the native Version - just a normal list) Settings Module - dimensioned by Version List, which has a line item called "Forecast Start Month" (format: Time/Month) System Module:…
-
Access Restrictions on Flat List
Hi All, I have a flat list which is a concatenation of Lists - Company Code, Costcenter, Costelement and KPI, ex - IN11_CC2222_CE3333_PL50. There are more than 5000 list members. We already have a module based on this flat list. Users upload Planning data to this module using offline csv files. The Process has 2 actions,…
-
How to map one to many products in Anaplan?
Hello, I have the following problem. I am trying to associate Customer Part Number, which is a unique product code in the customer's store with the SKU that exists in my store. For example, the customer sells a set of furniture, a table and 4 chairs, as one code in his store, and in my store there will be two separate SKU…
-
Forecasting Sales
Hi, How to forecast data for future months? I have data for FY23 and I want to forecast the Sales for FY24. I have two line items: Sales and Quantity. Is it also possible to forecast the two of them? Thanks
-
Get Data from a module with dimensions to a module without dimensions
Hello, I have a module with dimension "Invoice Number", in this I have Start Period and End Period for the invoice (it can cover multiple months). In another module without dimensions I want to be able to show which Start Period and End Period a invoice have based on if a boolean is true in the first module. Does anyone…
-
Filter list using list property
Hi Hoping someone can help me solve this issue I am having. Probably doing something very silly! I want users to filter a list of managers which is a subset of the employee list. I wanted to do this through a list property driven by a line item in the model. I have done this before but I cannot seem to get the dependent…
-
Error while applying user based filters
Hi All, I have 3 modules, let's say A, B and SYS Filter A module has dimensions - Stagging list, custom versions. B module has dimensions - Stagging list, subset custom versions. SYS Filter Module has dimensions - Stagging list, custom versions and Subset Users. while applying same filter from Sys filter module, A Module…
-
Update subsets for the lists with Selective access
Hello, could you please help with following situation. I have the flat list of positions for which Selective access is set (according to the access of the user, so that HRBP of the Facility 1 has access only to applicable positions). All the major calculations are made on this list of positions ir order to save space…
-
Formula for Quantity Multiplied by Price
Hi, I'm playing around with some dataset I've found. The data only has values up to the month of June. Is there a function for getting the unit price based on the quantity that I will input for each month multiplied by the price of each product in every location? So that I could fill all the months with no values. I also…
-
How to SUM the last three months
In the line item "last 3 months sum", I'm trying to sum the last three months. I tried using timesum but wasn't getting the right numbers. Any help appreciated, thanks!
-
Last 52 weeks Calculation
I have a requirement to show the last 52 weeks value. I want to create another line item which has to sum last 52 weeks total hours e.g.: 03/08/2025 should show the last 52 weeks data this should be dynamic and 52 weeks should change based on the week. Thanks in Advance.
-
Resync PROD - DEV Enviroments
Hello, I needed to do a rollback on the PROD model to an ID from the History, so it implied to get the PROD from DEPLOYED to STANDARD mode. I knew before that this will happen, but it was kind of urgent to solve the issue that we had so this was the only way. Now I am asking you, what is the best option to resync the…
-
Getting 0 results from a COLLECT line item
Hello, I have a line item that has a COLLECT() formula. This returns the values just fine. But when I use this line item and Lookup or Select a specific member, it doesn't return any value. Is there a way to do this, or am I doing it incorrectly? LINE ITEM FORMULA APPLIES TO SUMMARY TIME Source line item COLLECT() List 1 &…