
Data Integration
Data Integration
Discussion List
- Hi, Can someone help me setting the script variables for sending success/error logs via email? I tried the following according to the "Anaplan Connect Enhanced Automation" manual, but got errors that …
- Hi, Given that the following line items are in a module. Sales amount: Nubmers for actual, previous forecast version and budget have been already populated Current Version: Checked if current version …
- Hello, I'm having issues where an anaplan connect import batch script, runs stating "The operational was successful. Name of List: 3515 <0/3515> rows successful, 0 ignored. (It always uses 3515, even …
- Good morning, i receive following error when trying to edit the import data source: "API invocation failed: Illegal argument" In the same time even if source is pointed to production and users have ac…
- Hi There, I'm trying to import property that has unrecognized date/time format, e.g. Sun, Mar 5, 2017 9:07 PM I see that date format allows setting custom format and use "?" to ignore certain position…
- 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 lo…
- Hello! I would like to implement logic like "Sumproduct" fuction in Excel. Is there any simple function in ANAPLAN? Thank you.
- 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…
- 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…
- 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%) *…
- 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 d…
- 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 illust…
- 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, b…
- 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 r…
- 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 refr…
- 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. …
- 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, …
- 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 refr…
- I need to clear out list items that are not in my import file but only for a selected version
- 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 : fo…
- Unlike Excel, circulation reference is recognized based on Line item. Is there any solutions to resolve this problem?
- 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 solv…
- 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 inst…
- 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 -…
- 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?
- 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 …
- We have SSO at my organization to login to Anaplan. How to get the excel addin working with sso login credentials?
- Hi, does anyone know a way to retrieve data for multiple sheets/ views. Possibly a macro calling the anaplan add-in button retrieve data?
- 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 Terr…
- Can we use published webservice to load the data to Anaplan model. If so can some one provide me a high level guidance