-
Does Anaplan platform provide capability to pull data directy from a SQL Server database?
Hi, The company I am working for has a datawarehouse in the cloud to which the files needed in Anaplan are loaded on a daily basis. This SQL Server database lives on Amazon AWS. Is it possible to connect to this database and load directly into the Data Hub? Is this possible through Anaplan Connect and where can I find…
-
Anaplan Excel Add-in version 3.4
Is there a way to retrieve two or three Anaplan reports to one excel add-in tab? I tried but it jumped to a new tab. Thanks.
-
Formula
Hi, I have a module created with dimensions rate area, brand and channel. However, I have another module where the user inputs the values only at rate area and department level. So from the module where the user inputs the values we are getting it into the module with extra dimensions(i.e. brand and channel) thereby…
-
Posting it for Wider Audience
These are my latest three articles that got published as Best Practice in this month. Please read if you haven't already done so, for they say Sharing is Caring 1. Anaplan Time Import Mappings Untangling Anaplan Time Mapping in Imports - Anaplan Community 2. New UX and Analogies Understanding Anaplan's UX with Analogies,…
-
Need suggestions for API call of export process for integration
Hi All, I have provided the Export Process Names and the file names to the integration team for API call for integration with SAP but the team is getting some error and unable to fetch the metadata. Kindly suggest how to to that. Below is a sample export process name and file name with the error File NameFile IDProcess…
-
How to upload data into week time when my format is week number
HI Anyone please guide on how to upload data into week time when my format is week number. I tried and got error of mapping and week headers. Thank You
-
Excel Addins synchronize page selector
Hi, I have multiple sheets in my Excel where each tabs represent modules in Anaplan. Is it possible that when I change the time in one tab all the other tabs with time dimension will be updated based on my selection? I tried the Sync Sheet in Anapedia but with no luck. It creates thousand of tabs that I need to cancel.…
-
Retrieve user details when Importing to list
Hi, I have a module where the user populate a few line items with information, which is then imported into a list and used further on in the model. However, now the client wants to include a column (line item) where they can see who made the new "transaction", that is, the user that is logged into Anaplan. So my question…
-
Data Export in Individual Tabs in Excel
Hi, I was trying to take export in form of .xls where each item in my page selector should get copied to an individual tab in Excel and the tab name should get renamed as that of the page selector. I was able to get individual copies from each page selector in separate tabs by Exporting in Grid view and selecting All Pages…
-
Anaplan API Python Library
NOTE: The content below is out of date. Please find the updated library at Anaplan API 2.0 Python Library - [Updated March 2022]. Note: While all of these scripts have been tested and found to be fully functional, due to the vast amount of potential use cases, Anaplan does not explicitly support custom scripts built by our…
-
Data export
Hi Friends, Other than Tableau, what are the external systems where data gets exported?
-
Can someone please explain, what these mean in Anaplan Informatica Connector?
-
Release note details for August 22 maintenance
Hello, Is it possible to learn the details for the August 22 maintenance? I see details related to the August 8 maintenance but nothing afterwards. Does that mean that the maintenance being performed tomorrow is not significant? Any information would be welcome.
-
Unable to Import to the Same Module Using Saved View
Hello, I am having this difficulty since last night, I can't figure out how to address this issue. If anyone has encountered this issue before, what did you do to solve this? Situation: 1. I have created saved views inside the same module. I'm using saved views to import to the very same module. 2. The module has a custom…
-
Level1 Training 8.5.3 Activity: Import Data into Volume Inputs Module
How can I set Mapping tab? Is it correct below? Souce column header →Time Location Code →G3 Location Product Code →Products Fixed Items →Volume inputs line items
-
time mapping while importing the exported module
Hi all, I am trying to import data using the export file of the module which has weekly time scale. Every other dimension mapping is ok instead of the time mapping as the exported file has week as time dimension but the target has format of ddmmyyyy to ddmmyyyy. I am attaching the screenshot of the exported file and the…
-
Integration of Data hub & spoke model
Hi all In an implementation if I have loaded all the master data(assume product list) in the first month and in the next month we have few more products added will we load all the data again in the next month or only load additional items? If we are are only loading additional items how can we update the attributes of old…
-
maximum number when creating numbered list
HI, Is there a limit as to the number of items you can import using numbered list? Is there a maximum number you can import in the numbered list? Thanks, Ana
-
GENERAL Information of Anapaln is gets displayed in log file after running the batch file
Hi All, I'm fetching data into Anaplan model using the BATCH file, which is connecting to Oracle Database and fetches into Anaplan model. And i'm writting the bach execution into a log file i.e; example: Load_Fact_PR.bat > runlog.log. After the run finishes while looking at the log there is a GENERAL Information of Anaplan…
-
Exporting Flat Lists from Saved View from the Hub to Spoke Model and Create Hierarchy
Dear Community, I am building 4 flat lists in the Hub as below. L4 is the lowest level, L3 is L4's parent, L3 is L2's parent and L1 is L2's parent. The next step would be to create saved views to build Level 1 to Level 4 in the spoke model based on the parent - child relation assigned below. Do I need to build a separate…
-
Level Model 2 Sprint 1 - Create System Modules. Import Using Blueprint View or Grid View
Hi Guys, I just started with LM2, already having questions. I'm pretty sure I'll have many more down the road. In the activity, when it says SYS05 Region Details module: SYS06 Country Details module: Few questions I have: 1. Do I use Data View or Blueprint View to Import. I understand Blueprint View is used when only…
-
Level 3 Sprint 3 DAT04 Import issues
Hello I'm having issues importing data into the the DAT04 module form the spoke model (Data Hub). I raised a question about a similar issue i was having in Sprint 2 and got it to work but now I'm having the same issues for the second import at the start of Sprint 3! Can anyone confirm where I'm going wrong?... Thanks
-
RESTful API for automating recurring data loads
Hello, I am trying to understand if the RESTful API can help for a use case of automating a recurring monthly data load to a DataHub with a file that is being reloaded on a daily basis with up-to-date data. When i review the documentation, i see the need for a manual UI step to create the action, so the file is uploaded in…
-
Anaplan Connect Powerpoint Decimal Points
Hi All, When posting tables from Anaplan to Powerpoint using Anaplan Connect it is ignoring my number formatting entirely. As you can see in Anaplan they look real nice but when I import the table into Powerpoint it loses the dollar formatting and the decimal point restrictions. Is there a way to fix this? I can export it…
-
Level 1 Model Building - Importing Data
Hi In going through the import data files (e.g. Products), I came to understand that although the parent-child hierarchy is defined in the Lists, 1) the data for the parent (Product Family - Chocolate, Sours, Taffy, Fudge) still have to be defined in the import file. 2) the mapping for the parent (Product Family) still…
-
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…