Data Integration

Level 3 Sprint 1 Import
Its regarding Level 3: Sprint 1 : User Story says " Import the Financial Forecast data from the Level 1 FP&A model" I have used the "Baseline+Financial+Forecast.csv" file. I am struggling with the import mapping "Time" and "Baseline Financial Forecast" portion. I keep getting failed errors regarding date format…
L2 Conclusion Import Currency Error
I am trying to import Currency List but somehow it doesn't work.I am stuck at this activity. I am also attaching the screenshots of Error. Don't know whether its a mapping issue or something. Also I tried mapping via Name or Code but still it doesn't work.
Default Export Excel Format
Hi, I am keen to have the default export to excel option changed to the xlsx version rather than the 1997-2003 xls format. While I know you can change this when exporting it would make sense to have the newer version as the default to allow for quicker exporting. Surely 99% of users would prefer it in this format ? I…
Level 2 Conclusion Issue on Importing data DEM04 to DAT02
Hi Anaplan Community, I am facing an importing problem. Although I think I'm doing everything as it should, I get an error message every time. I have attached all the pictures and it can be seen that I must be doing something wrong with time mapping. But I couldn`t make it. I really appriciate your help. Thanks in advance.…
Excel Add-in v4.x
Hi, Prior to v4, the was an update.exe file that automatically asks whether you want to upgrade to a new version. Can I confirm that this is no longer in v4 series as the upgrade is via the Anaplan ribbon? Thanks, Alvin
Level 2 Sprint1 1.3.10.3 Import Data into G3 Location List
The expected result is : But the result I got is as below : Can anyone please help me why my result is not as expected exactly? Do I need to delete the rows I have highlighted to get as expected result?
Import and export data treasure hunt
We're restructuring the Import and export data section of Anapedia, and we'd like to find out if our new structure is intuitive. Try our imports and exports treasure hunt and see what you can find! The exercise finishes today, but if you have a spare 5 to 10 minutes, why not have a go?
Level 2: Conclusion Create Inventory Ordering Saved View and Export
For creating the export and saved view for Inventory Ordering, my beginning inventory is different from the data given by Anaplan to check. This is due to the data imported while attempting my Sprint 3 exam to update Submit Purchase Order Request? So shall I delete the data imported to match it to the exported data? Kindly…
Level 2 Activity 2.3.9.1 Import data into DAT03 Historic Volumes module
Hello there, I came across one error when I deal with activity 2.3.9.1 Import data into DAT03 Historic Volumes module at level 2 ( refer to Process failed error.PNG). I have made sure that Actions -> Import Data Sources is correct and updated ( refer to Export.PNG). I have also verified the Source Model ( Source…
Hiding or removing the line item (on the 1st line) of an export from a module
I am performing an export from a module and the user of my export wants to have the extract so that the line item name is not appearing at the top. The line item is sitting on the "pages" dimension on the "pivot" view. In the layout tab, I have it set to: Grid Current Page Omit Summary Items Omit Empty Rows However in the…
Anaplan Connect - Could not load the privateKey for authentication.
Hi all, I'm trying to connect to Anaplan through Anaplan Connect tool using a Sectigo Certificate. I'm able to connect using an hard coded credentials (user:pass) but when trying to connect via Certificate I'm facing the error below. Note: I have received an "user.crt" file from Sectigo on which I ran the following openssl…
Cloudworks export date format timestamp
I would like to have the possibility to define the date format for exports to cloud storages. When you currently export files through Cloudworks you have the choice to tick/untick the overwrite file option. If overwrite is unticked Anaplan adds a timestamp in a worse machine reading format (e.g. <action…
Power BI Connector - Tenant Admin by default
Dear Anaplan community, I need to create some reports using Power BI Connector but it displays only Workspaces on my Tenant by default. Do you know if I can access my other Tenants' workspaces? Thanks in advance, Romain COLIN
how to split a line item in one module into multiple line items in another module
hi Need a help. I am very new (few months) to Anaplan. I got a simple requirement, have to create a new Export module(REP01) from OUT01 module ND Each row in OUT01 will form two rows in REP01. How could I achieve this. Please help. Thanks Module: OUT01 Module: REP01 Regards Balu
level 1 exam activity 4
@Misbah Hi, Can you help me on this? I have imported data correctly and formulas also not giving error but I cannot see data in EMP02 module under bonus, car cost, medical costs and phone costs. Hoping to get response at earliest.
Excel add-in Russian Localisation
As an end user I would like the Excel add-in to support and be localised in Russian.
Level 1 - 7.2.3 - Issue in mapping a numbered list
Hi, I am trying to map the E2 Employees# using source of code as it is a numbered list. However, still it is not displaying the employee names.
Import List from List
In all the model building exercises, we are importing list items from module, rather than importing list items directly from the hierarchy lists. Any particular reason for that ?
Snowflake Connect Null Pointer Error
Hi, I have setup JDBC properties file, and a batch file to run Anaplan connect. However i get Null Pointer errors, which are quite useless as they do not tell you where the issue is. Please can anyone point me the right way? My jdbc snowflake properties file is as follows jdbc❄️//…
2.3.9.1 Import data into DAT03 Historic Volumes module - 9.3 Import Shipping Metrics
I am having issues with 9.3 Import Shipping Metrics. I'm not seeing why I keep getting this error. Please see attached.
Cloudworks configure job to run as another account <Service account>
It would be nice to configure Cloudworks integration to run as "user/account" <Service account> instead of using the current account when you create/configure an integration.
Cloudworks Integration not able to see API files
Hi Team, Our client has decided to use webMethods for their Anaplan integration. When webMethods sends a file through the an Anaplan integration user, the file is set to private and we do not have the ability to change the file to admin or everyone through the API or on the integration user on Actions - Import Data…
Retrieve Line Item Formula from Anaplan with Python VS Code
Community, I have been able to connect Python/VS Code to my Anaplan model. The information I am trying to retrieve is the formulas in each line item. This will help make it more readable. Does anyone have a python code example to get this data from an Anaplan model?
Level 3 Distribution Center Parameters
Here is my DATA HUB modelDistribution center parameters: Here is my target in the supply chain model Here is my import window mapping: My time mapping seems to be correct: Looks like no issue with p3 SKU, and here is my line items: But my import still fails: I tried doing the manual mapping, that seems not helpful too. I…
data import
how to import data from one module to another module when dimensions are not match.
Process not running correctly
Hi, currently have a process that is supposed to take data from one module and put it into another. But currently the process is not working. Screen shots of error are below. Thank you
Populating Numbered List from a Module with 4 or more dimensions:
Use Case: I am trying to create a Numbered List from a module with 4 dimensions typically SKU, Tier, Product and Level & few Line items. For modules dimensioned by 3 lists it is straightforward to create a View as the source of the Import with the 3 lists as Column items and the Line Items as Row items. Unfortunately this…
L2 conclusion INV05 export - import is wrong
Hello. Please help me for settings of exports. I've changed many variants, but it still wrong. The pivot Filter - Months Only Summarize - none I try to export grid or table, but it gives mistake for import. Please, help me for solve.
2.3.9.1 Import data into DAT03 Historic Volumes module
Hi, If I run the process "Import Data from Hub" in the Supply Chain Model , I get the notification below. Anyone who can help to solve this error?
Power point Add-In VS. Management Reporting
Hi Everyone! I have a question in regards to Power point Add-In VS. Management Reporting? For example If people would like to switch from PP to Management Reporting, are they going to have any struggles in regards to functionality etc. Does Power Point is fully replaceable right now? What one of it has that another…

Data Integration

Discussion List