Anaplan Excel Add-in

Hi all,

Following a member's recommandation, i'm posting 3 main ideas. I have recently discovered Excel Add-in existence and here are the 3 major points in my mind :

First, I think it could be nice to be able to give only permission to retrieve saved views in order to prevent them to see technical items (not relevant as end-user).

Another way could be flagging technical items as a model builder and then, as it is marked up as a technical item, it will not appear in Excel when selecting a view (saved or not), and why not going further saying that it will be automatically go out of the UX.

Then, we all know that controllers (I used to be one of them ) enjoy working on Excel and it would be user-friendly if they were able to get in Excel cells the filters (dimensions) so they would be able to create an excel sheet in which they will set the parameters (Year for instance) and then do the link (through basic excel formula) directly in the filters in each work sheet (as below)

Last but not least, It would be nice to develop a bit on formulas that can be used thanks to Anaplan Add-in.

For instance, the formula below retrieves the dimension needed (French Excel, equivalent in English is choose)

Some of the key users may want to develop their knowledge to develop the Excel templates.

Feel free to share your opinion, I will be glad to discuss with you !

Thanks,

Nicolas

Comments

VeronicaP

Hi, here is some feedback on your points:

1) have you tried to use Role-based access? you can use it to hide data, calculations or system modules to your end users in the Excel add-in.
2) From the settings, you can add the dimension name applied to your module as text in the cells of the sheet

3) can you provide more context as to what you are trying to achieve?

nicolasgrd

Hi @VeronicaP,

Thank you for your inputs.

For the 1st point, I'm not aware of anything hiding line items (and not modules) to a specific user's category, I will try something about it but not confident it will work.

Concerning the 2nd point, my settings do not allow this but maybe I am not looking at the right place

For the last point, I would like to know if any other formula exist to update quicker (and without passing by Anaplan) the reports.

Thanks,

Nicolas

VeronicaP

Hi Nicolas,

on point 1, have you already tried with Dynamic Cell Access? would it meet your needs?
Point 2: try clicking "Show or Hide connection details" which is the last setting from the screenshot you shared. Let me know if this is what you needed.
On your last point, our add-in allows users to send cell value changes from Excel into Anaplan, but this concerns only input values. So unfortunately you cannot edit any metadata or line item formula of a module from Excel.

Quick Links

New ideas

Enable MFA for External Exception Users & Allow Multiple SSO Configurations per Workspace
As an Anaplan tenant admin, I want to enhance security for external users who are added as SSO exceptions by enabling Multi-Factor Authentication (MFA) for their accounts. Currently, these users authenticate with only a username and password, which poses a security risk. Additionally, I request the ability to assign a…
Limited Cross-Workspace Access to Archived Models
In Workspace A developed a model called XYZ2025, which was archived after the fiscal year ended. Months later, a regional team in Workspace B wants to use that model as a foundation for their XYZ2026. Here’s what happens: Workspace B cannot directly access or import the archived model. Workspace A must unarchive the model,…
UX Customization (negative sign): bracket or - (sign)
Hi All, Recently I have seen great customization to UX (numbers to percentage), it was really good when it comes to line item subset (combination of numbers/% value). It would be good if we are able to customize the negative sign in UX, as management would prefer to view numbers (if negative used bracket), % value (if…