Data Integration

Ability to Use Workspace and Model Names within Anaplan Connect 1.4 scripts
Ability to Use Workspace and Model Names within Anaplan Connect 1.4 scripts instead of just Workspace and Model IDs.
Chart UX Constant/Module Calculations
Hello, I am trying to build out a very specific UX dashboard. I am trying to create a chart that displays all the data from a single list AND also add one additional data row that is from another module. Module 1: D01 Slots Pages: Version, Locations, Teams, Resources Column: Time Rows: Slots (Line Item), Products (20+…
Set .xlsx as the default format when extracting data from Anaplan
It is great that now we are able to export data in xlsx format. Thanks Anaplan Team! It would be helpful to have xlsx as the default format when manually exporting data from the system. Current default format is .xls.
Automate current date import using Power Automate
As you all know, Anaplan cannot display the current time from a function, so it needs to be imported into a module by an import action. As described here it can be done via Python: Import and automate current date import to Anaplan. I would like to to show you an easier way of doing it when your organization has access to…
Loading data from another module: Data is ignored when loading to Version
I have one module called DAT01, which contains employee census data. There are two others modules called DAT02a and DAT02b, which are identical with the exception that DAT02b applies to all versions whereas DAT02a does not apply to any versions. DAT01 only has one dimension, which is a unique ID containing a combination of…
10.2.2 Activity: Import Data into Non Employee Expenses Module
le résultat n'est pas le même la première photo est la mienne la deuxième est le résultat du cours
Run process in anaplan from informatica
Is it possible to connect to a process as a target in informatica cloud(hyper connect) and run the process instead of individual actions?
Is there a function that checks the name of a list item in a module and returns specific data?
Hello, I am trying to build a UX dashboard that displays data from two different modules. In D01 Slots (PAGES: Version, Locations, Resource Groups, and Teams. COLUMNS: Time. ROWS: Product Names and one line item "Slots"). Module D01 allows me to see the number of slots each product uses. In D02 (PAGES: Version, Locations,…
1 4 3 2 Import Data and Add Formula
I have reached to this lesson and have been unable to import the csv file 'SKUs.csv) into SYS12 SKU Details module. Can someone advise if I should have time series as the column in the SYS12 module and should I see Time as the target (which in my opinion, should not see Time as source)? If they should not be here, how…
What is Managed By functionality?
Change the file name everytime the user Export
Hi, Community I want to change the export name everytime I export The definition of the name whould be "Module name and Time the user selected" or "Setting name when I create the export and Time the user selected I look for the way to do, but I couldn't find it. I really appreciated if you help Kind Regard
Employee detials
Hi Team, Can you please provide me with download to the link for Employee+Detials+By +Role csv from Level 1 exam. My one was opened and I would like to get it to practice before I have another attempt. thanks Regards, Aye
Import Shipping Expenses into OTH01 Module
Hi, I am trying to import shipping expenses into OTH01 Module but I am doing some wrongs, where? Here are my screenshots: Yes, I see that the capacity doesn't match and tried hide it but it doesn't work still. Please guide me! Mark
2.3.9 Activity: Historic Volumes to Baseline Forecast
Hi, Some values should be in 'Offset Volumes for 1st Forecast Year' line, but nothing! Where am I doing wrong? Thanks, Mark
Cloudworks Scheduling Question
Hi all! We have a client who has specific schedules for when Cloudworks processes should run. For example, we'd only like some master data to run once a month. What I am noticing is based on how we have it set up, the processes never run on their schedule date, and then the schedule turns to expired. Notice in the image…
12.4.2
Create saved view for country margin but the problem is now I have notice that REV01, 02, & 03 Modules don't have any data for FY21 so the model don't look the same when I check my work, any suggestions?
Drill Through/Link External Source Mapping to a given line item
Be able to list or link to a URL the original source information when there is no deeper level. EG. In a source data module, if drill down is completed the admin has the ability to attach a URL to the source material (if it is an extract/table that was pulled from, view, etc.) and if it is entered having the view/field…
OAuth authentication for system-to-system integrations
As an integration architect, I would like to design integrations between boundary systems and Anaplan to use OAuth authentication with a system account. I'll know this is successful when I am able to configure a system-to-system integration to use OAuth, that does not require a user to explicitly approve access in the…
L1 Exam Activity 4 Import Error
I am getting error codes when importing to the EMP03 and SYS08 modules as shown in the screenshots. Can anyone point me in the direction of where I went wrong and/or how to fix it?
Change Source of a Model from Data Hub Dev to Data Hub Prod
Hi All, I am working in a User Story of a Dev Model to change the sources of data from Data Hub Dev to Data Hub Prod. The model In Dev I am working by now has already around 70 actions that are pointing different views of Data Hub Dev as a source of data. In my analysis I found that one way to do the change is: * Go to the…
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…

Data Integration

Discussion List