Data Integration

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.
File imported in random order
Hi I am importing a .csv file into my list .The file got imported succesfully,but I see the records are not in the same order as in the .csv file. ex. The first record in the .csv file appears in the middle of the record set in the list. Is there anyway , I can insist the records in my list are appearing in the same order…
Import - Values inconsistent
Hi, PLease see details on the attachment. Regards,
Import - Values inconsistent
Hi, PLease see details on the attachment. Regards,
FP&A Case Study: populate sales forecast module with Budget Units
Hi, I've been trying to upload the budget units (from the sheet input units from the 2017 budgeting excel file) into my Sales Forecast Calculation Module. In that module I look either at the actual units, and if not present, at the forecasted units to calculate revenue, COGS, ... However, I cannot manage to import the data…
Delta Load
Hi, How incremental load works from any data source(other than anaplan) to data hub in anaplan?
Cannot import List from Dashboard
Hi, I have now a trouble to import data file to List which is published to a dashboard. No list cannot allow me to do import. Error message is here "Sorry, you do not currently have access to run any imports." Would somebody help me, please
Import from module with greater dimensionality
Hi, I'm attempting to import data from a module in another Model (monthly employment costs per employee) which has greater dimensionality than my current module (The source has a Currency List & also Versions which the current Model does not have) Is there a way to SELECT a Currency List & Version item to import or do you…
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…
Anaplan Connect API - Load a Java Class
Hi, Please see attachment for the details of my query. Thanks in advance Regards,
Being able to copy a cell with lines of text separated by a line break from Anaplan to Excel
Posting on behalf of Thales Example: Car 1 and Car 2 are separated by a line break When copying the above cell to Excel, we get: It creates two cells. To keep the text in one cell, the current workaround is to use a space instead of a line break in Anaplan, but for some users, it is easier to separate two distinct elements…
Edit Dashboard
Dear Members, I am getting a Slider which I want to remove. Desired Format has no Slider. Please help me to remove the slider from Dashboard. Thanks.
Dashboard Header Module
Dear Members, Require your help in removing the Module Name from Dashboard. I have shared the Desired Format (How I want) and My Format (How I have). Please feel free to ask in any difficulty of understanding.
Create Child in Numbered List
I had the original Model, and I was trying to replicate it. The pic 01 and 02 are the Original ones. The pic 03, 04, 05, 06 are my Model. It is restricting me to enter the values:- Soft Drinks, Tea.... I even tried creating .txt file and import it but it failed too. I need your kind help for this. Please feel free to ask…
Import period format to Time Periods or Date formatted line items
As we drive to remove Text from our models, dealing with Dates is troublesome. When mapping files to Time Periods in modules, we can choose periods and define the format. For example, in my file I have YYYYMM. However, when I am trying to bring this data into a formatted list I do not have this choice. Even when formatting…
Import Failure while importing from one line item to another in same module.
Hi Can anyone explain me the cause of the error " No value loader exists for this type: NONE " . Any help would be appreciated. Thanks
Why won't my vendor roll up to my Total department. It seems to be only this vendor.
I created a a vendor call MISC. Its to group all the vendor under a certain amount to MISC rather than showing a bunch of vendor. When I select Total Department, MISC won't show up. But if I go to the specific department call N/A or No Department, which is the roll up level. It will show up. I tried moving N/A around to…
Importing Text: Result ends up longer than import
This is a pretty bizarre one... am importing in a transactional level data set which has a unique code for my list - model best practice fans. Then as I load into one of the properties of the module some of the information transforms from a four digit character to the same four digits but with FIVE leading zeros. I've…

Data Integration

Discussion List