-
History Export Slow and large file
Hi, I wanted to check if anyone has experience on regularly exporting the history of the model. I have a model for which I am trying to export the 30 days history and it lasts a few minutes to download a 3.5Gb text file. It's a big file that's hard to manipulate. Is there a way to easily do that? Any best practice tools?…
-
Customized Mapping in Imports
Hi, I am unable to customize the mapping for imports in Anaplan, as an non-workspace admin. I was able to do that until 17-jan. Can you please guide if that's a change/bug in Anaplan Platform. PFA the screenshots for your referral.
-
Export the 24 hour history summary without transactional detail?
I have a nightly batch that runs 14 processes. Most of them upload a file and run two import actions. Since this is the data hub, the only activity is this batch. The History page for the last 24 hrs shows a nice summary of what got done. During routine operations, users will rarely go into the data hub ... so there's not…
-
Anaplan Connect - Cannot enter password
Good afternoon, I am trying to upload a file using Anaplan connect. When running the batch, the windows prompts me with a password. However it seems that I'm not able to type anything for whatever key I press on the keypad. my script : @echo off rem This example loads a source text file and runs an Anaplan import into a…
-
Data Export for Selected Line Items Only
Hi Everyone, I have a view that I want to export into a file via action. The view has 2 lists as column and 3 line items across. The module itself has 7 line items. However, the export always output all 7 line items. Is there a way to limit the export to the selected line items only? Regards, Andre
-
Issue importing dates as text
Hello, I'm trying to import a date into a text-formatted property from a source file. This works on my machine, however when another user uploads the same file, it seems to be creating a text field which includes 2 digits for the year vs. 4. So, when I run the import, the text-formatted field reads "12/31/2018", but when…
-
Lists - duplicate childs for each list members
Hi, I'm working on a financial forecast model where sales is presented through 18 markets (Countries) to the 5 Products. So for example: * Product 1 - Country 1 | - Country 18 * Product 2 - Country 1 | - Country 18 * etc. I have made several lists with: Total Company (L1) -> Products (L2) -> Markets (L3). Is it possible to…
-
Import monthly data to timeline
I have seasonality input per month (January, February, etc.), summing up to 100% in a full year. How can this be uploaded to the timeline?
-
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…