Data Integration

1.3.6.1 Code and Items?
Hello Everyone, Instructions for 1.3.6.1 go as follow: 1.3.6.1 Create Build Region Saved View Create a saved view for importing: * Module Name: SYS05 Region Details * Saved View Name: Build Region * Include: Code and items Make sure to select SHOW for the Code line item and save the view. This will ensure that as new line…
Can I add drop down list (with data from a list) to cells that are loaded with data?
Can I add drop down list (with data from a list) to cells that are loaded with data? I've added a validate button, but now I'm trying to create a functionality that allows managers to make changes to data if the loaded data is incorrect. I'm having trouble including both a drop down list and prepopulated data in the same…
Prevent Import
Hi, I have a scheduled import into a history module with a snapshot of data, every Friday at 2:00am. This all works. However, sometimes we need to take the snapshot manually earlier in the week, and if this has happened i dont' want to allow an import on Friday. As the import is using anaplan connect and runs every Friday…
Activity: Import Data into FP&A Model
Hi Team, I'm unable to understand the import below shown is my mapping.
Import Final Demand Forecast into DAT02 Module
I'm unable to understand why errors are coming though i think mapping is fine plz help
Enable Power BI Anaplan Connector with SSO
The majority of our customers have an SSO only policy. This means Power BI can not be used by them for additional analysis of Anaplan Data. As a Power BI end user with SSO enabled I want to be able to use the Power BI Anaplan Connector so that I can do additional analysis in Power BI.
Issue with changing source model
Hello, I am currently following the Level 2 - Model Building Sprint 2. I had to change the source model to the Data Hub created during Sprint 1. Unfortunately, the name of the source didn't change when I clicked on "Edit Mapping" but just added the details in "Mapped to". When I followed the next steps to populate data…
Export Actions with timestamps without workspace admin rights
Hi Team, We are running integrated processes using Anaplan API and batch files, with a Service User account setup in Anaplan (non SSO account). What I'm trying to do is to Export from Anaplan an Action List with timestamps into SQL data base. I've made a connection that works, but it requires the User account to have a…
Import data to read quantities per dimension instead of actual data
Hello, I am trying to create an inventory model for a bunch of server farms. i have one csv file with over 15000 machines. For each machine, it shows its location, its manufacturer, the model, how many cpu cores, and a cpu factor. I want to create a module that shows me the average of cpu cores x cpu factor per location.…
cURL fetching an export from API intermittently failing with 500 Internal Server Error
Hi All, We are trying to GET the exports from API but it is intermittently failing. At times when it is successful the response header will have content type returned as "Content-Type: application/octet-stream" and when it fails response header contains "Content-Type: application/json;charset=UTF-8" FYR see below when it…
Jira Integration
How can we integrate Jira with Anaplan. Can anyone please help me out.
Date Formatted Line Item || Default Mapping during import
Hi, I have a date formatted line item in one of my modules where we are importing the data from a file upload. I want to understand that what is the default format anaplan would require 'Date' column in the file if I do not select a custom mapping? Regards, Aakash Sachdeva
Import Error
How to resolved this error.? I have attached screenshot.
Missing employee names in The import of lesson 7.2.3
I am not sure what I am doing. I have read some of the other folks issues. I have made some of the adjustments. I am very new and definitely lost. Any guidance would be helpful and appreciated. Katherine
Google Sheets Add-On
Is anyone else having issues with refreshing data in Google Sheets via the add-on recently? The load keeps freezing or telling me there are various errors.
Importing data level 1 lesson 7.2.1
I have mistakenly imported the data file more than once. How can I reverse the problem or do I have to delete the module and recreate it. Thank you for any help. Katherine
Create filter based on line item
Hello All, I have a requirement where we can create filter based on line item so that we can export them. There are five line items for example - Payroll tax, salary, overtime, incentive, and bonus. The user should be able to check (using the new UX) which of the line items they want to export. Based on the checks, we…
File upload Question
I am trying to upload the file with the data and headers below. But for some reason I am getting an error on the time setting. not sure what to do here or how I should be setting the dimensions of the module.
Ability to exclude time dimension from an export
A description of the enhancement requested: When you export a module, in the Labels tab you have the option to remove any labels for a list dimension on rows and therefore effectively remove it from the export. This cannot be done with time and the customer would like it to be. A story for why they want the enhancement…
Updating an import source file
Introduction The process to update the source file for an import action is not obvious—but it is simple. There are a number of reasons you may wish to update an import source file, and I have listed some below: * Adding or removing fields from your source file and target list or module * Changing the format of specific…
level 2 Activity 2.3.10 Growth Rate Formula error
I have applied right formula in Growth Rate% of DEM03 module.But the hierarchical aggregation is going on.Is it right or Can I make a change so that Hierarchical error will not take place. But when I changed summary setting of growth% from sum to none then only SKU products have entries and levels above it didn't .I think…
How to Find Max for Specific line item
I am trying to create a module with the following line items (dimensioned by products in pages and line items in rows, time does not apply). when a product is select from pages: Max slots - display max value across any month When - display the month that the 'Max' appears Width Factor% - user input Width Interval - display…
Level 1 lesson 7 import of numbered list
I have mapped as per rules define for mapping of numbered list still there is no update in the module after importing the data many times, kindly assist me what i am doing wrong
How to return the month/time period of other line itme
Hello, I have a module with two line items. This module has product list on pages and line items on rows. 'Max Slots' has a formula that returns the MAX value of a given product from another module. For the other line item 'when' I am trying to return the month or time period that the MAX value takes place. I am trying…
Another HUGE release...Anaplan for Microsoft 365 (AM365) - launched today!
See here for the latest Extension Overview Brief - introducing AM365 * Anaplan for Microsoft 365 (AM365) offers a new way to interact with Microsoft Office tools like Excel, PowerPoint and Word. Designed to bridge the Anaplan user experience and Microsoft 365 applications, these brand-new extensions enable users to perform…
Mapping problem
I am not getting how to do mapping in SYS05 region details
When selecting the option to Void a DocuSign document, it should be possible to provide the reason
Currently when the Anaplan user choses the option to Void a DocuSign document, they are not prompted to provide a reason. The resultant email which is sent to all DocuSign signatories states that “<Workflow> has been Voided for the following reason: Not specified”. It should be possible that when a DocuSign document is…
Ability to rename DocuSign Workflow without having to redefine the entire Workflow
It should be possible to rename an existing DocuSign Workflow without having to redefine the entire Workflow. Currently, the only way to rename the Workflow is to edit the Workflow, which requires 3 distinct steps to be completed: (1) Main Settings, (2) Map recipients and (3) Configure Anaplan. The Workflow naming is…
Export with combined dimensions.
Hi all, I have a ask to run a export from anaplan module, currently the export looks like this, but it should look something like the image below: First question: is it even feasible Second question: if it is, what could be the possible workaround for it. Thanks and regars.
1.4.3.2 Import Data & Add Formula
Trying to import the Product and Distribution Center data into the SYS12 SKU Details module. But the SKU file has Code SKU Distr Ctre and Product Code but not Product. Is there a step I am missing?

Data Integration

Discussion List