-
Summing the time dimension
Hi, I'm trying to do something which I think should be very simple but which I just can't seem to get working in Anaplan. I have two modules with exactly the same dimensions, except one has a time dimension (years) and the other does not. How can I have a line item from the second module (without the time dimension)…
-
Childs with same parent crossing in a same module
Hello all, Imagine we have a parent list Country (G1) and two child list attached to this list: Fisrt list => Regions (G2) and a second list Stores/Entities (G2 bis). We need this second list Digital Stores because for each country we may have 2 or 3 digital stores which may serve all regions of my country. For example, in…
-
Modelling from module "Line Items" view
The "Line Items" tab is a really handy view when reviewing a model and looking through multiple line items across different modules at the same time. You can currently access the formulas by double-clicking but I think the view would be so much better if you could access all the module modeling actions (i.e adding a new…
-
Referencing same line item of prev row
Hi, I am facing issue in trying to reference the same item of prev row. For example, This is the Excel formula for a line item ‘Calendar Month’ : IF Calendar month of prev row = 12 THEN 1 ELSE Calendar month of prev row + 1 Has anyone faced similar issue? The Else part of the formula gives circular reference.
-
Lineitem Format : Timeperiod show Quarter and Year
Hi, Is there a way I can show in my line item formatted as Time range to show both quarter and year ? The reason is to have a full year view of my data. Regards, Tom
-
Run model-to-model imports in Anaplan on a schedule that works best for you
You can use the native capabilities in CloudWorks to distribute data from the Data Hub to Spoke models, or between different models in the platform, any time you want with its model-to-model import functionality. No activation or add-on services are required to use this—everything you need to get started is in CloudWorks…
-
Need help on 7.2.3 Activity: Import Data into Employee Details Module
-
Keep Model In Memory (KMIM)- can we keep model cache alive , it will help with performance
n we keep the model cache in the buffer/memory (Keep running) alive, instead of clearing eveytime after logout? This will take a long time to load the model every time when size is huge ..otherwise we have to keep some dummy job running to Keep Model In Memory (KMIM)
-
Report design question
In the attached screen shot you will see one of our report by Project and by Time. This module is dimensioned by Time, Project List, Function list and Funding type. We have data for actual, forecast and etc. We need to see Project ID and Project Status information on this report. But if I add them as line item, they show…
-
Previous for a monthly result only.
Hi Team, Is there a way I can use Previous but won't affect my previous or succeeding month? Example: Jan 1 - 1 Jan 31 - using Previous I will get 1 Feb 1 - 0 (should not get my result in Jan 31) Feb 3 - 2 Feb 28 - using Previous I will get 2 The previous will only get monthly result and will reset next month? Thanks in…
-
Calculation to get Quarters for Previous Year Only, Current Year Only, and Forecast Year Only etc
Hello, I'm trying to configure the view below using the Time Settings and/or Time Lookups module. I've tried multiple things, but haven't been successful. Can anyone provide guidance on how this can be achieved? Thanks.
-
Level2
Level 2 Completion I have completed and passed all the exams of Level 1 and could some one let me know web link for Level2 exam and required information. Thanks Narasimha
-
Filtering on user - Data is incorrect
Hi , I have a module with list of employees who belongs to different countries .I have created a user filter on country selection . Now when user selects a country ,the list of employees shows the relevant employees. But problem is total ,say total salary is not as per selected country ,it will be of all employees from…
-
Dynamic Aggregation
Hi, I have a module below, a list (transaction date) on the rows and time period on the columns. Is there a way to do dynamic aggregation vertically based the list transaction date? For example, I want to have this cell (time period: Apr 18, list period: Aug 19) to show sum of transaction period Jan 19 - Jul 19 for time…
-
How to delete imported data?
i want to know how i can delete imported data
-
Removing '0' from 3rd place
I want to create a new filed and a logic where the input will be project name which is a combination of letter and and digits. The new input field should replace '0' in the 3rd place of the project. E.g- PROJECT NAME: PR120 then new calculation field should remove '0' in the 3rd place what can be the syntax to remove or…
-
Time: PREVIOUS vs ITEM(TIME) - 1
Hi all, What's your opinion, should I ever use PREVIOUS(ITEM(TIME)) function when ITEM(TIME) - 1 does the same thing? Best Practice says it's not recomended to use PREVIOUS() due to low performance. In the example above it is probably straightforward "yes" to ITEM(TIME) - 1 approach. But what about when there is some…
-
Calculation to get Quarters for Previous Year Only, Current Year Only, and Forecast Year Only etc
Hello, I'm trying to configure the view below using the Time Settings and/or Time Lookups module. I've tried multiple things, but haven't been successful. Can anyone provide guidance on how this can be achieved? Thanks.
-
SUM or IF? Performance and Readability
I'm interested to see which is the better performer and also, subjectively, which function is more 'readable': SUM or IF, in the following scenario... Consider that you are building a model for an international retailer. This retailer is setting up stores in different countries. When setting up a store in the first month,…
-
Dynamic Numbered List
Hi, I have Months as a numbered list. The number of items in this list is calculated based on user input. Each time the user changes the input, the list should be deleted and items should be created based on the new value. Is it possible to dynamically create the number of items in a numbered list? Thanks
-
Ability to use ROLES as a dimension and a dropdown for DCA setup
While setting up the Dynamic Cell Access based on user roles we would have to resort to a workaround where we would create a list of roles and based on that we would setup the DCA. However, if the ROLES (native system defined) could be allowed as a dimension, just like how the users are allowed to be used a list, it would…
-
Retrieving last non-zero value
Hi, I created a module with exchange rates data for each month. Then, I put summary as : sum, time: closing balance. But as I only have data until Sep 2020, it puts 0 for FY20 and 21. So, I would like to set up a formula that retrieve the last non-zero value for FY20 and FY21 for instance. Thank you for your help!
-
Copy and Paste not working on numbered list
Hi, I have a requirement where I want the user to select an item from the numbered list formatted line item and then copy the same item in rest of the rows, but this doesn't work and throws the error attached. The reason for this is that when I copy the item it copies the display name and not the code. Any idea how to…
-
user access automatic termination
Hello all, I am looking for a solution wherein we set a specific time period ( 6 months) for certain users and post 6 months their access should be automatically terminated? is it achievable ? Thank you Ankur Kulkarni
-
Report Page : Add Hierarchy filter
Hello ! We would like to produce dynamics benchmarks with the new report It could be powerfull if we have the hierarchy filter option in context as it already exists for boards.
-
Removing line items in List
Hi All, Need help with how the process to follow the deletion of line items in the List. H1/H2 is the List within that we have 3 line items called Total(Parent), H1 and H2(Children) it's summing up to Total. I want to delete only Total (Parent). Internal Workings I) Having around 180 modules using the H1/H2 list as a…
-
Lookup between two modules with different dimensions
Hi, I have below two modules: Module CAL04: Page: Business Line, Line Items, Column: Time, Row: Transaction month Module DAT06: Page: Business Line, Column: Periods, Row: Line Item I want to have NCO% in module DAT06 to show up in module CAL04 per the "reference period #" line item (e.g any "month 0" cell with have…
-
Parent to child Levels
Hi, For your assistance please. I would like to ask how can i lookup child which is on level 2 and the parent is on level 0? Hierarchy Target Module : Dimension : L2 cost center Source Module : Dimension : L0 Cost Center I created two line items below in my target module but when i try to get the data from the source…
-
New UX - Add Collapsible Cards on Boards
It would be great to be able to add collapse cards on the boards - similar to Additional Insights- . It will allow the view to be clean but will also house the information to be accessible without going to another page. Boards are especially helpful when displaying charts and key KPIs and being able to house the supporting…
-
Level 2 Sprint 3 INV01 Inventory Ordering
@Misbah 1. Shipping Costs = Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method] Is there any problem with this formula? 2. Safety stock Target = WEEKVALUE('DAT04 Distribution Center Parameters'.Weekly Safety Stock) Safety Stock…