-
Delete list items not present in the data hub
Hello, I'm creating a data hub in Anaplan in order to have the product hierarchy of 4 models located in only one place. The product hierarchy already exists in each of my models. When i created the hub i cleaned up the hierarchy and delete many items. My problem is when i import the data from the data hub module into the…
-
Learning Academy. Lesson 8. Problem with importing data
Dear Anaplaners, I can't import data to REV02 Volumes Inputs in 8.5.3 Activity: Import Data into Volume Inputs Module. The problem is obviously in mapping. I've tried all possible ways.. Nothing. Who can help? Thanks in advance!
-
Number values getting inflated by 10x when importing from file
Hi all, I'm having an issue when loading a data file to a client's Data Hub. The target module has several line items, some of which are number formatted. When I load the source file one of the numerical columns is getting inflated by 10x once it's populated in the target module. For example, there's a value of 468,408.66…
-
Data Import one model to another with Subset of Time Dimension
Problem Statement - Importing data from one module 1 (time range from 2016+) into another module 2 (time range 2019+) I understand the option of creating a view in module 1 with lesser time range and then use that one as source module. However was wondering if the practitioners have other ideas of importing the data from…
-
How to export data from Anaplan to Qliksense
I built a model in Anaplan Course and I want to export the data directly to another visualization tool such as Qlik. Is there any way to do that? Thank you!
-
Power BI Connector Authentication Options
Does anyone know if there are any plans to allow end-users to authenticate with the Power BI connector using SSO or through a Certificate? Currently, the end-users are facing an issue as they are running an automated scheduled pull from Anaplan to Power BI, but with the need to reset the password every few months, their…
-
How to use FIRSTNONBLANK/LASTNONBLANK in a custom calendar
Hello everyone. I have created a custom calendar. I have mapped Week(List) and Year(List) corresponding to Time(Days). I would like to create a module that sets the start and end dates to the Week(List) and Year(List). I thought I could use the FIRSTNONBLANK and LASTNONBLANK function to get those dates, but it does not…
-
Time
Hi good day1 How can I make this as a row in a module? Because when I use time as a dimension, it aggregates the same date. Thank you.
-
Multiple dimensions but import only allows 2 source to target mapping
Hi, I am trying the training lesson to import a csv file into a module with multiple dimensions but the import window only shows 2 source to target mapping instead of 7 source to target mapping selections. What am I missing here?
-
Anaplan Connect Error Messages
Hi All, We have a number of Anaplan Connect scripts with certificate authentication, let's say 10, as part of a daily job. Somehow, jobs # 1-3 were successful, # 4-6 were failed, and # 7-10 were successful again. I wonder if the those failed ones were due to connection issue during that point in time as prior and…
-
10.2.2
Good evening! When I try to import into 10.2.2, I get the following screen. Not sure why it's coming up like this. Thank you in advance to anyone who can help!! 🙂
-
Model to Model transfer action not working for full access user
Hi, I have created an import action from Model A to Model B and both are in same worksapce. Please see the below details of Model A & B. Model A: It is source model for an import action. I have used saved view for a module which is having User List as a dimension and with few line items. One line item is having their…
-
6.8.3
Hello! My screenshot, below, does not look like the example, which is beside. Thank you to anyone who has guidance!
-
Process Completion info via API Calls
We are using Databricks for Anaplan API and Airflow for job execution. Context : Process 2 (Spoke) is dependent on Process 1 (Hub). This means Process 2 should only start when Process 1 is completed and both should not run parallelly. Issue : Right now the backend only tells you whether the process was successfully…
-
Export Filter
Is there any way to use code of line item as a filter to export through multiple tabular view?
-
Export Column Width
Hi Community, I am trying to export a saved view and the export always turns out with columns set to default width. Is there some way that I am overlooking, that can help me export it with the specific column width that I have set up in the saved view?
-
Adding items to the production list in the deployed model
Hello, I have question regarding adding items to the production list in the deployed model. User has added a two items to the production list in the 'Deployed' model. I can not see these items it in development model. If I synchronize development and deployment models, will the new items added to the list by the user be…
-
4.6.5 Model incorrect
Hello! My model is incorrect, I assume it's from incorrect Mapping. Should I delete and re-enter the .CSV file? How is this accomplished? Thank you. I have added my screen shot below.
-
OpenSSL Windows Installation
NOTE - the downloadable files sourced from OpenSSL.org only work with Linux!!! In order to install on Windows 10, you must with compile the binaries yourself OR find a compiled version already on the web. The instructions below will only talk about finding a website with a compiled version of OpenSSL. Copied directly from…
-
How to update number with rules when importing
Hi everyone, I am trying to update the number during importing. For example, for 2021, I have actual data from Jan to June and forecast data from July to Dec. the target module is on yearly basic, therefore I would need to combine both actual and forecast for 2021. I want to do the import in two separate action: 1. import…
-
Export Action in New UX
Is it possible to create an Export Action (Grid view export of the current page) that adjusts to the grid in the UX instead of the grid in the model?
-
Cloudworks API integartions
Hi Guys Has anyone implemented a new Cloudworks API ? Here is a scenario I have a process that has 2 imports call it Process A 1- imports list items 2- imports monthly data(measures) related to list items when I am setting up my cloud works integration I am not getting an option for selecting a process just imports actions…
-
Unable to Load Employees File Properly - Added Parent in Column
Hi Team, I'm at Lesson # 4. (4.8.2 Activity: Import Data into E2 Employees# List). I've uploaded the Employee File and added one extra Column for Parent and for the first 56 Employees I've marked the "Sales" as a Parent and for the Rest 56 Employees I've marked "Production" as a Parent in Parent Column. However, when I…
-
Anaplan Connect: Convert excel file to csv file in script using Linux environment
Dear Expert, Good day! Would like to seek your inputs with regards to converting a excel file to csv file in the script using Linux environment (Version: SLES 11 SP4). Please advise. Attached file is the excel file to retrieve the current date (sourcexlsFile.xlsx) and csv file as the expected result(destinationcsvfile.csv)…
-
Issue with import action when importing data using saved view
Hi all, @Misbah I am trying to import data from saved view to module and i have applied some filters on that saved view depends on filter the data getting updated and at some point of time the saved view getting empty because we don't have any data as per filters(as per requirement its working as expected) so when we run…
-
Python API with Anaplan || Import || Parameters
Hi, While running an import or process through python API , is there a way to check if the import or process needs a file and which type of file is required? In other words, I need to check if the import is a model to model or csv/txt import and in case it uses a file what is the type of the file required. Any help would…
-
!!! Stuck on 1.5.6.1 Create Historic Volumes Module !!!
Can someone please show me the exact mapping that needs to be done for this exercise? I have tried this several different times over the past several days and I am still stuck on this. 😑 Any help would be greatly appreciated.
-
DAT02 Shipping Metrics Module
How to import data in to module - DAT02 Shipping Metrics Module? Not sure if I missed this on what but during Sprint 3 I realized there is no data in the module. Thanks
-
Anaplan + Boomi Integration
Hi Team, I have flow which runs using Boomi. In this flow data being pushed from DB to Anaplan (upload). While running this flow, i'm getting below error message. [1001] cannot parse the JSON response. HTTP Response: Unable to complete the HTTP call due to a communication error with the remote server.…
-
Export with same formatting
Hi, Is it possible to export with the same formatting as the module / dashboard ? e.g. I have zeros showing as blanks or dashes, but when exported, it's coming up as 0 in the excel. Thanks in advance,