-
Changing formula scope does not re-apply to line items?
I have a formula which was written with the formula scope set to 'All Versions', then realised that I only need it to apply to 'Current Version', so I changed the scope but the data is still showing in the actuals and the forecast (all versions). If i add a new line item and set the scope first, and then use the exact same…
-
Summing only some lines in a list
Hi everyone, It's similar to SUMIFS with 1 criteria as a line item and another criteria as a line in a big list. I've tried SUM, LOOKUP but none seems to work. the error is: This … is not a line item could you please see if you can help? Many thanks, Jesse
-
Cloudworks not working
Hello everyone, I tried to automatize a process through Cloudworks, the process do to following thing : it pushes boolean values from one Line Item in the Model A to a Line Item in the Model B. So i created the action (that i encapsulated in a process) in the Model B, then i went to CloudWorkds and did the correct setting…
-
Level 2 Sprint 3 3.3.6
Hi, I'm having difficulties in the Shipping Cost and Final Shipping Cost line items. The formula I used for both: Shipping Cost: Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method] Final Shipping Cost:…
-
What is Data Integration , any example scenario?
-
what is the difference of SUM ,LookUP, Select
-
What are the best Practices for model building , how can i list out. I am in training level.
-
DCA without user list but with roles-list mapped to users instead
Hi Anaplan Community, I have a module "Module 1" which currently has one dimension: the product list. The module is used to apply an approval flow for cost updates to the product. Depending on if the user has been setup as requester or approver in another module (user list with boolean line items), the DCA on the line…
-
Community perspective: Anaplan user license management
What is an Anaplan user license? Users get access to Anaplan based on the model role provided to that user. From an Anaplan commercial perspective, each Anaplan user is consuming one active Anaplan user license. On a high level, Anaplan has the following three types of user licenses: * Model builder * Contributor * Viewer…
-
I am trying to create a module where I will have a list that rolls up to two different parents.
I am getting an error "an invalid Applies To for Test because Domestic and International have a common ancestor." I am trying to create a module with few list member that rolls up to two different parents. For example- Product A Product B is a part of Domestic Sales destination and Product C and Product D is a part of…
-
Best Practice: PARENT() vs. LOOKUP ?
I am looking for assistance to understand best practice/performance implications between 2 different approaches of getting a list item parent in a formula. Imagine I have 3 modules: X, Z, and System Module. The System Module contains Parent line item with formula PARENT(PARENT(ITEM('List Items'))). I want to return this…
-
Sequence of list elements creation during imports
Hi, As part of a requirement, I am looking to gather more information on the order in which the list elements are created. Consider my source as If I want to use the above view as a source and create list elements , 'A', 'B', 'C' and 'D'. Can there be any possibility that instead of creating them in the order , Anaplan…
-
Switching from Model Calendar to Time Ranges
Hi Community Members, My model currently has 6 future years in it, with Calendar Type as Months/Quarters/Years and no time ranges. I dont need month level data outside of next year so instead of months for years say FY25 and so on.. I only want them on the consolidated FY level so I can reduce my model size. I would also…
-
Allocations Impact Calc in Anaplan
Hi Experts, I have a scenario where we split our departmental expenses in a ratio ( a:b:c:d) and that ratio changes by sometimes quarter over quarter or year over year. What I would like to do is to be able to plug in the Quarters/Half year/Year I want to compare as inputs or selections, my department in question as an…
-
I want to understand the use of this feature?
I am trying to import data from Data Hub to spoke model. The requirement is to clear the target before loading the new data. Can I use this option at 'All Items' as an alternative to creating clear module data actions using 'No data' formatted clear line items in the target? Is that more efficient? Does it work the same…
-
Summing on Period (Quarter)
Hi, I need some help in summing on the maturity period (quarters). Module 1: no time dimension, standing data showing loan amounts in various currencies, and maturities. Module 2 is dimensioned by time (quarters) and the loan amounts are converted at the quarterly FX rates. Module 3 is dimensioned by time (quarters) and I…
-
Calculating the average of a balance sheet item for quarterly / annual totals
I have a number of balance sheet accounts (e.g. Closing Receivables*) for which I need to calculate the average value. This should be calculated as follows: - Monthly: average between the current month and prior month value - Quarterly Total: average of the last 4 data points - Annual Total: average of the last 13 data…
-
Why can not close a dashboard in Anaplan?
One end user can not close the dashboard in Anaplan and get above warning. But on other dashboard did not meet such issue. What happened on it? Please advise.
-
Importing is not updating correctly
Hi all, I can't figure out why my importing is not updating correctly. the mapping is correct but when i cheek it, the ligne item is not updated. pic attached for more details.
-
Formula - limiting values returned
Looking to limit the values returned within a module, which I've made a start on the module showing in the right hand side , where limiting by currency. However, if I then also wanted to limit by say GL Category or GL code, how would I go about this? Any help would be welcomed on this
-
Integration Question
Can I know if the Anaplan Bulk API connector for integration is being used, will it send the log report (like we do in manual upload)? I need to know will the user receive the notification of success/fail (error log report) from SAP - > Anaplan. Not from the history I wanted to check because it is a daily process running…
-
Can I use Lookup Formula in this case ?
Hello all, I'm currently working with a model that provides weekly forecasts for all products. My goal is to obtain forecasts categorized by product type (S or W) instead. However, when I attempt to use a lookup, I encounter this error message : "Format of mapping used for lookup doesn't match any dimension of the source".…
-
Managing expenses as positive, reporting as negative
we have a client that manages expenses at GL account level as positive numbers. they rollup the GL accounts to reporting lines (they have multiple GL accounts for salary and report salary on a P&L). the reporting lines are hierarchical (total income and total expenses aggregate to profit before tax). they would like to use…
-
Can Anaplan Connect with batch scripts append data?
Hello, I'm using Anaplan Connect with batch scripts to integrate data into my Anaplan models. I'm interested in understanding whether Anaplan Connect supports the ability to append data to existing records in the models. Could you please provide information or guidance on achieving data appending using batch scripts in…
-
Restore archived model of a deleted workspace
Hello, It is possible to restore an archived model included into a deleted workspace. Thank you in advance for your answer! Regards
-
3.3.5.3 Check your Work
My numbers are slightly off for some of them. I am not sure if one of my formulas is messed up, or what the issue is. If anyone can maybe point me in the right direction.
-
About deleting module data
Hello, I want to delete the module's data efficiently. With 100+ modules, manually removing them one by one would be too time consuming. Don't you know how to do something? Thank you
-
NO Time dimesin module to Time dimension module
HI I want bring the data from non time to time module. as mentioned screen shot
-
Can I have a code in a list mapped to different parent between two time periods?
I wonder if someone have come across of this use case: Our reporting hierarchy is based on Cost Centres i.e. Cost Centres are mapped to Business Units (Parent/Child relationship). There was a request to move a Cost Centre between two Business Units in July going forward, meaning that history remains unchanged. When I…
-
How to get the average of a previous month in the current month ?
Hi I have a grid where in I need to calculate the average of the commissions selected for a couple of months and then to send it to another grid of a different month. How do I do it ? PFA screenshots Need help urgently Thank you