-
How to remove a dimension from a pivot?
Hi, Does anybody know how to remove a dimension from a Pivot? I need to remove "time" from the "Pages" (See below). Thanks Juan
-
API Import Error : There was an issue with your file upload: 500
We had to reset index count of a list after which we imported data using Postman into the module. Airflow DAG for the process which uploads data in the above module/list have been failing since that day when they run for the first time. However, when re-triggered they run without any errors. What will be the solution for…
-
7.2.1 Activity: Import Data into Product Details Module - Invalid line item identifier
Hi, For L1 Model Building activity 7.2.1, I am having some issues importing the data file for SYS06 Product Details module. I am getting the following error "Invalid line item identifier" when importing the file Below my mapping selection Doe Does anybody know what the issue might be? Thank you
-
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…
-
2.3.9.1 Import data into DAT03 Historic Volumes module
i am trying to run process 9 but i got this error can somebody please! help me
-
Schedule model-to-model imports in Anaplan as often as you'd like
Use the native capabilities in CloudWorks to distribute data from the Data Hub to Spoke models, or between different models in the platform, any time you want with its model-to-model import functionality. No activation, add-on services, or technical resources are required to use—everything you need to move data between…
-
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…
-
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!
-
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…
-
Email Notification : Cloudworks
Hello Experts, I am trying to leverage Cloudworks for automation from one Anaplan model to another Anaplan model and just wondering how can I add email ids of the team how needs to be notified on the status of the scheduled job. Currently I get the notification as I am the owner of the integration process in Cloudworks. ~AB
-
Running an Action to Export with a Mapping from Informatica
Hi, I'm trying to execute an Action to export data with the use of a Mapping in Informatica. I've executed many exports with mappings in the past, but for some reason with this action, I'm only receiving the headers. There are no rows of data. The strange thing is that when I run this action directly in Anaplan I get the…
-
Export/Import Time Periods
Hi team, I have a situation whereby users have the option to export the data from a module, adjust the relevant cells & then import the same CSV file to the module. There is an issue with 2 line items that have Time Period as the format. When they are exported the format in the CSV is 'MMM-YY' rather than 'MMM YY' & if you…
-
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.
-
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!! 🙂
-
Anaplan api get lists issue
Hi guys Is anyone having issues with retrieving lists end point via api ? I am getting below error https://api.anaplan.com/2/0/workspaces/myworkspaceid/models/mymodelid/lists {'Authorization': 'AnaplanAuthToken mytokenvalue', 'Accept': 'application/json'} { "status": { "code": 404, "message": "Not Found" }, "path":…
-
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…
-
How to remove the New line / Line break Character
Looking for a solution to remove the line break or new line character from the text formatted line item editable by end users. reading the text from the user editable line item to another line item, in the process want to replace new line character if any from the text. Because of New Line character the data while being…