-
Invalida Date - Import from one model to another
Hi, Please see the details of my inquiry in the attachment Regards,
-
Anaplan Connect 1.3.3.5 - multiple files import
Good evening, I have 4 files that need to be imported in anaplan, that have the exact same columns name and that will hence use the same action. Is it possible to write a single script by 'cumulating' the actions and having something like : set Operation=-file "file1.csv" -put "data/ImportModule.csv" -import "New Hire from…
-
Ad-Hoc Integration Using Flask Microservice
There are several cases in which it would be beneficial to allow users to trigger integration jobs, ad hoc, from within the Anaplan platform, but there is no native feature that allows this. Previously, I described a solution that simulates this functionality using only Anaplan Connect. This article presents a solution…
-
Data Hub Connection to multiple output models
Hi Everyone, We set up a Data Hub and would like to use it for multiple models, because there are lots common lists that we can use for various models. When we build connections among Data Hub model and other output models, we can set up actions in output models, by importing connecting "Data Hub" model's lists, to push…
-
How to sum a column by looking up a dimension in the module
Hi, I have this module that has a dimension list called Sales Title and a list called Quota Types. I have a line item called SSA Revenue, and it is 1 if it has SSA Revenue, else 0. I have a second line item and I want to sum the total number, grouped by Sales Title. Picture attached. Would I be able to get some help…
-
Import raw data of transaction
Dear gurus I'd like to import raw data of accounting transaction data from ERP. I created module "Accounting Raw data". In this case, we need to define unique key in module such as Document No, so I created new list "Sequence No" as numberd list. In this case, I have to import Document No to Sequence No list first, then…
-
Multiple Import Files
Is there a way to combine the multiple select files within an action when imports share a file i.e. updating a list then a module with the same .csv, without deleting and recreating the imports?
-
Mulesoft API Certificate Authentication
Hi, Does anyone know whether Mulesoft API can support Certificate Authentication? How to do it? I am referring to http://docs.anaplan.apiary.io/#
-
Anaplan Mulesoft Integration
The current Mulesoft does not support Anaplan connectors. Any advise on what to do regarding this? And how to find import id on Anaplan. Kindly provide your valuble input into this. Should I use backdated connectors/api ? -Thanks
-
How to Export a Dashboard to PDF?
I created a dashboard in one of the models I am developing. I want to export that dashboard out as PDF. I found this https://help.anaplan.com/anapedia/Content/Dashboards_and_Visualization/Work_with_Data_on_Dashboards/Print%20a%20Dashboard.html on anapedia, it says * Open the dashboard to be printed. * Click Export on the…
-
How different is 303 from 302
Hi Team We would like to know if 302 is different from 303, only difference we see is getting certified. Kindly clarify Kavin
-
PowerPoint Add-In and Conditional Formatting
When establishing a connection to a saved view in Anaplan that contains conditional formatting, Is it possible for the PowerPoint add-in to pick-up the conditional formatting as well? If so, can anyone please provide guidance?
-
creating transactional store of plan data
I have various modules which use numbered lists as children of cost centres. Users add items to these numbered lists to capture planned costs for different activities over time. To export data to our reporting tool I've created a module which collects the values dimensioned by cost centre, gl and time. It is…
-
How to Integrate Rest API with Anaplan
HI All, I would like to learn more about Rest API connection with Anaplan. Consider my knowledge in this is 0%. Can you guys please share your thoughts or it would be great if you attach some files as well. Thanks in advance!! Kavin.
-
HyperConnect / Informatica Cloud (Training Course)
* Course Objectives * Resources * Video: Locating and using Informatica help resources * HyperConnect Overview * The Secure Agent * Demo Secure Agent Setup * Connections * Demo Connecting to Anaplan * Demo Connecting to Salesforce * Demo Connecting to MySQL * Data Synchronization * Demo Sync SFDC to Anaplan * Demo Sync…
-
how to add new member in a list (not numbered) from a dashboard
Hi Experts, I have to create a dashboard and use it to update an list. New members will be added in the dasboard which will add member in the list. This list is not a numbered so i cannot use create button. I have manage to udpdate the list properties via import but cant figure out how a new member would get created or…
-
Excel Add-in and Note pad
Can I use the excel add in to download and upload to the notepad?
-
Is it Real to make dynamic List
Dear Anaplanners, I have a modeling issue. We have an "Agreement Register" in anaplan, it has the structure you can see in attached photo: The values for each agreement are being changed every month. Also every month we need to Export "Unique code + Value" to other system, and each line there becomes enrighed with…
-
Multiple Conditional formats for different rows in a table
I am wanting to set indiviudal conditional formatting rules for each row in a table on a dashboard. How am I able to do that?
-
Import Mapping
Hello, please see the attached screenshot: can anybody give me a hint why the "automatic" mapping does not work thought the strings are equal? (None of the pairs do...) Kind regards, David Mandl
-
Script to Automate Current Date Import
I have a client that would like to automate the process of updating the current date in their Date Attribute module. Are their any scripts available to auto-generate the current date to load into their module? Ideally, we would install and use Anaplan Connect. Thanks, Tony
-
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…