Data Integration

Issue in Tabular Multiple Column Export Format
Hi All, I am facing an issue while exporting data from a dashboard by selecting Tabular multiple column export option. Although the table on the dashboard has been published by creating a saved view(i.e. by selecting 'Show Selected Line Items only' option). However, while exporting the data in tabular multiple column(.csv)…
Is Summary not dynamic?
Hi, I have explained everything in the below screenprint. Please share your views on how to handle this case.. Note: The module is data module where all the data is imported through csv file.
2.4.7.1 Create Demand Forecast Grid UX saved view_unable to apply conditional formatting
Hi, I am not able apply conditional formatting to get the result. Could anyone please guide me. required output - Applied conditional formatting - Got below output - Thank you,
How to declare a variable in denodo?
There is a question related to this topic but is not the same that I am going to ask, I need to do something similar as we do in SQL but this time in Denodo. This is in SQL: DECLARE @curr varchar (10); SET @curr = 'USD; SELECT Country, Currency FROM Currencies WHERE Currency = @curr; I have tried something like this in…
2.3.10 Activity: Create Demand Forecast - Workspace Size Limit Issue
Hi, I'm trying to make a new module with these required lists, but I couldn't do that apparently due to the workspace size limit. Could you guys please tell me what to do? Thank you in advance.
How to shorten names for a data flat file you use t import into List
Hi, I have a List that will get populated once a month from a flat file that is given to me from IT. The only issue is that some of the naming in the flat file is too long to bring in as a List. And if the name is too long then Anaplan will not bring in that name into the list. I want to know what is the best way to fix…
Get self-service and lower cost of ownership using CloudWorks
Now that Anaplan has rolled out CloudWorks, more clients are asking about how to leverage it as the main data integration tool for their Anaplan platform. After years of implementing Anaplan at a partner firm using mainly Anaplan Connect for integrations, I have been pleasantly surprised at how CloudWorks performs and how…
Export data using Cloudworks
Hi, Is there a way i can use CloudWorks to export data without using the connector? I cannot select the Target folder where i want to save the extracted file. Thanks in advance for helping. Regards, Tom
How to remove List Subset Item from Labels in Export
Hi I have an export from module, where one of two dimensions is the List Subset Item. When I want to export it as Tabular Mutliple Columns - I see in the Lables only name (connected to the First Dimension). I need to removed List Subset Item from my export, like other labels. I wonder how to do it?
Chunks Error
chunksArray = jsonResponse["chunks"] KeyError: 'chunks' Hi all, I have connected with Anaplan through API with help of Python . Basically I am Exporting file from Anaplan for getting suggestion But now If i am using my credentials and my Model it is working fine. But for others it showing error above pasted. Chunks are…
4.8.2 Activity: Import Data into E2 Employees# List - Struggle to import
Hello, I am struggling to import the employees list during the 4th activitiy. I face the error in the screen below ? Is there something missing ? Something I uploaded in the wrong way ? Thank you for your help. Best regards.
Stuck on model 1 exam activity for question 3
Hi, I am on the exam but noticed my DATA02 SKU Volume only populates for January alone. Every other months do not populate. I have tried tracing back my steps but still no positive result. I have checked if someone else had the same problem within the community but no help still. Screenshot below Plese a
SYS06 7.2.2
Hi! I've been trying to figure out what went wrong when importing products.csv, but I haven't been able to. Every piece of information imported correctly, except for the codes for the first 5 candy bars. May someone assist me with this?
Evolve your Anaplan ecosystem with enterprise governance
Center of Excellence Model Governance Workspace Architecture Data Hubs Data Integration Build & Manage Security In this article, you'll find resources to support evolving your Anaplan ecosystem with enterprise governance. This broad topic was covered in depth during Anaplan Live! 2022 — including focused discussion on…
How to check if authentication works after CA installed on Anaplan
Hi, What is the best way to check if authentication works properly after CA is installed on Anaplan? I followed https://help.anaplan.com/1493b16d-7294-47d6-bd8d-056962e9b8da-Use-CA-certificate-authentication to try to check the CA, but it returns "Failure_bad_credential" I'm not a Postman expert nor integration expert so…
Stomped Level 1 11.3.2 Activity: Import Data into P&L Actual and Budget
I am stomped at Level 1 11.3.2 . Invalid versions, Invalid date or timescale identifier Can someone please help me? Thanks
Mapping Volume Input -Lesson 8
I have done all the solution here for lesson 8, Activity 8.5.3 - Mapping Volume -input. I am still having error. I attached my screen shot - please help
Data Copy for more than 10k rows of a single line item.
Hi Community, What are the possible ways to load a single date into (Date Formatted) line item which has more than 10000 records. I know the few drills which is 1) Importing manually by creating a csv of that single line item with multiple rows 2) Copy down method (applicable only for 10k rows only) Does anyone have any…
Transactional or Bulk: When to use which API?
* What are we talking about? * What’s the differencebetween bulk and transactional? * When to use Bulk API * When to use TransactionalAPI * What else can Transactional API do? What are we talking about? See our refresher here. Anaplan has a set of APIs that allow for a developer to programmatically interact in certain ways…
Ability to Import via .CSV non-US formatted dates
Looking for an enhancement to allow non-US users that don't use US formatted systems to be able to upload .CSV files that contain dates. Currently any non-US formatted files will cause an incorrect date to be populated without any errors or notifications.
3.3.3.2 Importing data into DAT04 module
Hi, I am trying to import the data from the Data Hub model DAT04 Distribution Center Parameters module into the Supply Chain DAT04 Distribution Center Parameters module. My issue is figuring out the correct time dimensions. I am initially going with YYYYMMDD. Could someone point me in the right direction on what to think…
Export Top Level item using Tabular Multiple Column
Dear Anaplan Community, I would like to export data using Tabular Multiple Column (to use it later as export action in Power BI with Anaplan Connector), including the top level item of my list. In the export definition, I did NOT select "Omit Summary Items", however, in my export I don't see the Total row. What am I doing…
2.3.9.2 Update Historic Volumes for Baseline Forecast_i am not able to get data
Hi, I have used below offset formula. IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0 I am getting all zeros also my volume line item data got blank. At first I was able to see data. But now both the line items showing data as 0. Could anyone please help me. refer attached…
Level 1 Exam Activity 4
When I am importing the data nothing seems correct. Role is completely missing. Please help I am on activity 4 right now.
3.3.3.1 Create Distribution Center Parameters Module
Hi everyone, thanks in advance for any help! I have attached several pictures including my blueprint view and grid view of each module. I believe I have the import set up correctly, screenshot attached. I am receiving "Invalid data or timescale identifier" errors for 371 entries, but I am getting 1484 Updated entries when…
6.6.4 Activity: Add Time Settings by Year Module
Hi there, I am having trouble with this activity. Instead of showing the years side by side, it shows them on separate pages. The second picture is what the module should look like. I have also included the blueprint view. Any idea what I'm doing wrong?
2.3.9.1 Import data into DAT03 Historic Volumes module_unable to run_getting below error
Hi, I am not able to pull the data into supply chain model. Could anyone tell me adjustments in order to avoid errors in the import process. I am getting below error screen. Thank you,
Integration acknowledgement to Anaplan
Hi, In the scope of an integration from Anaplan to a target system using Mulesoft, I want the best and most efffective way to perform "Ready" and "Success" flags. I explain : Mulesoft flow will use a scheduler to connect to the Anaplan connector at a regular timing. If the Anaplan user performed a new calculation and have…
is there a way to forecast expenses by vendors?
I'm trying to forecast the details by department's with their vendors, like for example Anaplan as a license vendor I want to forecast by that line of expense as part of the Technology department that eventually will roll up to the Software expense P&L as part of the total company. Not sure if I need a list for Vendors and…
Get started on connected data architecture
In this article, you'll learn about the different integration options in Anaplan and discover how to leverage them to maintain and automate your ecosystem. Then, learn about data hub best practices and how to operationalize your connected architecture best. Here you'll find a consolidated view of useful links and key…

Data Integration

Discussion List