-
How I Built It: Number format converter (thousands and millions)
Hello Anaplanner Community! I’m excited to participate in another ‘How I Built It’ video with a Number Format Converter (thousands and millions) tutorial. This video walks you through how to dynamically update UX grid number formats on all tables and charts. This enables users to have different number formats enabled for…
-
Is there any way to see if a line item subset has been used in a version formula?
We're looking to do some tidy ups in the line-item subsets and couldn't see a way of easily identifying if the LIS has been used in a version formula only. Nothing shows up in the "Referenced in Applies To" and "Referenced as Format" columns. Apart from going into each module and checking, is there any other place/method…
-
License Admin
As an administrator I would like to be able to control the use of licenses across my organisation by applying a limit to each license type. e.g. if we have 20 model builder licenses the system should stop workspace admins from assigning more than 20. I would also like to see something in Tenant Admin which would advise us…
-
Planual Explained - Day 5
Rule "1.05-03": Article 1, Chapter 5, and Rule 3 – “Avoid using List Properties” List Properties are same as line items but have many limitations, so keep it simple and have one place for calculations i.e., Module line items. This goes against P and A of PLANS if you wish to create list properties. Here is how it was done…
-
UX comments per each individual cell
Many of our clients would consider to use comments feature if they could publish them of each cell in a table. Use case: Any outliering value would always be questionable and would require additional investigation of route case including history check and any comments anywhere. Usually it takes a lot of time for RCA while…
-
Ability to input text commentary with text formatting options - New UX
Currently we have an instance were business users are required to provide commentary to forecast data every month, for board presentation. However, if we publish the line item (with text format) on the page using a KPI card the user is unable to do line break or any text formatting, but rather text content comes out has…
-
More dashboard formatting options (bold grid lines)
Description: When publishing a Dashboard, we would like to have the option to modify or customize the thickness of the borders to better segregate the line items from each other. We want the ability to add bold borders, hashed borders, double borders, etc. Benefit/impact: The border must be able to surround the entire…
-
Group/ungroup columns/rows in New UX
Please, add a possibility to group columns / rows, like in Excel.
-
Ability to Change Field Card Text Color
Would be great to be able to change the text color on field cards.
-
Change Color of Global Context Selectors
In the new UX, you can change the color of context selectors when they appear on a specific card, but you can't change the color when it is a global selector at the top of the page. It would be great to have this flexibility. It would also be great to set a default value that would carry through the every page so you don't…
-
Ability to copy page access from one role to another
in the contents panel of the modeling experience, you are able to copy access from one role to another for access to classic dashboards. This means that if you have to create a new role that is similar to another role, you can copy and paste the access settings as a baseline. In the new UX, you lose this ability. You have…
-
Default / Global table formatting presets
would love to be able to set default/global formatting for tables in the new UX. This would include: font text color column/row shading time summary shading / text color etc. This would make it a lot easier for admins to build and maintain their tables.
-
Keep time summary formatting when pivoting
We set up time summary formatting for one of our tables - we have the background black, and the font white. But when we pivot the table so time is in rows, the white text formatting gets reset to black and becomes impossible to see. Would be great if it could keep it's formatting after being pivoted.
-
I NEED HELP ASAP
Hello, I have already a production model and i need to create 2 models X and Y . The X and Y models should be deployed and linked to the production using revision tags. Therearefore, i copied the production model twice. But when i pass a revision tag in the production i can only synchronize the Y model ( because it is the…
-
April 2024 Community Member Spotlight: Kirill Kuznetsov
This month we are thrilled to feature @KirillKuznetsov as our Community Member Spotlight! Kirill has been active in the Community since 2017, a Certified Master Anaplanner for the last four years, and is currently a Community Boss. You can find Kirill supporting members with answering questions (he has over 570 comments!),…
-
Speedometer / dial gauge Chart
We have been getting an increasing number of requests to implement a speedometer chart on Anaplan, but due to it being unavailable, reporting on Anaplan is losing some traction, with reports being created on Power BI instead. I hope this chart can be included in Anaplan in the future as it has a few key benefits. Instant…
-
ALM enabled between 2 Dev models linking to the same Production Model
We have the usual setup of DEV → UAT → Prod copies of a model. We've took up a model optimisation activity which would involve deleting redudant models, changing dimensions, and changing logics. all aimed at reducing size and improving performance The bottle neck is that this activity will go on in parallel with the…
-
Improve the Search bar
Can you please improve the Search bar engine in Anaplan? The Search engine should reduce by itself the ' ' (primes) Also Ending/Starting Space bars which happens in copies should get reduced automaticly or ignored in the search. I always have to modify at first the search string before the search is intelligent enough to…
-
Median function/ Median summary method
Please can we have a median function or summary method. I appreciate that you can get around this limitation using Rank() but in my experience the work around is exceptionally computationally heavy and you cant Rank() over time which further complicates matters.
-
Integrating POWERBI to Anaplan
Hi Team, It will be helpful if we have a connector / integration enabled to get the data from PBI to Anaplan. Thanks, Aish
-
Percentage comparison to previous year/month
Hello, i would like to have a comparision to a previous month or year on my KPI card. Is something like this possible?
-
What have you found to be the biggest roi in terms of model optimization?
I have a very slow model that I want to start optimizing. There's obviously a lot to do. Anyone have any great success stories? What did you do? Where should I start?
-
New UX - wrap text for rows' headers
Hi team, As an admin user I would like to have the ability to enable/disable function to wrap text for not only columns but rows labels (line items or list items) as well. Sometimes names may be very long, so then I will be able not to extend rows headers significantly to make labels fully readable, but will enable this…
-
Power BI Enhancements/Limitations
The following will be primarily based on my recent experiences with the Power BI Connector and Anaplan. Positives: 1. The Authentication has much improved and the use of SSO relieves a lot of data concerns when creating Power BI Reports. 2. Able to run multiple exports into the same model Negatives: In my experience and…
-
Anaplan Bulk API Exports (Line Splitting on last row of chunk)
Exporting a file that ends up having over 100 chunks. The first and last rows of the files are split across different chunks. Is there a a way to prevent this?
-
Conditional Icons for KPI Cards
For KPI cards, we can set up conditional formatting, but it only gives us the option to set a dot/circle next to the metric. We want the ability to have icons appear in this space. For example, if a number is positive, we would like to have a green up arrow, and for negative values a red down arrow. This would be a great…
-
Ability to change number scale for charts/graphs
We need the ability to set the number scale as Millions/Thousands in our charts, similar to the functionality that exists for KPI cards. We also would like the ability to choose how many decimal places are shown when something is displayed as Millions/Thousands. I know we can set up a calc in the back end to divide the…
-
NUX KPI Card Scaling Decimals
Today, when selecting millions or thousands for KPI cards, they default to 2 decimals or 0 if it rounds up to the thousand/million. It'd be great if we could customize the number of decimals we see on the KPI cards & keep it consistent on the boards. For example, depending on the size of the business, having 1 decimal…
-
Re-order context selectors on newUX card
Hi - we need the ability to reorder context selectors on a newUX card. Right now, the functionality only exists for global context selectors (i.e. at the top of the page), but we need this for the individual cards too.
-
Optimizer Problem: Line Production Allocation by Production Plan
Hi All , I am having issues using the optimizer for production allocation. The model is for capacity planning. Problem statement Need to allocate the SKU demand to compatible factory lines based on the following logic. Each SKU has a production priority and a factory line priority. If the production priority for a SKU is 1…