-
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…
-
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
-
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 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
-
Level 2 Activity 2.3.9.1 Import data into DAT03 Historic Volumes module
Hello there, I came across one error when I deal with activity 2.3.9.1 Import data into DAT03 Historic Volumes module at level 2 ( refer to Process failed error.PNG). I have made sure that Actions -> Import Data Sources is correct and updated ( refer to Export.PNG). I have also verified the Source Model ( Source…
-
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…
-
Excel add ins
How can i extensively use this? Im new to anaplan and trying to understand functionality of excel add ins in anaplan. We are developing dasboards in the system and would like to get those data out then to an excel output and how is this different with excel add ins? Thanks Faye
-
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…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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.
-
One question regarding level 1 - Activity 7.2.3 : Import Data into Employee Details Module
Hello there, I meet one issue when I import data into employee details module for level 1, activity 7.2.3. The result can be seen from screenshot (refer to Result.PNG). Here we can see that Name, Country, Start Date and Leave date columns were not imported at all. The imported report can be seen from screenshot (Import…
-
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.
-
Question for Level 1 Activity 4.8.2: Import Data into E2 Employees# List
Hello there, I have one question regarding the activity 4.8.2 in level 1 where I imported the data successfully but employees of departments all shows up like numbers (please refer to why number.PNG). As you can see from the screenshots enclosed, the mapping was correctly done before importing (refer to Import set up.PNG)…
-
Alphabetically ordered list
Hello all, I have a list of employees without alphabetical order in my model. On the dashboard, I can create a new employee in the list but I want the whole list to become ordered alphabetically when displaying for example. Would it be possible to help me ? Regards,