Data Integration

Period Mapping error while importing data between Module
Hi, Import data Between 2 Modules, I have been getting error for period mapping. Please let me know on what needs to mapped for time period Note: Here Time range is been used. and Time Scale is Month Thanks Asha
Hierarchies with numbered lists
I'm trying to create a list where: (a) There are two levels in the hierarchy, let's say "Level 2" and "Level 1", where Level 2 consolidates up into Level 1; (b) Level 2 and Level 1 are both numbered lists with a display name property (c) The members of the lists will be added to over time, and I want to update the members…
How to throw an error when all fields are not populated in a DB and user clicks a button
Hi, I have this table in this dashboard where a user needs to enter in these mandatory fields in order to save this data into a "history log", which is a separate module. How can i make it so that if all three of these fields are not entered in, when the user clicks the save button, it will throw an error? Right now I have…
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
Anaplan connect log files
Hi All, Is there any way to structure the logs generated by Anaplan connect in text file, It looks very wage and difficult to understand.
Anaplan COnnect Inquiry
Hi, I just want to know. If your transporting data from 1 model to another using Anaplan Connect API. How would you be able to do that? I am familiar with the Anaplan Connect API importing csv to Anaplan Model base on the script below. I checked the documentation pdf of Anaplan Connect and there is an option there for…
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
Script to export General List
Hi I am looking for a way to programmatically export the data from a General List to my local server. Any help here would be appreciated. Thanks Regards Prabakaran
Anaplan Connect 1.4.1 inquiry
Hi, I just wanted to ask is there any available sample script using the new 1.4.1 Anaplan Connect? I was able to run successfully Anaplan Connect 1.3 but I am having problems with 1.4. I just need to see a sample script so I can apply it on our Project. Thanks,
Change the name of Excel Sheet during export
Hi all, I search to replace the name of Excel sheet when I export data (by default "Sheet 1") Someone has already done that ? Thanks in advance for your help!
Anaplan Connect - Export Script
Hi, I am getting the following error, followed by a list of options in my command prompt window when i run my export batch file. My batch file is as follows: @echo off set AnaplanUser=XXX: set WorkspaceId="XXX" set ModelID="XXX" set AuthUrl="https://auth.anaplan.com" set Operation= -export "XXX" -execute -get "XXX" rem ***…
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…
Defining the default file for imports
Hi Is it possible to specify a default file for some import actions in Anaplan, so that whenever the user clicks on the action, instead of asking the file to upload "choose files", it automatically looks at a specific place for a specific file and runs the import?
How to bring in previous balance into current module? Or how do I bring in a rolling balance forward
I am creating a balance sheet. I am hoping if anyone can show me the best approach. I have two module. Previous balance module and current Balance sheet module. My previous balance module have no time scale. I want the previous Ending balance in my current module. I attached 2 screen shot to show you what I mean. When I…
Adjust Imports View
Hi team, I'm trying to adjust the view of the Imports tab in the Actions area so that all the text is visible. Currently the columns are a fixed width & I cannot adjust them. Likewise I am unable to extract the data to view it in Excel (where I can adjust columns etc) Anyone know how you can view all the data in this…
What is Branch?
Can someone explain in a simple language of what is a Branch?
Import to time based module with "ask each time" time selection
Hi! i have met the following issue. There are two modules: - Target Module: Time based (Year) - Source Module: no time dimension when doing import , I chose "ask each time " option for time dimension , and during import run i select that single year which is presented in the module. the import is running successfully but…
Import - Values inconsistent
Hi, PLease see details on the attachment. Regards,
Questions on Data Hubs and how to have Peak Performance?
All, Please check out my new article on Data Hubs: Purpose and Peak Performance. If you have any questions, please let me know. Link here Thanks, Rob
Anaplan Connect Using Linux Script(Certificate Based Authentication)
Hi Team, I am working on Anaplan Connect on Linux Platform tried run with credentials it worked, however, i am unable to run with certificate authentication. Getting an error" -certificate is unknown token" Please find the below code. #!/bin/sh # This example uploads a file and runs an import…
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
Export configuration
When I export a module with a layout: Grid, all Pages, I get 1 excel sheet per item from my list in page which is the result I want, My only issue is that the excel tab is generic whereas I would need it to have the name of the item in the page, Is it Something that could evolve?
Data Upload Metrics
One of the most common questions I get, regarding uploading data to Anaplan, is what the optimal chunk size is. This post will review my results for file uploads using cURL, Informatica, and Anaplan Connect v1.4. First, a bit of background on chunking. Files in Anaplan are stored in chunks (unless under 1mb, the minimum…
Consolidate a sales plan
Hi, We have a new request from our sales ops to consolidate some plans. The ask is to consolodate two different sales titles, each from a different territory, each with a different quota component. The territories quotas are calculated differently however, but for the new consolidated sales title it will have the same…
Help! My dashboard keep losing data/ syncing/ zeroing out!
My source module works, but for what ever reason this dashboard keep zeroing out. It will work fine in the beginning, but after I logged out or come back to it the next day. All the data will be gone and it will zero out even though the source module its fine. Has anyone encountered this before? Any ideas?
Export run - You are not authorised to run
Hi Team, My requirement is to extract the data from exports and load it into the snowflake. Currently in Postman I used the post method and create the export task https://api.anaplan.com/1/3/workspaces/8a81b0945cdbe1ec015ce678a3f60051/models/420BD91A05144xxxxxxxxx/exports/11600xxxxx/tasks Once I received the task id I used…
importing data into list item
Hi! I'm taking a lesson list's course which is before 102 and have a question about Central Library(list import). I imported the data of Employees.csv, following the guide, but unlike the guide, error occurred. So next I filled in all source blank like photo, then I imported successfully. Why error occurred regardless of…
Informatica cloud connector for anaplan not working
I am trying to use anaplan connector in Informatica cloud and it says the connection got created , But while using it in data synchronization it is not able to load imports and export definitions. APi major version is 1 and minor version is 3 as shown in Turotial videos on Anaplan site Basic authentication is used.
Sharing Lists Between Models
Is there a way to share lists between models? We use a number of different models all for the same company which uses the same structure - and it would be really handy if it were possible create a 'shared' master list(s) in one model that could be referenced by all the other models.
Anaplan connect error: SQL: No suitable driver found for "jdbc:oracle:thin:host:domain:port:service
Unable to connect to Oracle database using jdbc. API throwing no suitable driver found error. 1. Installed JDK 2. placed ojdbc driver jar file in JDK lib directory as well as in anaplan connect directory.

Data Integration

Discussion List