-
can build a action that updates current month in time dimension of both hub and spoke?
Hello everyone, Can we create a action that updates current month in time dimension of both hub and spoke. Thanks, Maithri.
-
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…
-
Cumulate a moving target
Hey Anaplanners! Hopefully a fun one and not just my own short-circuiting. I'm working through a capacity allocation rankcumulate, where my list items(SKUs) have a target for a month, and multiple sites that can produce units towards that target. My issue is that the cumulation is correctly grouping by SKU group (family)…
-
Button on Dashboard not working
The picture above highlights the problem, every time i use the button Add Sub-GL/Vendor Item, the chart to the right should update with the name, GL account, for each department. I tried to add a new vendor expense under admin finance and legal called "anaplan", the gl account i choose was called software/subscriptions.…
-
Add a button to a dashboard
I have dashboards built out for budget owners in the model layer not app layer of anaplan. I would like to add a button that essentially gives the budget owner the option to add an additional FTE to their headcount and plug in the respective salary of the new hire and see the financial effect of adding one additional…
-
Importing module
Hey community, hope you can help me with these one. In my Data Hub model I have a module to fed the others which includes different columns such as CCs, Accounts, Entities, etc. For the CCs specifically I create a mapping module which map some CCs to their parent level (these to avoid creating too many cost centers on the…
-
what is the difference of SUM ,LookUP, Select
-
What is Data Integration , any example scenario?
-
What are the best Practices for model building , how can i list out. I am in training level.
-
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…
-
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
-
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…
-
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…
-
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…
-
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…
-
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:…
-
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.
-
Use formula to integrate data at multiple levels of list hierarchy
Hello, my model has a list hierarchy of "FND01 Fund" and "FND02 Series". FND01 has a top level of "All Investments." The model also contains three modules with data values at each level of the hierarchy - Total, Fund, and Series - and I want to integrate this data into a unified report as shown below: I need to write a…
-
why is the summary not showing even when its enabled...
i have to refer sum in another module but it shows 0 since the sum is not showing here
-
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