-
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…
-
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…
-
4.8.2 Activity: Import Data into E2 Employees# List.
4.8.2 Activity: Import Data into E2 Employees# List. How will we fill this place?
-
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…
-
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…
-
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…
-
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…