-
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…
-
Level 2 Sprint 3 : AD02 Inventory Ordering Overrides
Hello, I am inLevel 2 Sprint 3 I have the following formula for the boolean line items in AD02. For the line : Override Amount - Write? My formula is : IF 'INV01 Inventory Ordering'.Submit Purchase Order Request? AND 'INV01 Inventory Ordering'.Override Suggested Order Amount? THEN TRUE ELSE FALSE Can anyone correcte my…
-
How to turn on file upload toggle on classic dashboard or NUX.
I have created and import action of users through CSV file but unable to find same toggle in classic dashboard action to upload a new file and run action again to update my user list.
-
Organizational reporting structure in Anaplan: Seeking Input and Insights
Hello, I work at a company's headquarters, where we use Anaplan applications for reporting purposes. Some of these Anaplan models have been developed in-house, while others have been created by external consultants. This has resulted in a situation where we have multiple lists containing more or less identical…
-
Dimentionality of a model
How is the dimension determined for a model? Here is a high level description and issue i am facing. Module (1) I have a list of entries considered the column looks like this (let's say 10 columns) Dimension ABCDE Metrics FGHIJ The cell count is 66,807,426 And Let's say column E is the project id which could be mapped with…