-
Optimizer - Approach
Hi All, I am trying build optimizer for assignment of products into lines. Below is the scenario: 1) calculated the capacity of each line ( Dimension by Factory Lines) 2) Created Production plan for each SKU ( Dimensioned by SKU) 3) Then Have a mapping module between Factory lines and production which helps to decided…
-
Forecast Function in Anaplan
Hi team, Can i know if we have an equivalent function for forecast() from excel in Anaplan. In Excel we have Excel FORECAST function The FORECAST function in Excel is used to predict a future value by using linear regression. In other words, FORECAST projects a future value along a line of best fit based on historical…
-
Limiting user edit access to column in a module?
Hi, I am trying to create a DCA to control access to editing 2 columns in a module by specific user. The modules are accessible by 2 roles (Planners & Category Managers). Currently both roles have write access to the module. However I want to restrict the Category Managers to be able to edit only 2 columns in the…
-
Boolean dependent selection with DCA
I am trying to find a solution to my module : I have 3 booleans Boolean A Boolean B Boolean C The Booleans B and C can be selected only if Boolean A is selected. I have used the DCA for this. The DCA is a simple one : A. The DCA is applied to B and C. My question is : when I deselect the Boolean A, the Boolean B or C that…
-
LiS for Export module
Hello Comunity, I am trying to build a LiS on order to have a selection of the Forecast and the Type of the FTE. The problem I have is that when I try to build my LiS on my Forecast Model, the FTE Type is a subset List put in pages. So I won't be able, in my LiS to have the Forecast by each FTE Type(the selection is not…
-
User List in PROD and Sandbox models
Hello, I have a production and sandbox model in the same workspace, and I realized that when I delete or add a user to the sandbox model, it is also added to the production model and vice versa even though there is no sync or connection between the models other than they are being in the same workspace. How is that…
-
sso selection is not visible for our models
Just noticed our models are not showing "SSO" option selection in Users tab. I am workspace admin/tenant admin, so not sure what I am missing here?
-
How to show UserID in the Target module for the user created list items?
Hello, Employee Details is my source module, in which Users (Manager Role) manually transfer employees. Manual Transfer ID will be created for the employee's vacant position. Current Month filter applied on the page. Running an action creates list (TBH) with Manual Transfer IDs and also loads the data into module…
-
Which Tool Is Easy To Handle Complex Data?
Any advice for the below query will be highly appreciated. Would it be easy for someone to learn Anaplan if they have a Salesforce marketing cloud certification with the given skills set? If not, in how much time he can learn the basics of Anaplan? Recently, one of my friends was assigned a task to work on complex data,…
-
Please help to see why this formula returns 1 instead of 0?
IFTRIM(Deliverable Item) <> TRIM('DAT.040 Approved Deliverables'.Deliverable Item[LOOKUP: 'SYS.910 Other Settings'.Audit Version Lookup])THEN 1ELSE 0 Deliverable Item is :Channel Data Mgmt Platform: Pre-study to build one single harmonized platform for all our Partner data, expanding our capability to deliver data driven…
-
How to allow a dashboard to be filtered by many users independently and simultaneously?
We have a small list of users who have access to the same dashboard, but can only view their divisions. We built a separate card on the dashboard that allows them to select and de-select multiple items in a select dimension list. We find that when users select or de-select these items, it is changing the data on other…
-
How to convert an annual amount to a monthly amount
I have 2 modules, both dimensionalized by the same list and time (1 is by year and the other by month). I need to take the annual amount in module 1 and spread it over the monthly amount. I've tried spread(Annual Amount, 12) but I'm not able to get anything to populate in the monthly spread module. Any guidance would by…
-
Dimension Help for Equity Waterfall
I am new to Anaplan and am currently doing a project for fun. I am trying to recreate a equity waterfall that is commonly used in Private Equity. I am currently stuck on an issue on setting up dimensions that will be used for the waterfall calculation. Attached are screen shots of what I am trying to recreate in Anaplan.…
-
Need help to avoid hardcoding SELECT
Hello, Need some guidance on how I can avoid hardcoding. Let say I have a module A that applies to Country and Product (Coke and Pepsi) and line item as sales I have another module B that applies to country and I want to create two line items Sales - Coke and Sales - Pepsi which I then want to compare variance. This is the…
-
In tab 7.08 I would like and additional column between actual total cost and planned cost on tab 7.0
-
TIMESUM - No values on drill down
Hi - per the title, I was curious whether it was a known 'feature' that lines solely leveraging TIMESUM do not provide drill down information beyond the parameters (if used)? E.g. even if you drill down on a field with values, if the function solely uses TIMESUM, you don't get a breakdown of the values by period (or values…
-
How to hide line items in UX avoiding repetitive hide UX command
Hi all, I am facing an issue I'm pretty sure many of you already have dealt with. The columns Cost Center, Responsible, Employee Name, Labor Cost are line items. I wish I could show the cost center, responsible, employee name, labor cost line items only for the first project (1-Av-Bc - Argus V1); in short, I need to go…
-
How to make Total Final Allocation as 100% ?
Allocation% will be loaded into this module which is dimensioned by Channels and Country. For some channels, Allocation% shall be Held or Overridden. Here required output is to get Total Final Allocation% as 100%. But, I end up with having Total Final Allocation% same as Total Allocation%. (Here 74%) The below snapshot…
-
Capturing uploading timestamp in a line item in module
There is a requirement where, when we are importing data in a module, the current timestamp when the file is uploaded in the module should capture that time in line item?
-
Error when importing into module with numbered list as dimension
Hi Anaplan Community, I try to import data from a saved view in my source module to my target module. My target module has numbered list #L3 SKU-Plant as its sole dimension. My source module has the material list as sole dimension. As part of my saved view in source module, I created a line item "L3 SKU-Plant list item 1st…
-
Level 1 Model Building EMP02 Employee Expenses Module Dimensions
Hello, I am currently in the process of going through the Level 1 Model Building course. In section 10, I was instructed to create a module with the dimensions: #E2 Employees, Active?, Time The problem is that I don't see Active? anywhere in my model, except maybe as a line item in a separate list or module. Regardless, it…
-
problem in import from module to another module ( both contains the same numbered list )
I want to import from module to another module when dimentions of the both of them is a numbered list . during importing mapping is incorrect ( numbered list item can not be mapped correctly)
-
Concurrent changes by multiple builders in ALM models
Hi all. We have multiple model builders working in the same model at the same time. One person's changes might be ready to be sync'd to live while the other person's changes might not be. Does anyone have tips on good governance that can be put in place to help us control this in a better way? Currently we end up with…
-
In a module a data value is getting overlapped by an unknown action. I am unable to find that action
I am working on a model where a data integration happens in every 4 hour and that loads multiple data in a module. Now for one of the line items and for one particular account the data is getting overlapped and in some data integration that data is not loading correctly. However as per the action responsible for that data…
-
Model sync error due to time scale and time summary
Hi all, I would really appreciate your help with a weird error. I'm trying to synchronize changes I made in my development model to my production model, but I'm getting the attached error. I did make changes to timescale and time summary, not brought forward property. What puzzles me is that I get this error while the…
-
List vs Dimention
What's the purpose of storing a value in the dimensions instead of line items? Adding it into the dimensions just explode the model's size. Is there a difference when it comes to create visualization too?
-
Delete from list using selection
Hello Everyone, I have a module dimensionned by two lists, in which I added a boolean "Delete" which is codded by true, and I wanted to create a delete from one of the two lists using selection in the "Action" table, based on that boolean, but when I look for it I don't find it in the droplist of "selected using", which is…
-
WORKSPACE SUB DIVISION
We have a single workspace running multiple models. We want to sub divide the workspace so that we have a small area for purely training/experiement models and a much larger one for developmen/production models. The vision is we would run with different user lists in each area,for example. Once sub divided each workspace…
-
Level 2 Conclusion OTH01 Non Employee Expenses
Hello I'm on Level 2 Model Building: Conclusion, and it says: Import the Shipping Cost data from the Supply Chain model into the OTH01 Non Employee Expenses module, Shipping Cost line item. For department, import into the Sales department. Run the import. Results should have none ignored and 0 errors. Here is my saved view…
-
Financial Consolidation
Hi everyone! I'm trying to explore Financial Consolidation - IFRS app by Anaplan. I see this app as a source of supreme value for one of my clients. However, I'm a little bit confused of its complexity. As for now I understand the general logic of the model, but I'd like to get enlighten into step-by-step user experience…