Data Integration

Anaplan connect from dashboard buttons
Hello, I have a requirement where in a user wants to be able to do the following as and when he wants to - possibly through a button on the dashboard: a) Trigger a batch file (Anaplan connect) that loads data from SQL into Anaplan b) Trigger a batch file (Anaplan connect) that loads data from Anaplan to SQL As far as I am…
Sumproduct fuction in Anaplan
Hello! I would like to implement logic like "Sumproduct" fuction in Excel. Is there any simple function in ANAPLAN? Thank you.
Best Predictive Analytics App?
Hello, Can anybody recommend the best apphub app that can be used as a basis for building predictive analytics within a model? Looking for a strong starting point and don't want to re-create the wheel, just wondering if anybody has had a good experience with any particular apps that they would recommend us to start from,…
Numbered Lists import
Hi, I am trying to import transaction data into a module. To represent each individual transaction, I want to use a numbered list. Also, since there are many transactions in the csv, I want Anaplan to automatically identify and create the required no. of transactions in the numbered list. How can I import and create this…
Prefered Sources for Anaplan to Anaplan import
Hi, I find it usefull to use the following practice : import from Anaplan model should be setup as such : * import from saved views : 90% (even 100% in some contexts) * import from list : 9% (or 0%) * import from module : 1% (or 0%) Whenever possible, all imports should be made out of saved views. It takes 5 to 10 minutes…
Working with the Module Line Items Export
Whenever I need to dig into the model by line item, I always export the module line items (Settings -> Modules -> Line Items tab) and quickly filter it in excel. The only problem is, when you filter down onto a subset, you lose the ability to see what module the line items apply to. For those of you that use VBA in Excel,…
Anaplan Connect set Directory as a variable
Hi, for those who do ot want to key in very long directory names, you may find it usefull to add a line in the batch, for example immediatly after the ModelId intruciton, and this extra line is illustrated below : it's the "SET DirImport" statement : set ModelId="My ModelID"set DirImport=\\servername\directory\ANAPLANset…
Anaplan Connect Alerts
Hi, I have set up several scripts for Connect, using JDBC to SQL etc., and all working ok, except there is a new requirement to alert someone if anything fails. They want to use a windows scheduler, but has anyone been able to write any scripts to send an email automatically when connect encountrers an error? Many Thanks
Data Integration Community
Hi How do you get access to the Data Integration community https://integration.anaplan.com/login/ as the site does not allow you to register or login with your existing login details. When trying to register it states "We do not accept registrations from that domain." Cheers Alan
Refresh Timestamp/Username
Could a timestamp and username be automatically added when an Excel file is refreshed via the add-in? This way the end user or another person who opens a workbook knows the last time the file was refreshed and who carried out that refresh? This also would help with version control.
Exporting Revision Tag details in excel
Hi there, Just wondering if there is an option of exporting Revision Tag details in Excel or other formats? I am trying to get all revision tags exported in excel for detailed documentation purposes. Thanks, Vish
Error on Importing Codes for Line Items
Hi, I already have line items in my module but I forgot to include the codes when I first created those line items. Now, I would like to add their codes through import. However, when I try to import, this is the error: distinct names found for same code - check mapping and/or data. What could be the cause of error and the…
Refresh Timestamp/Username
Could a timestamp and username be automatically added when an Excel file is refreshed via the add-in? This way the end user or another person who opens a workbook knows the last time the file was refreshed and who carried out that refresh? This also would help with version control.
How do I clear out a module for items that are not in an import file
I need to clear out list items that are not in my import file but only for a selected version
Logic set up by list
I have a question regarding logic set up by list. I want to use different logic for 1 line item by lists. For example, there are 3 list item for 1 line item. * list item : BI, PD, OCD * Line item : forecasted figure for frequency When I set up logic for line item, I want 3 years statistics for BI, 2 years statistics for PD…
Circulation reference
Unlike Excel, circulation reference is recognized based on Line item. Is there any solutions to resolve this problem?
Can't import model after SSO is enabled for Anaplan
Hi, We are enabled Single Sign-on for Anaplan recently, but we found we can't 'Import' model now as it requires user and password. However, we don't use user name and password any more. How do we solve this issue? Thanks, -Julie
Can't install 64 Bit Powerpoint addin
When I try to install the powerpoint addin, I get the following message: "This installer did not detect the presence of 64 Bit Microsoft Office...." I have 64-bit office installed and was able to install the excel addin without issue. Setup: Windows 10 Microsoft Office 365 ProPlus Powerpoint 2016 64-bit Is there a…
Import Date
Hey All , I have two modules with no dimensions and format as date PFB Screenshot -1 I have to Import those dates into another module with no dimension & Format as date (Refer screenshot -2) (Module - Module Connect) . I am not able to run it , Please dont advise me to use formulas as i need this Import to Happen . Kindly…
JRE 6 and Anaplan Connect
We're using Java Runtime Environment 6 (JRE 6) on a computer for Anaplan Connect and it recently stopped working. What should we do? Would upgrading to 7 fix the problem?
Error message when refreshing PowerPoint Add-In
Hello, When I want to refresh all of the data that I have linked to Anaplan in a PowerPoint file I have an error message (see attached file) and some of my charts are not updated. Where is my problem coming from? Julien
How to login if I have single sign on?
We have SSO at my organization to login to Anaplan. How to get the excel addin working with sso login credentials?
Excel add-in, receive data for multiple sheets
Hi, does anyone know a way to retrieve data for multiple sheets/ views. Possibly a macro calling the anaplan add-in button retrieve data?
Salesforce Import errors (SFDC)
In importing data directly from SFDC, I have found that 2 characters (ascii 129 and ascii 160) cause errors that are not easy to track back to the source data. ex. Billing City _Error_1_ Oakbrook Terrace Another row has already been processed with this key I found a Billing City of "áSan Francisco" (but the first character…
Calling a pubilshed webservice for Importing data to Anaplan
Can we use published webservice to load the data to Anaplan model. If so can some one provide me a high level guidance
Limit on Model-to-Model Import Size?
Is there a limit on the size of data imports taken through the 'Connect to Anaplan model' route? I am getting server errors, and having to resort to an Excel export from one model and import into the other. The export/import route itself has limitations, as the exports are limited to the 65,000-odd rows that Excel 2007 can…
Import data with a timescale "week"
Hi. I want to import data from a model to another model. Nothing extraordinary. My two models have a timescale “week”.The two modules are in “day”. All the records are rejected with the message:“Invalid date or timescale identifier”. Where is the problem ?
Excel Add-in
Which version of Excel do I need to run the add-in?
How do I clear out a module for items that are not in an import file
I need to clear out list items that are not in my import file but only for a selected version
Using imports as a copy method within a module
A fellow anaplanner had the following question in the FAQ-section. Since Im but a humble user I can't give him a reply there. So here is the question: [quote]We have a situation where we want to import from within the same module from one line item to another. We ran the import two times with different source and…

Data Integration

Discussion List