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

Deactivating Modules
As Model Builder it would be usefull to have a switch on the module in the model view to deactivate a module We use some Modules manually rare or temporary and the rest of the time they just consume space. (of course external references from outside need to be cut before) Right now i need to switch all line items in order…
Combo Grid with nested Line Items
The new Combo Grid feature in the Anaplan UX is fantastic and a long awaited enhancement, really want to thank the team for it massive effort! I've already redesigned all my dashboards to incorporate it, and the improvement in layout and flexibility and user experience has been substantial. Current Limitation One…
Extend Color Palette (Assets) Functionality to Font/Text Formatting in NUX
The Color Palette under Assets only applies to charts, but it’d be awesome if we could use it for font and text colors in NUX. It’s a bit tricky to remember or copy hex codes every time, and this would make pages so much easier to style and keep on-brand. A small change with a big visual impact!