Data Integration

Conversion to V4 - copy of older version is not made on Onedrive
To upgrade to V4, workbooks that are created in lower versions have to be converted. On conversion, a copy of the older version is supposed to be made. This works on a local drive but it does not work on OneDrive. As most of our files are on OneDrive, this will not work in our business operating environment. We will not…
Unable to open several workbooks with same connection
I have recently been testing v4 of the Add-in. We are current using v3.3. I am unable to work on several workbooks that have the same connection/model at the same time. V3.3 allows for several workbooks to be opened at the same time. I would point to several systems that allow for this, namely, Smartview (Oracle) and BW…
Level 2 1.3.10
Hii I am not getting G3 distribution center column eventhough i created subset for Try it hierarchies I am attaching some screenshots..can anyone please reply where i am doing mistake
Ability to Connect Power Point Add in with Dashboards
It would make every end users' life easier if we have an ability to connect Power Point Add-in directly with the dashboards instead of modules. Now Reporting page coming into action, it will make a lot of sense if we could just create the connection with any page/dashboard and boom power point is ready.
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…
Import data with source and target items differences
Hi All, I need to import some data, but the source items are different that the target items. Source items end with "_EN". What options do i have to upload this data? Thanks,
Using NUX forms can cause rollback on duplicate code input
Hi all, Our team is in the process of converting from legacy/old dashboards, to NUX and one feature that holds a lot of promise are the NUX forms (for the purposes of adding to lists). The old dashboard style made it a bit clunky for creating new list items with controls and prerequisite inputs, but the forms are…
CloudWorks Scheduling by Day of Month
It would be great if we could schedule Imports & Processes during Month End dynamically. e.g. Each Month I need to edit my schedule to update the Start Date & End Date for the relevant month end period. Would be great to have 1st day of month as a selection from Start Date and 7th day of month for End Date as an example so…
Import Enhancement: Tab- Line Items: Being able to select Multiple, All, or blank "Mapped to"
Currently when Mapping a file, view, or similar, if you have extra line items/columns, Anaplan doesn't always identify that a new line item is selected, and takes multiple attempts to have your selection identified. (Bug, and I use Chrome with 90% zoom) Being able to Map everything you are going to map, then select all…
level 2 conclusion DEM04 Demand Saved View
Does the below screenshot look correct for the DEM04 Saved View? The directions say that the product should only have a Product SKU Level. Also, are we supposed to actually export out a copy of the saved view?
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!

Data Integration

Discussion List