-
Hierarchy change
Hi All, Wanted to ask for a best solution of this question if possible. I have a process hierarchy which consists of 3 levels, and I need to extend it by adding 2 more levels between levels 1 and 2 (so whatever is on Level 3 now should go to level 5, and whatever is on Level 2 will be transferred to Level 4). What is the…
-
Stopped Data using time period
Hi, Anaplanner how to enter data and stop using time selection ?,, i have 2 time selection, start and end start for when data come and end for when data stopped
-
Identifying the max value for a specific field
Hi, i do like a dilemma it seems... I have a list with 2 fields (well lots but 2 that matter) Bvfsku and Vintage I want to add a field that indicates the one that has the latest vintage (2018 in this example) So a boolean or a number field that is set to TRUE or 1 if the Vintage is the latest year.... How can i do that…
-
Understand why a formula in the List Property is not working?
Hello, I have a list property that has a formula in it that was working and pulling data correctly. But today, it is not pulling data and I am not able to identify the root cause. Here is the screen shot of the list property formula: Here is the module where the formula is pulling the data from: Your help in guiding me in…
-
Line Charts should display trailing zeros
Model users are confused by line charts which stop along the x-axis. They need to be trained or instructed that trailing zeros in line charts are not displayed. Please update Line Charts to include trailing zeros.
-
Open Dashboard and different target dashboards based on a page selector
I want to use the "Open Dashboard and different target dashboards" feature based on a list property linked to a page selector I published in a dashboard, but it doesn't work. It works if I publish the whole module (not only the page selector). Is there a way to make it work publishing only the page selector? Thank you.
-
LOOKUP function Blank result
Hello everyone, I am currently working on a model where i am using some data i imported in formulas to create some relevant data for a YTD model. I am trying to implement the following excel formula : IFERROR(VLOOKUP(A2;'TCD CRISTALLINE'!H:I;2;0);""). So in the first part of the implementation i started off by trying to…
-
Trying to map data to a line item from a list
Hi, I'm creating an upload into a list. I've then created a module that looks back and returns the values from the list. I need to be able to map certain factories to certain line items. So if my factory is 1 then i need the line item to be returns from another module with a certain heading. The reason I can't use a…
-
spread of value on identical children
Hi, I have two modules, using two different list List1 and List2. List 1 module has a member FM and a line item amount value as 100. List 2 module has members FM1, FM2, FM3 & FM4. I want to spread FM value 100 from module 1 in module 2 having total four member starting with FM as 100(value)/4(count of FMnodes) = 25 each.…
-
How to add time period selection option in process while importing file
Hi, How to add time period selection option in process while importing file. Attached the screen shot for the reference. Thanks Usha
-
How to display date as Week number?
Hi experts, Could someone give me an advise for showing date as active week code? In my model, standard week is converted to active week and requested shipping date. Then, my client argues that we should export Demand forecast data in active week style (e.g. 202023 ). This is what is exported. Is there any solution for…
-
Unable to copy and paste value for line item with list subset type
Hi, I have a list and subset of it. I create a module, add line item, set its type to the subset list I notice that i can't copy and paste the value of that line item from one row to another, it can't be done by import action too, but if select it manually, then it is fine. Is it a known limitation for list subset? or is…
-
fetching Month from a Date we give
Hi Team, I have a use case where I need to find which month does a given date belong to. Could you please help me Thanks & Regards Prashanth Akula
-
More than one value for non-numeric cell
Hello everyone, I am having some trouble with the model i am currently trying to build, i am trying to import, into a module i created, a file containing a table (in an CSV format of course) with two columns : The reference and the description of those references, so i created two line items (reference, and model…
-
New Item addition for List(not numbered list)
Hi, Can I add create new item button for a List(not a numbered list). Regards Madhu
-
Lists as page selectors
Hi, Is it possible to create dependent page selectors when more than one list is published as a page selector? I have a module that forecasts demand for SKUS in different country. Currently when the user selects the country the next selection is SKU but the SKU dropdown shows SKUs for all countries. I created a filer…
-
Best approach on creating a comment section in a Forecast
Hi, I was wondering if it's possible or the best approach on creating a comment section. I tried creating a text line item but it seems to have some flaw to it. I can't make any edit on the Actual, I can only write comment on the forecast, etc. Is there a better approach to this? I included a screen shot to give you an…
-
group by line item
Hi, I have two different modules using two different dimensions. module 1 module 2 In module 2 I have an amount value, which I want to pull in to module 1. similarity between two module is Line item A (repeating text value), while pulling in to module 1 ,I want to group in amount value by Line item A( common line item in…
-
New UX option not visible
HI, even with page builder access/workspace admin access I am not able to see the new UX option in menu Is there anything i am missing?
-
Autofill Properties using the Create action
Hi all, A little issue i have : I am creating elements in a a numbered list (projects) using the Create action. My Create Button opens a new dashboard where the end users will fill in Project description that is used as "Display Property". I woul also like that a few project properties to be filled in automatically (a…
-
Limitation Lineitem subset source module
Hi Anaplanner, does lineitem subset have limitation for source module ? thanks
-
Dimensions type
Can we use one of the List properties as a Dimension to create a Module in Anaplan?
-
Selecting different values over same dimensions
Hi, I have two modules that looks like the following: Module 1 - No dimensions, just two line items. One of the line items is formatted as List X and the other is formatted as Time Period - Month Module 2 - I have time and List X as dimensions, and one line item, let's say price. Now to the problem: What I want to do is to…
-
Formula Syntax Function Key Search
Hi, Please help me to get the Syntax function key, how to find the any formula property in Anaplan by pressing key. Whenever we apply any formula in excel, we press TAB key then that formula shows to us what we have to select first. Regards, Vikas Jain
-
Finding Items in a list basis common properties with another list
I am trying to assign Parent to a particular list in a module(basically identify the parent and then create a new list basis the established parent-child relationship): List 1 List 2: to be used for Parent List List 3: To be created using items of List 1 as child and List 2 as parent respectively The mapping logic is…
-
Implementing Anaplan to Transform Commercial Planning
During CPX 2019, Supply Chain Lead Jordan Hardy and Principal Solutions Architect John Dorma from Twelve Consulting Group, sat down with Ryan Meehan, Director of Finance & Strategy at Prestige Beverage Group, to discuss how Anaplan has transformed the way the beverage company does commercial planning. Today, we're…
-
Organized Dynamic Access Driver Selections
As a model builder, dynamic access drivers can be hard to find when implementing this feature. Anything formatted as a boolean will appear as a possible driver and the resulting list becomes tedious to search through in big models. My idea is to show potential drivers based on the current module on the top of the drop-down…
-
Formula Error Log
As a model builder and workspace admin, formula errors can be costly. My idea is to add an error log that tracks formula and calculation errors. This will help document who was doing what when something goes wrong. It will also help with enablement as you can review the error log and use it for training - ensuring that the…
-
multi dimension module to flat module
Hi Anaplanner, I have 2 module, 1 multi dimension and 1 flat module i want to take data from modul multi dimension to flat, but in module flat data isblank multi dimension module flat module how to module flat have data from multi dimension
-
Fiscal Year End
Hi, I want to get the value for my fiscal year end into a module (Date format) *See picture E.g. For my line item "Currentperiod" I can enter CURRENTPERIODSTART() in the formula field and get 2019-04-01 I want to do the same for when my fiscal year ends e.g. 2018-10-31 (should be dynamic)