-
Dynamic Ranking with Native Timescale
Hi, For a customer of ours I'm trying to build a dynamic ranking with the native timescale. The 'regions' should be sorted from high to low based on a fixed line item but on the previous month. Hope there is a workaround instead of manually sorting the values every month on the previous month in the dashboard. Kind…
-
There's nothing on the dashboard
대시 보드 삽입 후 열기 버튼을 클릭했습니다. 그러나 아무것도 없습니다. 뭐가 문제 야?
-
Issue with numbers as text
I am having the below issue with a number as text. it needs to be displayed as text, for posting into another system. in the attached, in IA local I am just using TEXT(ROUND('Investor Amount (Local)' * 100, 0) / 100) but as you can see on one line I get the number displayed in an odd format. I have tried rounding all over…
-
Certified Master Anaplanner Sarah Roberts—Harnessing the Power of Anaplan
Certified Master Anaplanners are Connected Planning pioneers, building industry best practices and shaping the way Anaplanners everywhere utilize Connected Planning solutions every day. They understand the possible and are passionate about helping set the direction of the platform. Certified Master Anaplanner Sarah Roberts…
-
Mailto function won't open Outlook / Mail app
Hi community, In one of our models we frequently use the Mailto function. When I click the link, a new tab opens in chrome but Outlook doesn't open after. When my colleague clicks the link the Outlook does open. Pop-ups aren't disabled in my Chrome settings. Has anyone encountered this issue before? Thanks
-
Capture New Data From Your Users with Forms
Creating new list items and capturing data against them forms a critical part of many planning processes, especially those that seek to democratize planning by engaging end users in a wider range of planning activities. Forms are a new input mechanism added to the Anaplan UX that allow you to create simple, intuitive input…
-
Support of basic excel functions like RAND, RANDBETWEEN, RANDARRAY
It would be nice to have these Random number generating functions. These functions revery useful to generate some test and demo data, rather than inputting numbers and copy forward or importing from an excel. Can all be used for other purposes that I can not think of now.
-
Summary method shown when drilling down
I suggest a simple addition to the drill down feature that displays the summary method that was applied to the line item. This is because it is sometimes not readily apparent (especially to an end user) how a top level summation has been calculated.
-
How to show only write accessed items in a line item with list format .
Hi , I have list with selected access .A user has write for 4 list items but read for all items . There a line item with list format ,in the drop down user can see full list even though user has write access to only 4 list items . Any suggestion ,how to make it happen that user sees only 4 list items to which he has write…
-
Information for a Line Item Disappears when in Top Level
Hello, Good day! I hope every one is having a nice day. I would like to ask for any information that may help in troubleshooting this issue. I have a line item in a module called, "Credit Account". I have it in formula which basically says: If the Company is 'A' then use account number '12345', ELSE, use '67890'. This is…
-
How to make Date as a Display name in a Numbered list?
How do you make a Date as a Display Name in a Numbered list? I added a formula into my list properties with the format set as Date and the formula referencing the numbered list and the Date field. It pulled in the number properly to the Display Name. However, the new item created in the list is still a random number and…
-
Update Target Object of Import Actions
Hi, It would be nice to have the ability to update the Target Object of and Import Action to a module or list with similar/identical definitions vs creating new actions from scratch. We have come across instances when building out a model we determine that an already created Import Action needs to have the source data…
-
How to create a comparative analysis model using lists?
Hi Anaplanners, I was looking into ways to create a model that allows end user to perform whatif analysis and compare the results (end user can choose multiple scenarios to compare). The user can select which version to compared via a list (list may contain members: Budget, Forecast, Forecast 1, Forecast 2, Forecast 3). Is…
-
Formula Summary
I have data formulas like this. How do you change SUM to Formula in summary. So Growth Calculate on Summary Level its wrong.
-
Quick verification of ongoing model health
My client is asking what checks their maintenance team can do to evaluate model health. I've come up with this list, am I missing anything? * Can you log into the model? (verify SSO functions and that the model loads) * Model load time and responsiveness (request model health report from CSBP) * Are users active in the…
-
LOOKUP does not work on list parents and only leaf items
When a LOOKUP is done on a parent item in a module, the result does not resolve to the column with that respective parent. Subsequently the value shows 0. To reproduce: 1. Create list with leaf item and parent 2. Create module with column 1 as "Data", column 2 as "Parent", and column 3 as "Lookup", using list from 1. as…
-
Filtering a list based on a property
When in a list grid view, enable a list to be filtered on a property. This is only possible by creating a module using the list and creating line item linked to properties.
-
Parent-level Commenting with Line Items Pulled from One Module to Another
I have a question about parent-level commenting with line items pulled from one module to another. There are line items in module 1, which are pulled into module 2 via subset and transposed into rows. In the screenshot, you’ll see ‘Salaries & Wages’ is the sum of ‘Salaries’, ‘Overtime’, etc. There’s a ‘Key Highlights’ line…
-
Search Option while Selecting Lists for Module Dimension
There should be an option to search lists while applying to modules. In our use case, we have too many lists/subsets to scroll and select the appropriate one. Changing a dimension is even nightmare when multiple lists are applied to the module. Ideally, It is should be similar to how we add actions to a process ( Click and…
-
Excel user defined functions
If my Excel model has user defined functions, ie multiline VBA functions that are called by worksheet cells, can Anaplan handle them? I could not find anything about them online thank you
-
Open modules using 'Referenced By' column
It would be really helpful if the 'Referenced By' column opened all modules associated to the line item (similar to clicking on a functional area name to open all associated modules). This could be achieved by SHIFT+LEFT CLICK to differentiate from selecting the cell rather than following the hyperlink. This would be…
-
Deactivate Formula Scope if Versions = Not Applicable
Hi, In a module blueprint, there is a field called 'Formula Scope'. For modules where Versions = Not Applicable, using 'Formula Scope = Actual Version' or 'Formula Scope = Current Version' will nullify the calculation of any formula in a line item. This is potentially dangerous, because: 1. If there is a formula + Formula…
-
how to change the order of dimensions in " Applies to" ?
Hi, I want to apply the best practice of ensuring consistency in the order of dimensions, as described in following article: https://community.anaplan.com/t5/Best-Practices/Dimension-Order/ta-p/32934. However, when I apply the steps to change the order, nothing happens. What am I doing wrong?
-
Error : EMP02 - Dimension of mapping used for lookup doesn't match any dimension of the result.
Hi Experts, Please help on the below mentioned issue while adding formula for Bonus, Car, Phone costs & Medical costs to the EMP02 Module. BonusIF Employed? THEN Salary * 'EMP01 Employee Drivers'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Country] ELSE 0Car costsIF Employed? THEN…
-
First non Zero
how to get first Non zero number as summary if lineitem is dimensions with list
-
List Inheritance
Where lists are in a hierarchy, it would be really helpful if Anaplan natively understood the concept of inheritance. Here's an example. Consider two lists in a hierarchy: * L1 Countries * L2 Cities L1 Countries is the parent to L2 Cities. Within an attributes module, each L1 Countries list item is assigned a currency.…
-
Reduce row label right border
Please can the right border/margin be reduced in row labels. The current border cuts off text too far from the cell border, below is an example. Whilst minor, this would just be a very quick fix to implement and would (slightly) improve visuals. Here you can see that the words revenue are being cut off too early, even…
-
Improve List Item Deletion
Improve the list item deletion within Anaplan so that if a model builder selects 'Delete All' from the delete dialogue when there are vast numbers of list items the model builder is prevented. Doing so would prevent model and workspace lock ups. To explain this further: Consider a list with 1,000,000 items. If you attempt…
-
Add Sort Selected On Reorder Dialogue
Can a 'Sort Selected' group be added on the reorder dialogue, similar to the 'Sort All' group shown below. This would help with organisation in models, most notably where you want to order numbered modules, but only in a specific area of your module list. The group would have a similar function, but as indicated would only…
-
Question about the February 22, 2020 Upgrade - ALM Restore Points & Documentation
Hi everyone! I just reviewed the changes in the 2/22/2020 upgrade - thank you for these and for working Saturday to implement! I had a few questions. I was hoping someone could answer these. @VickiA maybe you can help. ALM Restore Points For the ALM restore points, I wasn't sure what was the change. In testing this out, I…