-
Addin crashes Excel
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
-
How do I have a forumla calculate data to a specific dimension member?
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
-
Excel Add-in Error - Refresh failed. The required name range could not be found.
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…
-
Direct link between anaplan and microsoft analysis services cubes
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
-
How do I sum across dimensions other than time?
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…
-
System Default date
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,
-
Google Chrome Extension to make long formulas easier to read
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
-
Saving changes to selections on a Dashboard
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…
-
Smart Sheet Add-In
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
-
Read access and write access driver query.
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.
-
Separate Report Export per Region
Is it possible to setup an action where a report export to xls loops through all territories and saves a separate file?
-
Introduction to model building UX Dashboard Not Populating with Data
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…
-
PowerPoint Add-In and Conditional Formatting
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?
-
How to Integrate Rest API with Anaplan
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.
-
Powerpoint Add-in: Simplify option to update specific graph/table
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…
-
Ability to use retrieve data from Anaplan in Excel using a formula
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…
-
Multiple Conditional formats for different rows in a table
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?
-
Anaplan Certification Types
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.
-
Anaplan Connect - Cannot enter password
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…
-
Login As a User Feature
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…
-
Excel Add-in v3 and Office 365
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
-
Best way to set current period (month/quarter/year)
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…
-
Don't change tab colour when refreshing view in Excel Add-in
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.
-
Dynamic Subtotal in the Excel Addin
Hi gang, Very interested to have a dynamic subtotal in the Excel Addin please. So lets say I select several items in a product hierarchy or just two out of my 3 channels. Here I would like the API to refresh the subtotal of these items instead of pulling in the explicit rows/columns selected. There would need to be a…
-
Excel Add In v3 - Install failed with "Install Visual C++ 2013 Redistributable"
I've tried installing the add in several times with the same error - "Product: Anaplan Excel Add-in (Single User) -- Please download and install Visual C++ 2013 Redistributable option "vcredist_x86.exe" to proceed." I've downloaded and installed the C++ package, both x64 and x86 versions (PC is installed with Windows 10…
-
Anaplan Connect to MS Access
Hi All, I am trying to use Anaplan Connect to import data from MS Access table to Anaplan list. The table has only one column containing list values. I have created Anaplan import action based on text file with similar structure i.e. one column file. I create jdbc.properties file as below jdbc.connect.url=…
-
Excel Add-In: why I have to add COM in every time in Excel
Hi Everyone, Anyone knows why each time when I open the Excel, my Anaplan Excel Add-in check box is lost? I have to manually add it back in, by clicking the below check box "Anaplan Excel Add-in"? How can I make it there always available by default? It worked for me in the past, but did not work now since I upgrade to…
-
Issue logging into Anaplan using Firefox
Hi Team Am not sure if this is the right forum but could not find one for general discussions. When I log into Anaplan using Firefox, my machine drastically slows down. it does not happen while using Chrom or IE. Any one experiencing same.
-
Saving document Errors when using PowerPoint Add-in
Hello - looking for some answers to an issue we are seeing when saving using the Power Point Add-in. This does not happen all the time and we can not determine the cause. Once we have created our slide and done work to format the information in the proper charts and may have been able to save previously, we begin to get an…
-
Maintain/Adjust number formatting
Hello, While using the add-in and refreshing a view, is there any way to maintain number formats through the refresh? I currently have a number of views that show varying cuts of an Income Statement. Included in this are rows for Revenue, Costs, as well as GM percentages and OpEx Cost to Revenue Percentages. When…