-
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…
-
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…
-
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…
-
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.…
-
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…
-
Email Notification
I created a action - to add list member. Additionally also a notification to notify me via email if there will be a new List member added. But unfortunately it is showing me two different buttons to execute the process. Is there any way i can create in one process the adding of list member followed by Email notification?…
-
In tab 7.08 I would like and additional column between actual total cost and planned cost on tab 7.0
-
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…
-
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…
-
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…
-
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…
-
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?
-
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)
-
How to Get Current User and Time stamp In anaplan
How to get the current user for a line item and is there a way to get the time stamp
-
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?
-
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…