-
Level 1 - Importing Data into Product Details and Employee Details modules
I am hitting errors when importing data into both modules for product details and employee details. I am not sure if I am mapping it correctly or if I have created the modules / dimensions correctly in the first place. When I look at the exaple Model, my modules look different to the modules in the example model - I have…
-
Loading Transactional Data into Data Hub
Hi 1. Why do we create a concatenated list to load transactional load into data hub? Instead we can create individual lists as dimensions and load data. 2. Why do we create hierarchy lists as flat lists in Data Hub? Thanks Ibrahim
-
Import Export Action Button
Hi All, I have a module with a time range(a customized time range created in Anaplan by the user) of 3 years(2018,2019,2020) where data is input for each month for the current year. We are providing an export/import button to the user on the dashboard to upload the data for the current year. But I am observing that on…
-
Anaplan Connect Install 1.4.4
I am installing Anaplan Connect for the first time. When I try to run the import script, I get the below error message. I do have the WorkspaceID in there. I also want to runt the script on a shared drive in Unix if possible. Can anyone help? Thank you. ======================================================================…
-
Text to Date conversion
Hi All, My import has dates in following format: "01-sep-20" and I want to convert it to monthly date "Sep 20". I was trying combinations of PERIOD, DATE, VALUE: PERIOD(DATE(VALUE(LEFT('DATE (txt)', 2), MID('DATE (txt)', 4, 3), VALUE(RIGHT('DATE (txt)', 2)) But it seems that it won't work because it doesn't recognize…
-
Anaplan Connect Migration v1.4. SQL Server Connection (check sql server driver for jdbc)
When migrating some Anaplan connect scripts from v1.3. to v1.4. I encountered an error with my sql connection. The error I received when running my script was something like 'check sql server driver for jdbc'. I wanted to share the solution for reference as it was not that obvious. In my original script (v1.3) my…
-
add a button to a board and assign an action to it
hello everybody. I am a new here. was assigned to a relatively easy task, but do not know how to solve it. to describe the case: 1) there is a working dashboard. 2) for example it has a grid and an extract button. 3) now my task is to add another extract button, to export what in the grid into a .txt file, so the managers…
-
Log for load
Hi Anaplanners, Is there a way by which I can get log history of records, when data is loaded through Integration. Ideally, the history log in Anaplan can just let us know for the number of records which gets loaded, not the one which were ignored. Is there a way to find that through Anaplan? Ideally if we manually load a…
-
add new item to an existing dashboard
hello. dear anaplan community. I am new here. I would need help with adding new items to an existing dashboard. anybody who can help? thank you.
-
What protocol and port(s) does MuleSoft Connector use?
Hi, My current client has selected MuleSoft Connector to orchestrate the integrations between Anaplan and their legacy systems and they are asking what is the protocol and port(s) it uses to connect to Anaplan. I've searched through Anapedia and the Community and I was not able to find the answer, however I assume it uses…
-
API to get detail data for a module ID
Hello, I'm using RestAPI https://api.anaplan.com/2/0/workspaces/{workspacesID}/models/{modelID}/modules to get the list of modules available for a Budget Model. Is there an API to get the data details or items behind the module ID? I tried using the API to get the file details, but did not work.…
-
add export qlik extract of an existing report to a dashboard
hello. anybody to help how to create a Qlik extract for an existing report and add this function to a dashboard? thank you.
-
Imports using API
In the link below, it says that in order to carry out an import, "You must be the user who created the import definition. You can only import using the import definitions that you have created". Does that mean that the imports are user-specific? Or would the API be able to use any action that had been set to admins only?…
-
Issue Importing on Code
Hello, I am having issues importing data between development models via saved view. The model is trying to import Activity and Account Categories based on Name (or line #), whereas we need it to import based on Code. I'm not sure why this is defaulting to import based on Name, since these Activities and Account Categories…
-
IS Summary
Hi All, I just wanted to understand the importance of Is summary in Anaplan. I have a module created with Is Summary switched on for a line item in my module which is preventing that line item from coming in the export view taken out by omitting summary items. When I remove the checkbox from is summary for that line item I…
-
How to get all metadata from a Model using RESTful API?
Hello I'm new using Anaplan web app. and the RESTful API. I need a way to export all the metadata or the raw data for a Model (1.8 Billion cells). Per the API guide, https://anaplan.docs.apiary.io/#reference/export, it reads I'll need to run a task for each export and get the data by chunks? Is this the only way to get the…
-
Download file from Action -> Import data Source
Hi, How do I download the csv file from Action --> Import Data Source tab? Thanks, Santosh
-
Level 1 SYS08 Employees Details Module
Hi I was able to import the details without any error messages and I have progressed through to lesson 11. I just have one question about the module that I see. Why is the Dept Code in full such as 'Sales' and why is the country code in full such as 'Canada'. If it is the code shouldn't that column have only codes? Or is…
-
How to integrate Azure blob and Anaplan For transferring files
Is there way to connect azure blob and Anaplan to upload/import data can it done by rest api call or can i use custom script to call Anaplan connect import hub from azure??
-
Anaplan usefulness over others
Hi Friends, We can perform What if analysis in Tableau. So can't we directly import data from SAP and perform better data visualization there? Tableau also can do Budgeting & Forecasting. Why do we need Anaplan in between?