Data Integration

Use value referenced from a diff module
Hi All, noob here, just started my Anaplan hands-on journey today. Hope you can help me 🙂 I'm looking for the right formula to get value from a module to a different module based from an existing module data. Below I have two modules. Loans and Lookup Rates In Loans module, I have two line items called Term and Rates. I'd…
Level 2 Model Building conclusion - Import
Hi, I am having some trouble importing the Shipping cost export into the OTH01 Non-Employee Expenses module. I am getting the below error. I have also provided additional screenshots. Can someone please help me on where I may be going wrong? I'm so close to finishing up Level 2. this is one of the things that is tripping…
Remove a selective access by import
@Tomishand I recently needed to have the ability to remove selective access for certain users from a selection module and a model-to-users import. The documentation on Anapedia is not very clear on the subject so I thought I’d detail the steps here. We import the code of the items to add in the Read / Write though…
Excel Add-in No Access Error
Hi, The following problem occurred : Excel Add-in does not allow me to look at the Saved Views of some modules, giving the error No Access. It is important to note, that the modules themselves are large, but there is much less data in Saved Views. Is there any solution to this problem, provided that you do not want to…
Region importing issue at 1.3.4.3 Update SYS07 Location Details Module LEVEL 2
Region importing issue at 1.3.4.3 Update SYS07 Location Details Module LEVEL 2 While importing the location.csv into the SYS07 Location Details module, the region part is not uploaded properly. why? because: It is the reason that region flat has 3 line items: AMER, EMEA, APAC. However the csv DATA file attributes 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
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
Lock overwrite of snapshot
Hello, I am currently working on a scenario planning model, where I have two custom versions lists. My first list is a "modeling scenario" list, which is user editable. And once the users decide to lock their assumptions, they create a new "snapshot scenario" and run a process to copy over the data from the modeling…
CloudWorks - Possiblity to launch processes without being necessary to choose Datasource or Target
As Model Builder/ Data Integration specialist I would like to be allowed to create a Process in CloudWorks even it is not chosen a Datasource or Target. CloudWorks could be very useful tool to schedule data integrations between Anaplan models. Currently, this is not allowed and it is received the error: "Connection and…
Exporting data from Anaplan to Qlik sense.
Hello team! I am trying to export data from Anaplan to Qlik Sense and I am following this documentation. However, I could not download/install the Rest connector that mentioned in the documentation. It looks that it does not work. Is there any other ways to Export the data from Anaplan to Qlik sense. Thank you!
8.5.2 Activity
Hi All, For activity 8.5.2 I am trying to import data into the price book module. However is picking up the Time dimension and it should according to the learning material. See below how looks now This is how it should be Does anybody know what the issue might be? Thanks
REST API-Import error
Upon importing into the Anaplan model using Postman, we get an error. The steps followed and the error screenshot(highlighted in red) are attached in the file. Kindly have a look at it. I will be thankful for your solutions.
Anaplan and ServiceNow Integration possible ?
Has anyone connected ServiceNow to Anaplan to display the ticket information on dashboard ?
Easier Model to Model Data Transfer
Are you transferring data between your models or do you want to transfer data between your models? If so, do take a look at our Cloudworks functionality. This article introduces the concept of the new Cloudworks features and functionality and including details of how to set up. Check it out. Remember: You can't plan…
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":…
Import Data into Product Details Module
Hi I'm struggling with the 7.2.1 Activity: Import Data into Product Details Module. I have attached the screen shot. Can I please get some help on this. Thanks
API Calls for "Export PDF" in Reporting
It would be great if Anaplan had API's that could call for the "Export PDF" in reporting. Allowing for this would give customers a flexible way of automating the exports at whatever consistent frequency needed. Thank you..
Anaplan Connect Export script
Hi, I am getting error when I use the following script for exporting @Echo off set AnaplanUser="XXX" set WorkspaceId="XXX" set ModelId="XXX" set Operation=-service "https://api.anaplan.com" -auth "https://auth.anaplan.com" -export "ABC" -execute -get "D:\ABC.csv" rem *** End of settings - Do not edit below this line ***…
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…
Data Hub to Spoke Automation - is it possible?
Our organization uses Mulesoft to get data from source systems into the Data Hub on a regular, automatic, scheduled basis and has been great. One of the issues we face having 4+ spoke models with 10+ data imports each from the Data Hub is that there is a lot of "button pushing" required on a daily basis. For example, Sales…
[Start Here] CloudWorks—This is how we use it, Part 1: The basics
Welcome to this three-part series: CloudWorks—This is how we use it. Here we will help you understand why and how to use CloudWorks, covering the basics, setup, and APIs. Let's begin with Part 1: The basics What is CloudWorks? CloudWorks simplifies the data integration process, allowing end users to easily access the data…
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…
Selective access for integration admin role
Allow selective access for integration admin role so that the admin will only be able to setup the schedule in Cloudworks for the actions for which it has access. Currently if you assign someone integration admin they will be able to setup any action in cloudworks It might cause security issues when data is very much…
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?

Data Integration

Discussion List