-
Ability to change the font colour of the data labels for each series.
For better user experience, are we able to change the font colour of each of the series in a chart.
-
Ability to disable commenting on a card/grid
As a Page Builder, I shoud have the ability to disable "COMMENT" feature on a card/grid so as to view all the comments for a context at once in Comment section.
-
Cloud export failed _Cloud works(Azure Blob)
Cloud export failed error while running the clouds works integration with azure blob. Do anyone knows about this error and how to fix it?
-
Levels to show only giving two options, not all levels of a hierarchical list
Probably an easy question but I am working through the level 1 course and it shows how you can aggregate based on a hierarchical list. When I try this on my own model it looks different and there are only two options. My view S01 Is a child of S02 which is a child of S03… S05. I'd like to display only the S03 Level. The…
-
Best practices for technical documentation of a model
Author: Arun Thakar, Certified Master Anaplanner and Vice President in the banking industry. As go-live approaches and admin and end user training gears up, the question of ‘how do we document the model?’ might be front and center in your daily standups. Fear not! This article will cover some of the best practices on…
-
How long to wait for accessing anaplan workspace
Hello, I applied 31 july 2024 for the talentbuilder program(Completed anaway plan already). On the website it says approx 6 weeks. I'm still waiting for approvement to get access on the workspace. Can any admin give me update about the situation?
-
3.4.4 Stock exceptions report
Hi! I created three grids, however need confirmation if this looks ok- because if I apply conditional formatting greater than 0, then all will be in red. Is that correct? Also, how can I not show Safety Stock Flag count field above? Thanks a bunch! -Nithya
-
2.3.9.3 Update Historic Volumes for Baseline Forecast
Hi, I have created a formula for the new LineItem "Offset Volumes for 1st Forecast Year" The formula looks like this IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0 However, I do not see any data for FY19 as shown below but I can see the data for FY20. Can someone let me know that…
-
LEVEL 1 -Part 08 activity- Add Formulas to Line Items in REV03 Margin Calculation_ Error
The formula for Line item Revenue and Cost of Sales line items is not working and giving an error as below. This is from LEVEL 1 -Part 08 activity- Add Formulas to Line Items in REV03 Margin Calculation. Kindly help ERROR: The formula for 'REV03 Margin Calculation'.Cost of Sales is invalid ;REV02 Volume Inputs'.Volumes is…
-
11.3.4 Activity: Add Formulas to Profit & Loss Report Module
Hello everyone, on my activity, the totals for the other expenses are not populated as the same with the should be result in the activity. Here are some screenshots. This is my model: This is the should be: Any solutions to this? Thank you
-
User license types
How many types of user licenses does Anaplan have?
-
Filter forms
Hi All, When creating a form , it would be very useful to be able to filter the line items requested in the form . For example: The form requests the user to enter a month. Instead of the dropdown having all the months in the model calendar, it would be nice to be able to filter to just the current month , current -1 ,…
-
Keeping the column width after expanding (maximizing) the grid
When the grid is collapsed on NUX page, we can decide what is the width of each column and save it, to look e.x. like this: But when I maximize the grid it doesn't keep my formatting from "minimized" view but it has it's own default anaplan view that can't be setup. It results in having header column quite wide (comparing…
-
Delta Load
Is it possible to do a delta load in the Anaplan model? Lets say one flat file is uploaded at 10.00 AM with 5 million records and the same file is uploaded at 11.00 AM with 6 million records. I just want to upload the new 1 million records into my model. How can we achieve that? Thank you in advance!
-
Sum if on a quarter level line item
Hey i need a little bit of help, i want to sum month values to a quarter level value but the dimension isn't really time related its more like converted The right solution would be 7000 in 'New Quarters Value' on Apr 24. May 24 and Jun 24 actually a simple sum if The upper Month dimension comes from a list(property) which…
-
OEG Best Practice: Statistical forecasting
Overview The following is a guide for the Statistical Forecasting Calculation Engine Models (monthly and weekly). It includes enablement videos, practice data import exercise, model documentation, and specific steps when using the model for implementations. 1. Enablement videos and practice exercise…
-
SUM based on Line Item Value
I have a line item that has a list value. In another module, I would like to sum based on that list value -- without adding that list as a dimension in either module. Is this possible? I know this syntax isn't right, but it would be something along the lines of Source.Amount[SUM: IF Source.Line Item = List.Value]
-
Publishing subsidiary views in FluenceXL
Has anyone had any success publishing a subsidiary view line item in Fluence grids? I have a line item in a module that is a subsidiary view used for mapping GLs. I need an end-user to update the mappings. Fluence will not allow me to publish and edit the subsidiary view mappings since the dimensions differ from the…
-
Subset functionality for the versions where we can selective versions by Boolean
Its great to use subsets on the Lists but can we have same functionality in Anaplan versions? Because not all used cases require all the versions as dimension and this also increase the size
-
Percentage format flow when using Line item Subsets
having Line item subsets helps greatly but when we want percentage formatted Line item as the source and want that in Target Module with LIS as dimension the formatting is going away and it only shows as numbers(with no percentages) which shouldn't be the case
-
Ability to input text commentary with text formatting options in Management Reporting - New UX
While working on a project, a useful implementation emerged. Currently in Anaplan, via Management Reporting, it is possible to create documentation that cannot be customised by the user. In fact, the end user using the system can only look at the data and comments previously entered by the Page Builder. We tried creating a…
-
How to do use aggregate value?
Hey everyone, i am stuck at the part where i have to devise a formula for Subtract 1 line item,for that i need the extra value which is 5% in this case ,can be seen in Override-Allocation line item and i need to divide it in those members which do not overriden the values like for LM1,LM2,LM3,LM4 and LM5 which looks like…
-
Lesson 6.6.4
My module looks identical to the example, except for one additional "YTD" column. Can someone advise how to get rid of that additional column?
-
Users are automatically getting deleted in bulk from Prod Workspace.
Users in the Anaplan Prod WS are automatically getting deleted and we are continuously receiving reports of users losing access. When I checked the history, it is showing that these users are deleted by <System User> so we are not able to figure out how these users were deleted.
-
How do I exclude zeros from a MIN aggregation?
I am building an output module to show some statistics around account pipeline by industry. I want to be able to show the smallest pipeline. Since some accounts have zero pipeline, the standard MIN function returns zero, but I want it to return the MIN excluding zeros. How can I do this? Here's an example of what I'm…
-
Send Email without having to push a button.
Hi All, I was working on a support ticketing project. I had the project scrapped because the end user didn't want to hit a button manually to send an email to notify other parties. It would be nice to have Anaplan automatically send emails without having to hit a link with MAILTO(). For example when "ticket status" is…
-
Can anyone share the link for Excel Add-in 4.4 exe file please?
I want to install Excel Add-in 4.4 exe file in my laptop. But I am not able to find out the link. Can anyone share the link for Excel Add-in 4.4 exe file please? Sharing the screen shot of website showing the link for Excel Add-in 4.4 exe file which taken few months back
-
want to know various reasons of UnMapping Issue
I have import csv file. which i mapped to Code to import the Data in to a module. After some when I ran the action its failing . When i checked the import mapping was not there. Want to know various scenarios for this issue
-
Time Spent on L3 Sections
I am planning to start L3 over the next week. Can someone provide a breakout of how long it took them on average to complete the sections below? Any feedback is greatly appreciated! Level 3 Model Building: Introduction Process Flow & UX Design (Time estimate?) Schema Design (Time estimate?) Sprint 1 (Time estimate?) Sprint…
-
Solution Architect Application : Can we still modify the modules ?
Hello Anaplan Community, I have just completed both the technical and knowledge exams for Level 3, and now I need to upload the model history and blueprint. My question is: Will we still be able to make modifications to our model after this, in order to prepare for the Anaplan Solution Architect application? Thank you,…