-
AnaplanXL & VBA Macros
Hello, I have two questions related to building a VBA macro that uses AnaplanXL. Above is a picture of what I'm building toward, a data grid with several header rows. The color-coded headers are our list dimensions in Anaplan. In this example the yellow cell's value should be the intersection of Dept_1, Line_Item_1,…
-
Anaplan XL Calculations
I am still now to the calculation of Anaplan XL, i would like to get the proportion in terms of value between child vs parent (within the hierarchy) For instance, i want to get the % of each 08S( child) vs the parent value (BL TS), i would like IN general a formula that give the proportion of child vs parent dynamically,…
-
Issues with AnaplanXL background Functions
I am having issues with Anaplan XL messing with some of the standard Excel functions such as: 1. The "marching ants" around copied cells don't show up when I copy cells 2. I get a "could not copy to clipboard" message where you can't copy things out of Excel into say ppt or an email 3. When two workbooks (or even multiple…
-
Anaplan XL - Member Properties
Hi, Where are the member properties for lists defined in Anaplan XL? In the training documentation there is an example showing a property such as “Birth Date”, which appears to be a list-item attribute. That suggests you can create custom list properties from the Anaplan list. However, when I connect through Anaplan XL, I…
-
Dividing (not formating) all the results by 1000
Hello, Is there a quick way, in Anaplan XL to divide all the results by 1000 without creating a measure for every row or every column?
-
Anaplan XL - "working..." on Formula Reports
In Anaplan XL, using formulas to pull data (Xl3lookup), how do I stop it calculating all the time? I'm often seeing this message of "working…" despite not having changed anything in my workbook to trigger that. Thanks, Tom
-
Anaplan XL: About “Use Embedded Workbook Formatting (Preview)” option
We are currently experiencing an issue with the behavior when grid Auto Refresh is disabled. For our use case, it is important that the configured formatting is reflected before any manual refresh is performed. Therefore, we have enabled “Use Embedded Workbook Formatting (Preview)” as a workaround to have the formatting…
-
Anaplan XL Clone
Is there a clone feature? I am looking to duplicate a connection and its data into a new Excel worksheet. The Anaplan Excel Addin allowed this, but I am not seeing it in the new Anaplan XL Clone. Is this feature available in the Anaplan XL? Please help.
-
Design Grid - "simple" Find Member does not exist anymore - only Advanced Search
Hello, I used to find Members in the Design Grid Dialog by typing in a text into the search field and pressing the "Find Member" button. The cursor jumped to the first result within the dimension tree. This does not work anymore. I always get the same dialog as the "Advanced Search" Button. I am using Version…
-
Excel Plugin asks me to log in
Hi, I am trying to create a new Anaplan Connection using the excel plugin. It asks me for an environment and I chose the default one (https://us1a.app.anaplan.com). It then asks me to connect with my Anaplan account but it just says : ———— The Anaplan server returned an error: Authentication Failure. If you're unsuccessful…
-
Anaplan XL license issue
Hello , I recently started Anaplan XL course , added XL however not able to add license How to ad license
-
Problem with the Excel plugin and exiting Excel
Hello, we have a problem with the ExcelAddin 4.4 and Excel 365 for Enterprise. Once the plugin is installed and we open / close Excel, an invisible Excel process remains and doesn't close. Because of this, very often we have the message "Do you want to start in safe mode?" next time we start excel (especially after a…
-
Anaplan add-in for Power Point security issue
Hello everyone I am going through an issue with security when logging into Anaplan via power point add-in. I am a workspace administrator and SSO user. But once I installed add-in for power point, I am not able to login. I am using Universal Login (default) connection and it asks for user name and then a password (not…
-
Excel plugin issue with SSO
Has anyone gotten an error like this when you have SSO and you are trying to use the Excel plug in? We have some users that get the screen below but some don't. We have checked that all users have the same version of Excel. Weird part about the screen below is it actually says the connection was successful.
-
ANAPLAN XL View
Hi, I need help in pulling a specific view in Anaplan XL. The first grid should display attributes of various projects, while the second grid should present the monthly financial data for these projects. Thanks in advance.
-
Anaplan XL Licence has been expired
Hi All, I installed anaplan xl 3 months back but now the anaplan xl lisence has been expired. I want to use anaplan xl only for training purposes. let me know how to re-apply licence key ? from where to find the licence key file?
-
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
-
Anaplan XL : How to writeback
Hello, I would like to know how to Input data from Anaplan XL to Anaplan, the lesson about it only refer to Fluence and not Anaplan … Thanks