Extensions

Today I appeared for an interview, they asked me:- What is an Architecture of Anaplan? I wasn't able to reply. Someone please help me with this question.

hi, we've got users who have been asked to increase the security of the data they hold. They currently use Excel Add-ins, and tried putting password protection onto their spreadsheet. However, the data uploads failed with password protection activated (even though they'd already opened the spreadsheet with the password).…

Hi all, I am having an issue that seems to be a result of the new v3.2 add-in update. Previously, where boolean values were being pulled from the excel add-in, excel would automatically recognise them as general formatting and they would be activated and process the cell as a boolean. Now it seems the values are being…

Hi, How can we restrict the users having modeler access so that they should not be able to add users to the workspace except a few ? The user addition access should be given to few users and restricted for others. Is there a way to do it ?

So for the HR Planning Costs dashboard there is a module where you can input social security, pay raise % and pay raise date and that module affects the details of each employee module. Is there a way where the social security, pay raise % and pay raise date module does not affect every employee, whereas I can choose which…

Hello, * We are struggling to download the Microsoft Excel Add In - when trying to do so we get the following message:* The Anaplan Excel Add-in requires Microsoft Excel 2016 or 2013 or 2010 (32-bit of 64-bit) to be installed. * This is misleading - the documentation states that Office 365 is supported…

HI, even with page builder access/workspace admin access I am not able to see the new UX option in menu Is there anything i am missing?

The newest version of Excel add in doesn't work with Office. Every time that the notebook is restarted, the Excel tries to load the add in and it crashes. I had to uninstall the add in because of this issue

Hello, How can I have a formula calculate data for a specific member of a dimension and place a 0 for the others? 500error thanks iosman

Hi all, I am getting the following error after trying to refresh data after connecting to a module through the excel add-in. "Refresh failed. The required name range could not be found." I am using V3.1 and have never had this issue before. I have done some testing and it seems there is something wrong with the name of the…

Hello, Does anyone now whether it is possible to either import or export data directly into a microsoft analysis services cube through the data utility tool? best cheap cordless vacuum thanks iosman

Hello Can't see how this was done in the allocations video. I have a list for products, and a line item for sales. I want to introduce a line item that returns the total sales for all products against every product. 0x80070490 Beyond allocation use, is there a way to introduce a line item that returns the value at the next…

We are building dashboard with workflow, where user approve/reject demand plan, would like to keep system date so that we will know when user made changes. It would be great system default date and time can appear there. Thanks,

Hi everyone, I created the chrome extension Anaplan Formulator to make long formulas easier to read in the native formula editor. The extension inserts a return before and after each IF, THEN, and ELSE in the formula. Please take a look and let me know what you think! Thanks, Ryan

On a dashboard, you may want to hide or show additional rows or columns. If you make any changes to your selections, and close the dashboard, your changes will be lost. In order to save changes to selections, you can go into Page Selector Options, uncheck the 'Show module name' button and click 'OK'. Then go back in to…

Hi Anaplan, It would be great if Anaplan developed a Smart Sheet Add-In. This is a great alternative to presenting data in excel due to browser based flexibility and functionality of Smart Sheet. Thanks, Usman

Hi, I used read access driver and write access for a line item to get the dynamic cell access. (calculation formula is used to get the data for this line item) . 1)It is not working though I used DAC concept 2)Quaterly data is also not displaying for that line item though I changed summary items to ALL or ANY from None.

Is it possible to setup an action where a report export to xls loops through all territories and saves a separate file?

Hi, I'm working on the UX section of the introduction to modeling, and I cannot get the headcount module to populate with data when it's on the dashboard. Interestingly, there's data in the module itself and when I publish other modules to the dashboard they also show data. What could I be doing wrong? Thanks for your help…

When establishing a connection to a saved view in Anaplan that contains conditional formatting, Is it possible for the PowerPoint add-in to pick-up the conditional formatting as well? If so, can anyone please provide guidance?

HI All, I would like to learn more about Rest API connection with Anaplan. Consider my knowledge in this is 0%. Can you guys please share your thoughts or it would be great if you attach some files as well. Thanks in advance!! Kavin.

Description of the enhancement required: In powerpoint add-in* REFRESH button it would be great to have option to select which graph or table to be updated rather than update all. Because if I want to update only one graph it is tedious to go through edit components. An example of the enhancement: Right click on the…

A description of the enhancement required: Would it be possible develop a "AnaplanRetrieveData" formula for the Excel Add-in, where you can specify all necessary input from excel and the formula then returns the data point. An example of the enhancement: Formula in Excel would be: =AnaplanRetrieveData("Workspace…

I am wanting to set indiviudal conditional formatting rules for each row in a table on a dashboard. How am I able to do that?

Hello Friends, Can someone help me about what types of Anaplan Certifications are available? Are all of them chargeable? And what is the minimum cost for any Anaplan certification? Thank You. Regards, Sammy.

Good afternoon, I am trying to upload a file using Anaplan connect. When running the batch, the windows prompts me with a password. However it seems that I'm not able to type anything for whatever key I press on the keypad. my script : @echo off rem This example loads a source text file and runs an Anaplan import into a…

Hi all, We have several different models in the Anaplan tool created for our company. The models are built for several different business units and different countries. When you are a specific user from one unit or one country, you see the correct data. When you are a super user (not admin/anaplanner) and you have access…

Will the Excel Add-in v3 or later ever support Excel 2016 in Office 365? If not, is there a fundamental reason for that? Regards Dave Easey

Hi All, I've seen my question answered in bits & pieces, but hoping someone can give me a comprehensive walk through... My team is looking to build modules that will automatically assign current period reporting so that we can leverage the excel add-in with minimal human manipulation - really just looking to hit refresh…

Description: Excel Add-In: When refreshing report views, rather than changing the tab color upon refresh, please leave original tab color. Benefit/impact: We use tab color within an Excel workbook to differentiate financial reports for management. We also use it for organization of data.