-
Run an Import process via postman
Hello Experts , I'm new to Anaplan and currently exploring the Rest API's . I'm doing a POC on the below requirement . The requirement is to send a csv file from a SAP system to ANAPLAN using an Import action (Expectation is the details of the csv file gets updated in the import table in ANAPLAN) . Below steps have been…
-
Several modules in 1 dashboard but presentation issue when exported
Before anaplan, i have this excel which contains 1 tab where all the financial statements are reflected with consistent time period. When developed in anaplan the 3 financial statements were developed in separate modules and were just combined into 1 dashboard in the model. Now the expectation when exported to excel is to…
-
Find the import ID from file ID
Hello Experts , I'm new to Anaplan and trying to integrate anaplan using Rest API . We are sending data to anaplan for which I would need an import ID . However , I have been provided with a file ID by ANAPLAN . Could anyone guide as to how import ID can be retreived from a file ID ? Also if someone can explain the…
-
Certificate authentication issues
I'm finding the information in relation to setting up certificate authentication hard to follow. In the following link: https://community.anaplan.com/t5/Releases/How-to-Use-Third-Party-Certificates-With-Anaplan/ba-p/49116# there is information that says: "When you obtain your certificate from Sectigo, you can either submit…
-
How to synch user on the page with items of list displayed on the page
Hello, So I've been trying something I thought easy but encountered some problems, what I've been doing wrong, here is the situation : => User going on a page to enter some info about themselves in a board (grid). They open the page. They have to select their user name, as "Name", because their name in the database is…
-
Data Export
Hi, How can I hide a specific line item/column when exporting? Please see screenshot. Thank you.
-
Summary in a hierarchical list
Hi all, I have a module that returns the number of people per project, with a hierarchical list in the dimension. In the "summary" I have the sum of the people who worked per iteration each time : For example: Iteration 1 = 1 person Iteration 2 = 1 person Sum of project 1 = 2 people while it's the same person. I can't fix…
-
How to check Application version
Hi Team, How do I locate the version of the Anaplan? I completely agree that each release/update to the platform is been pushed to all Clients through their scheduled maintenance. But where do I find the release or version number.
-
Do Read my Latest Article on Imports and Import Data Sources
Community, Here is my latest article on the best practices about Import & Import Data Sources. Please do read it. Imports and Import Data Sources as Production Data - Anaplan Community Thank You @rob_marshall for reviewing it and giving it a fine touch.
-
Facing trouble in importing .csv to Anaplan without Time Dimension in the Source file
Hello Everyone, Hope you all are doing great! My name is Bhumika, I am learning Anaplan. with the help of Anaplan Community. I am facing a trouble, as I am trying to Import the .csv Data File to one of my Modules. I have downloaded .CSV file from the Lessons only, but that .CSV file doesnt contain Time Dimension. How to…
-
Level 1 Model Building 8.5.3 Activity
Hello, I tried to import data by following the instructions but cannot. Here are the screenshots and csv file I am trying to import. Some data is imported but they are wrong figures compared to csv file. If someone can help how to correctly import the csv file, which is very helpful. Thank you so much.
-
Import bulk users into a list having selective access
Hello, If there is a list hierarchy and we enabled the selective access to it. now for each list item, I want to add bulk users at a time. Is there any method or can we use any module to import bulk users? Thanks, Mahesh Kumar
-
Installing M2Crypto Python Library on Windows Machine for Certificate Authentication
Hi guys, I'm running into a few errors trying to install M2Crypto on a windows machine. I've done a fair bit of research and it seems to be a common problem with the library. Wondering if anyone here has experienced similar issues and resolved them? I'm using Win10(64 bit), Python 3.8 through Pycharm. Pip 20.1.1. I've…
-
Excel Add-In Unexpected Error
I have recently installed Excel Add-in 3.2.129 and I cannot get it to work. When I run a query I get the following: . Followed by a long wait and then: Any ideas??
-
Progress Bar in the New UX?
Hi Community! I recently saw a demo in the New UX that showed a progress bar as Anaplan stepped through various actions after clicking the action button. The progress bar appeared to be dynamically updating after each action was run. Does anyone have any examples they can point me to that shows how this can be done,…
-
How to integrate Anaplan to AWS
are there any API's available in Anaplan to push the data to AWS cloud. Or can it trigger message to AWS ?
-
Export using JDBC - API request fails
Hi Experts, Trying to export data from Anaplan to SQL using JDBC connection. the script was working good for my last export where i was able to export the data to SQL successfully. Approach is the same and with new export script now, Script was working good till export and i encounter 500 internal server error for new…
-
Issue: Exporting action fails on New UX
Hi, would like to bring up that there seems to be an issue when running an export action from the New UX. Although the process is marked as complete on Anaplan, an Export Failed notification occurs, with the file failing to generate on my browser. I have tested it on the old UX and the action seems to be working fine. I am…
-
How do I compile a document for whether a data point in the Hub is being used in the spoke models
Hello, We are trying to cleaning up our data hub for data points that are not in used in the spoke models. So I need to compile a document for whether a data point (Line item in the module) is being used in the spoke models. Now I am taking the following approach: 1. check the "Reference by" in the blue print to see if the…
-
Anaplan Connect JDBC Error # 28
Hello I am trying to export data from Anaplan to Vertica and i get the Error # 28 / Error # 27 for some files. Not sure of the error type. Other files in similar formats are exported fine.
-
How to put a control on a sum of data
Hello all, I have data to provide per person over different periods (I can have intersections). I want the sum of the data per month not to exceed 1 otherwise it returns an error message to the end user. I don't know how I can make this condition on anaplan. Can anyone help me please? Soukaina,
-
How to export History in csv format
Need to export History in csv format,any idea ?
-
Automated import from Power BI to Anaplan
Is it possible to connect Power BI to Anaplan such that I could import Power BI entities or tables into Anaplan?
-
Load Data between two model from Numbered list to another Numbered list
Hi, How can i automatically map my data load from data hub to FPA model? In my data hub, i am using a numbered list(Coded) and trying to load this module in my FPA model using the same numbered list (Coded) but the mapping are not automatically updating. > I have mapped the building Code-Dum to the coded building column. >…
-
Import new list item from module using users dimension
I have an employee list for which I would like to create an action that allows to import new employees to the list. In order to do this, I have created a module using the Users list as a dimension with the line items needed for the import (including parent and code). After importing this modules in the employee list, no…
-
REST API - Speed
Hello, I am currently setting up calls to the REST Api, and I want to know if there are any best practices to improve the speed. If I try to run the same data that we are using with Anaplan Connect, it times out. This is a listing from the history for 14 Days of data, that does not time out. We usually run 60 days with…
-
New UX Process
Hi Friends, I would like to know, if the Process button (Action button) that is in the Worksheet can be published in the Board?
-
Anaplan Export using JDBC properties files
Hi All I have an issue when trying to execute an insert query using jdbc. # JDBC Connection string (Oracle, Mysql, H2, etc.) jdbc.connect.url=******* # JDBC login username jdbc.username=****** jdbc.password=****** jdbc.fetch.size=10 jdbc.isStoredProcedure=false jdbc.query=Insert into flash_rw (Period) Values (?);…
-
Toolbar new UX Dashboard
Hi Members, Please help me find this button. It is not displaying in my Worksheet Designer.
-
Level 2: Conclusion: Activity: Add Currency Conversion Functionality
Hello, I am having trouble pulling in all the data for all the Time/years. What does it mean in the Activity Instructions: ..."contains data needed to set up this module. Use the Symbol as the Code for each currency." The CODE used throughout is not the column in the data extract under Symbol (eg USD) vs. Code of "US". I…