-
Variance reporting - not using native versions
Just to give context we do not use the native versions in Anaplan, rather we use a list name forecast versions and then have a subset of these that we have of these that are marked as those we wish to do variances on, which seems to work well. We predominantly look at variances at a certain level in our cost centre…
-
Actions - New action 'Bulk Copy" - Select the source and target list items when the action is run
Hey Community! Could you please explain the function Actions - New action 'Bulk Copy" - Select the source and target list items when the action is run? This option is open when you just open the modal window to select source and target, as well as after manual selection from the list of all actions. Many Thanks Many Thanks
-
Dynamic Subtotalling for List item subset based on user selection - Module Size Optimization
Hello, Apologies for the long post, I tried to be descriptive enough! I've a module in production which has close to ~3 billion cells, (this module alone occupies 25GB of space). I'm trying to optimise this module for space and make it scalable. The reason for the size **** up is multidimensionality and extreme sparsity of…
-
Preventing Duplicate Imports and Handling Data Changes
Hi ALL, I have an input module where users enter project input details such as Project, Country, Size etc..These two modules are connected through Project 'Libe'. Users uses a Boolean called 'Import to L2 Page' to import these records to the 'L2 ' page using an action. After the import, the Boolean('Import to L2 page) is…
-
Can we re apply for workspace for practice purposes
re applying can be done ?
-
Limits
I need to reproduce a table of limits like in Excel. Where the limits are input fields that can change over year. How do I build this image of Excel in Anaplan? One of my problems is that the real limit is an input field but I also need to put a color between my limits. Help?
-
I was working on Profit and loss module in Level-1 Model building course.
Hi All, Can anyone please help me with this issue, I was working on Profit and loss module in Level-1 Model building course. The results i am getting after adding the formulae are different from the screenshot shown in course. Can anyone help me with this. I have spent quite some time trying to solve but yeah no use. This…
-
Native User Filter on Module
Hi Anaplan Community, Good Day! Can you help me solving the user filter saved view on module. My goal is to have an import process where the user will use and the only data that will transfer is their account entry. I will be using the native user as line item on this report: I created an additional module to use as a…
-
How does this new fluence/Anaplan disclosure management work?
I want to understand on how I can get access to new fluence/Anaplan disclosure management Is it part of the license? Also can multiple users work on a single report at the same time using this tool?
-
Conditional Formatting in Graphs/Charts
Hello, I am working on a project that requires conditional formatting for a graph, such as orange for bottom 10 products and blue for the top 10 selling products. Is it possible in Anaplan or is there any workaround for this? Please see the attached picture for a sample graph I want to create. Thanks
-
How to reference a Time Period in an IF statement please?
My PRACTICE module has time dimension as Months 2019. I want to create an IF statement in the RESULT line item that says IF Time Period < Jul 19 THEN TEST 1 ELSE TEST 2 How do I reference the Time Period in the IF statement? i.e. how do I write the IF statement so that in the RESULT line item there is 250 from Jan 19 until…
-
About DAC Drivers
Hi Team, I understood that we can use only Boolean drivers in DCA, why can't we use other data types? One reason is space, Boolean consumes less space than other data types. Thanks in advance.
-
How to Aggregate Monthly Data to Yearly When Time Summary is Set to None
Hello Anaplanners. I have a module dimensioned by Month, but the Time Summary for my key line item is set to None to optimize space. However, I need to bring this data into another module that is dimensioned by Year. Since the time summary is disabled, the values don't automatically roll up to the yearly level. Would…
-
My SUM formula is only bringing back data for 2 list items but not the other 300 odd lines.
I have 2 modules set up, one with source data by line item that contains a 'Fund' code (CAL13) and then one with list mapping data by fund code (SYS34). I have set up a 3rd module and added in this formula 'CAL13 Consolidation by Fund'.Actual by Fund[SUM: 'SYS34 F4 Fund Details'.Account Mapping] They both have a level of…
-
Conditional Formatting for User-Based Search Functionality
Hello Anaplanners, I have created a search functionality in Anaplan that allows users to search for specific text within the project descriptions, Project one liner, Project StoryBoard line items within a module where Projects are a dimension. The search functionality is user-based, meaning each user can input their search…
-
Using Network cards for dynamic org charts
Hi, We came across org charts (Hierarchy Charts) which are a great functionality. However, we want the client to be able to do scenario planning on the hierarchy and by Month. E.g. John could report to Smith in Jan, but in Feb , he report to Molly. Since Org Charts cannot refresh dynamically unless you incorporate time…
-
Import/Upload restrictions on Flat List and Flat List Modules
Hi All, I have a flat list which is a concatenation of Lists - Company Code, Costcenter, Costelement and KPI, ex - IN11_CC2222_CE3333_PL50. There are more than 5000 list members. We already have a module based on this flat list. Users from different regions upload Planning data to this module using offline csv files. The…
-
年度リスト→日データに適用
4月~3月を一つの年度として、認識させたい。 まず、年度のリストを作りました。(2024.2025…. そのリストを、日データ（2024/4/1→2024）につけたいです。 年度算出まではできたのですが、その後どうすればいいか詰まってしまいました。。
-
Bulk Copy Run Not Visible
Hello, has anyone ever encountered this before? I am trying to execute a bulk copy from one version to another and when I come to the "Are you sure" page the run / ok button is not visible, therefore I am unable to execute the action.
-
Most efficient way to apply bandings to employee list
Looking to apply the bandings below to employee list depending on what salary is and whilst I know could do this by using combination of IF and AND statements I'm thinking there must be a more efficient way to do this calculation wise - any tips or suggestions would be much appreciated.