-
Changing the date format while exporting data from a module
Hi all, We have a module where the time is like Jan-19, Dec-18 etc. But we want the export file from the module to have date like 201901 or 201812. Is it possible? We don't have the option of exporting the data out from the module and changing the format and loading into another module as these are biggest modules and we…
-
Anaplan Connect 1.4 Documentation issues
I have found several errors in the Anaplan connect 1.4 PDF documentation ref: Anaplan Connect Guide - Version 1.4 - (Last updated December6, 2018) On page 52 (in Appendix E, numbered as 47) a jdbc.properties file example is shown. The jdbc.connect.url parameter is show as jdbc.connect.url= " jdbc:sqlserver://localhost” It…
-
How to map a line item into a dimension
Hello, I have a module with dimensions Employee and Time (Months). The module contains a list formatted line item "Shop Number" (the shop the employee works in), and number formatted line item "hours worked" (the number of hours that employee worked per month). I want to bring this data into a second module with dimensions…
-
Login As a User Feature
Hi all, We have several different models in the Anaplan tool created for our company. The models are built for several different business units and different countries. When you are a specific user from one unit or one country, you see the correct data. When you are a super user (not admin/anaplanner) and you have access…
-
Exporting data of selected line item from module
Hi team, I need to export the data of some selected line item(not all) from the module. As from general export it is exporting the whole data of all line items. Could you please suggest a way to export the data of selected line items from module. Thanks in advance. Regards, Mohammad Husain
-
Excel Add-in v3 and Office 365
Will the Excel Add-in v3 or later ever support Excel 2016 in Office 365? If not, is there a fundamental reason for that? Regards Dave Easey
-
Best way to set current period (month/quarter/year)
Hi All, I've seen my question answered in bits & pieces, but hoping someone can give me a comprehensive walk through... My team is looking to build modules that will automatically assign current period reporting so that we can leverage the excel add-in with minimal human manipulation - really just looking to hit refresh…
-
November 17, 2018 Release Discussion
Do you have feedback on the November 17, 2018 Anaplan platform release? Share your thoughts below! Click the Reply button below to post.
-
Number format being changed when importing between models
I am attempting to set up an import between modules in two models; the target module has a has a list of numbers as the 'applies to' while the souces has a list of business areas. To get around this I have created a line item in the source module to assign each entry a number reference. This number is formatted at zero…
-
Model Import Failure
HI All, I'm trying to import a model from one workspace to another but I'm getting the attached error. This error is happening only for specific models and not all models to which I have access to. Can you please let me know what is causing this issue. Thanks & Regards, Prateek
-
Getting an error when trying to run an Import Action using Python3
Hi, I’m new to Anaplan and am trying to automate the process of refreshing data from a file that has been previously uploaded and imported to a module. I’m referring to the Apiary and this github repo https://github.com/cdhippen/Anaplan-Python3-Scripts/blob/master/Action%20scripts/action.py I’ve created a certificate file…
-
PDF documents
Hi Is it possible to define a line-item with reference to a PDF document? Thanks!
-
User access. Request could not be processed.
Hi all. Can anyone help solve problem with access into my model for new user? Each time when he's trying to enter, he receives message. Please find attached. Most intresting, that for others new users with the same Model role, this error not shown. Thx in advance.
-
File delimiter while importing data through anaplan connect
Hi, We are trying to import a file which has ; as delimiter through Anaplan connect batch files. But each time, Anaplan connect changes the delimiter to “ and the import is failing. Can we use ; as a delimiter in Anaplan Connect import files or only , and tab are supported? If we change the delimiter to , then the import…
-
Anaplan Connect 1.4 Import Issue
Am migrating our Anaplan Connect batch files from 1.3.3.5 to 1.4 and all is going well except that when it comes to running an import routine it fails because the first column of data in the upload file is titled "crazy character"name rather than just name. Is this a glitch or something else? Works fine with the original…
-
Updating Organization List - best practice
Hi I have a module that works out accruals & prepayments by contracts and when each contract gets added it is mapped to an organization parent. The issue I have is that the organization list constantly changes each year and therefore needs to be remapped. I know if i delete and import a new organization list, i will lose…
-
Can one control the order of a Module Export to Singular Columns?
Hi there, I need to get a very specific order to my Export to Tabular Singlular Columns. Right now I cannot seem to control the order of columns that comes out. Is this possible to do? Thanks in advance for your help.
-
Import of data into the module with Subsidiary Views (use of subsets list on line item)
Hi, anaplaners! Can you help me figure out the import of data into the module with frequent use of the list subsets? The module is P&L report, where each article is a separate Line Item. For each article, it is planned to assign its own subset of the list "Cost Centers" to optimize the place in the module. Also, subsets on…
-
Anaplan Connect 1.4 Import Issue
Am migrating our Anaplan Connect batch files from 1.3.3.5 to 1.4 and all is going well except that when it comes to running an import routine it fails because the first column of data in the upload file is titled "crazy character"name rather than just name. Is this a glitch or something else? Works fine with the original…
-
Data Integration
Data Integration can be a large and complex topic. These lessons will help you get on the road to understanding your integration options. Note: These courses are also part of the Level 3 Model Builder Training available on the Learning Center (learning.anaplan.com). They are provided here as informational only. If you need…
-
Need to trigger informatica job from Anaplan dashboard
Hi team, I need to confirm if Anaplan provides any functionality so that we can trigger the jobs in informatica cloud from Anaplan dashboard. There is a requirement in which I have to click the button from dashboard and it will trigger my informatica job to load the data from my source system into Anaplan Model. Could…
-
Planning for Efficient Imports
Take time to determine the most efficient way of pulling your data in. With multiple views, it is common to think about each view separately, but when it comes to importing data, a holistic view is key. For instance, if you would like to see a current roll-up of sellers to teams and a historical view (i.e. – which seller…
-
March 10, 2018 Release Discussion
Do you have feedback on the the March 10, 2018 Anaplan platform release? Share your thoughts below! Click the Reply button below to post.
-
Importing Excel data to a module by using hierarchical list
Hello Anaplan community, I would like to import data from Excel source to a module using a hierarchical list. In my data Excel source, I do not have the column Parent, which will helps me to import data with the specific list. Let's imagine I have an hierchical list that contains 3 subset lists : A, B and C. In my data…
-
ERROR: "API invocation failed: Illegal argument"
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 access to the workspace- system gives error "You do not have access to the source workspace" Any thoughts?
-
Mapping Line Items to List Items with huge data
I am unable to import data from my source module to target module because data in source module is under list item whereas in the target module it is under hierarchical line items. The source module has 79 lakh cells under each line item which needs to be mapped into 600 source module list items, it needs to find the…
-
REST api to Execute Import Action Error
I have a java application where I'm trying to execute an import action using the REST API and am getting the returned status of 415 (unsupported media type) from the post. I'm following the syntax defined in the online help:…
-
Excel Add In v3 - Install failed with "Install Visual C++ 2013 Redistributable"
I've tried installing the add in several times with the same error - "Product: Anaplan Excel Add-in (Single User) -- Please download and install Visual C++ 2013 Redistributable option "vcredist_x86.exe" to proceed." I've downloaded and installed the C++ package, both x64 and x86 versions (PC is installed with Windows 10…
-
October 13, 2018 Release Discussion
Do you have feedback on the October 13, 2018 Anaplan platform release? Share your thoughts below! Click the Reply button below to post.
-
Capturing Anaplan Error message Using iPass: ICS
HI Team, I have requirement where i need to Capture Error messages with data row using iPass. I run Anaplan as below:- 1 Load data in Import List action using iPass (I am able to captue anaplan error along with data row) 2 Run Anaplan process which actually calling different actions within anaplan I have issue with…
