-
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…
-
AnaplanClient.bat is not recognized as internal or external command, operable program or batch file
Hi Team, Could you please, assist with this problem? @echo off rem example. Set AnaplanUser="example@example.com:password" set WorkspaceId="*****************" set ModelId="*****************" set Operation=-via http://example.net:10085 -export "Export_action.xls" -execute -get "D:\output.xls" rem *** End of settings - Do…
-
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,
-
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 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…
-
201 course activity 4
Hi ! I'm taking a class activity 4 of 201 and trying to import data of 2015headcount. But I failed to import in terms of stat and end date. I'm thinking the reason is that I used a different date format. So in the guide line, there is written " select the Rep Setup Line Item Tab in the mapping wizard and choose Custom…
-
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,
-
SUM Function Example
I tried to create a simple SUM function. In a video it explains transaction as Line Item whereas I failed it as Line Item. So I tried using Transaction as a List. It worked out. Can you please let me know, if I am right or wrong? I have shared Screenshots for reference.
-
data import unsuccessful
Hi I am trying to import data from a .csv file into one of the list that I set it up, but the data import fails with the message ' New property combination found but name or code already exists'. Please see the screen shots attached for the setup. Any help would be appreciated. Thanks Regards Prabakaran
-
Distinguish between List Item or Line Item
Dear Members, I am new to Anaplan, so I would request your generous help. Order Number or Transaction Number is a Line Item or List Item? And if the answer is List. Then let me know, if millions of transactions happen daily in any Retail chain or Bank. And if we create Numbered List for the Transaction, after 1 Billion…
-
Anaplan - Informatica Cloud upload only import
In Anaplan Connector - Informatica Cloud am trying to Upload Only Import and then make use of an existing process. I can perform these steps in Anaplan Connect, but not seeing how to make this happen in the Informatica Anaplan Connector. I see the checkbox for Upload Only Import on the Schedule->Advanced Target Properties…