-
Memorialize Actual Data in Historical Planned Versions
Hello, I am currently running into an issue with one of my models where historical plans are changing due to actual restatements. I have a model with 4 versions. Actual, Budget, Working, and Current Forecast. Working is where all of the planning is done, and then that version is copied from working to current…
-
Formula to display values from the page selector in a column
Hi, I need to be able to display the page selector value in a column. The purpose of the module is to assign multiple positions to an order. If it had been the other way around (assign an order to position) I could have used an "assign" action, but, now he task is to do it this way. I need the order column to display the…
-
Adding Un-editable Note in Export Action
There is need of adding a disclaimer/note in the first cell of file. How to add that cell in the exported file.? and also that disclaimer should not be editable in Anaplan model when another file is imported with different disclaimer.For Reference: I Have attached a Screenshot. Employee(Column B is the List), Comment and…
-
Reporting
This is the module I have. Now for the output is it possible to get the report of the module edited into the below view without editing the list name. I have no restrictions to create a new module or new list.
-
HELP! Anaplan not working
I'm having issues using Anaplan through excel. I log into Anaplan through excel and I then click on New to open a new pivot table. At this point, a message appears just below which says "This worksheet does not have a connection to Anaplan." A second window opens but the window is grey and nothing seems to happen. Has…
-
Anaplan v3 Connector for Mulesoft - Doest the connector refresh token for subsequent API calls
Hi All, I know that Anaplan V2 Connector for Mulesoft does the token refresh for every subsequent API, but has this behaviour been inherited in Anaplan v3 connector, because we are seeing Anaplan throwing error for subsequent calls made for import via the v3 connector. Regards, Praveen R
-
Anaplan Connect Error 1.4.3
Hello, We've been receiving the below error on one of our export scripts. This happens about once or twice a month and there seems to be no rhyme or reason for the failure Has anyone seen one of these errors before?
-
Format of output
Hi Friends, I am having the data in this format. I tried it in excel but I am getting the output in the below format. Even making States as List Formatted Line Item didn't work. By any chance can we get the output in the format of Pic 1
-
Funtional Area
Hi, Is it possible to have a sub-functional area to be shown in the Content Panel? Example: Function A Sub-Function A.1 Sub-Function A.2 Function B
-
Importing issue
Hi Members, Please help me in this import error. The original file: The original module: I am trying to fill the Role Column. Importing error.
-
How to find overall total
I can see subtotal but not overall total. Please assist me in this.
-
Anaplan Connect Workspace to Workspace
Hi Anaplaner, Can I use anaplan connect to import data from workspace to another workspace ?
-
API export with a filtering parameter?
I have an API process that pulls data from a module that includes the Users dimension. There may be multiple users in the system concurrently and I need to keep their data separated. I need to filter the export from this module for a specific user -- the one who clicked on a link URL on an Anaplan dashboard to initiate a…
-
Error : Anaplan API: Could not connect to database! (SQL: No suitable driver found for
Hello, We are currently of migration from Anaplan Connect 1.3.3 to 1.4.3.When we launch our .bat, we get the following error message: Could you help us about this error message ? Regards,
-
Anaplan Connect Upload Error
Hi, This is the first time I am using Anaplan connect. While creating the script and looking at the documents, i drafted a script that allowed me to first upload, import thru an action followed by lastly a process. I have apparently uploaded the file successfully however I am met with problems with my action that imports…
-
Test Automation of Anaplan Application
Hi, We are trying to perform test automation on Anaplan. We tried using HP UFT and Wroksoft Certify tool. We tried to capture objects as it is done on a web application but We are not able to identify the objects. Can anyone please provide inputs on what platform Anaplan was developed (e.g.Java, Silverlight etc.). Thanks…
-
Excel Add-in 3.2 vs. 3.3 vs. 3.4
Dear everyone, I am part of the IT organization at my company, and I am responsible for the Anaplan environment from am IT perspective. We are currently using the Excel add-in v. 3.2, which meets our organization's requirement to control the data in Anaplan (read only, not write-back). My organization wants to keep the…
-
Imported data automatically multiply with 100
Dear everyone, My company is in the 1st stage of building Anaplan. Recently, we've managed to automate the process of data integration which is to import data from our server (Microsoft AX 2012) into Anaplan. To be simplified, we have 2 step. Firstly, a batch job will download data from server (pre-scheduled) to a local…
-
Data Import from excel
How do I import an excel data grid with no unique ID and no unique combination of property? Note: Customer is looking for keeping anaplan as system of records and wish to generate a unique ID within Anaplan, but key thing is it has to be a import/ not insert using dashboard. Thanks Arun
-
Update the Data in Current Module
In my current module which is dimensionalized by a numbered list I added additional 4 line items .. and I have a csv file based on which I want to update my current module. However, the dimension is a numbered list and display name has a logic to it. I have lot of other keys which can be unique to update the data, however,…
-
User Permissions in Excel add in
Hi, I am an admin and I want to create an excel file for users that have different list permissions. When another user opens the file they can still see the data for all the list. Is there a way to restrict this? Thank you
-
Does The Anaplan Way (or Agile) require a traceability matrix?
Hello, More of a methodology question than an Anaplan question. Is a traceability matrix required or a part of The Anaplan Way (or Agile)?
-
Using Python's statistical capabilities to Manipulate data already in an Anaplan Model
I want to leverage Python's statistical capabilities to manipulate data already in an Anaplan model. Has anyone done this before / had any experience with this? I know I can use Python as a data integration tool, but would like to also use it for calculations.
-
Anaplan Connect - Export via JDBC
Hi guys, This is my first time really getting to grips with Anaplan Connect and I'm trying to PoC exporting out a simple table of "Region Name" & "Region Code" using Anaplan Connect via JDBC into a SQL table. My scripts are as follows: ---------.bat script----------- @echo off rem rem rem set…
-
Upload - Non Mapped Source Items Identification
Hi team, Is there a way to identify Source Items in a list that have not been mapped to an item in the target for a Upload to a module in Grid Mode? I am aware you can manually identify the non-mapped items by scanning the Mapping tab but this seems inefficient and error prone (especially with large data sets). When you…
-
Free S/MIME certificates to authenticate and use Python with Anaplan
Hi, I want to use Python with Anaplan. To do this we need to authenticate with either certificate or basic encoded authentication. I don't really want to use the latter as it's not as secure as Certificate authentication. I can see I need a S/MIME certificate to authenticate with Anaplan's API. Does anyone know of any free…
-
Data fields are offset when retrieving data in Chunks via API
I'm retrieving a large export via the API and because of the size of the file, Anaplan breaks up the export into multiple chunks. The issue is the column structure in the first and last record of each chunk isn't consistent. For example, in the attached image, the first chunk ended on the first row mid-way through the…
-
Download A File Using API V1.3 - Do I Always Need to Delete File First?
Hi Anaplanners! I finally have gotten around to asking this question that's been bothering me since I started using the APIs to download a file. I get inconsistent results when I test this on my own so I thought I'd ask the Community. The use case: I want to download a file (export) based on a view from a module using API…
-
Hyperconnect read and write to SQL database
Hi, I've been researching this and could not get a definitive answer from either here or the Infomatica forums. Can Hyper connect read from on-prem SQL tables, import into Anaplan, and write back to on-prem tables in a SQL database?
-
Anaplan Integration & Anaplan Connect
Hello Community, I'm reaching again support for some questions I have, some of which may appear silly for some experienced users. I've been trying to find an easy way to obtain Action's ID in Anaplan as those are used for our B2BI integrations with other ERP and EPM systems. Initially, I thought I can easily get them from…