Data Integration

QUARTER FORMAT IMPORTING PROBLEM
I have a csv file with Quarter value in this column header Q1_2022 we can't change the column header format, so while importing I'm facing problem (Expected fiscal quarter number in date/period). Is there any solution of mapping to import the file without changing the csv file column header? Thanks, Jagadish Dash
disaggregation logic
Hi guys I am working on an example we have a hierarchy as per my image: whenever i input the country wise then the country data should disaggregate to state level and also, from the state level to district level and
Edit Saved View to include New Line Items
Hello! I have a saved view that currently include 16 line items/columns in an exported report. In the exported report, I need to include 3 additional line items/columns, that has been added along with calculations, to the reporting module "REP005 Deferred Tax Report" (see attachment). My questions is, how do I edit the…
PowerQuery Get Data Connection to Anaplan
Could we please have the ability to Get Data from Anaplan in Excel Power Query (not Power BI which already exists).
On-demand event based triggers
Is there a recommended way to utilize "callbacks" or "webhooks" with Anaplan? I have a use case where Anaplan needs to update Salesforce in real-time via an event based trigger. Use case summary: End-user inputs data into a dashboard, then clicks a process button to "submit" the data to an export ready saved view. The…
Informatica to run process
Hi all, I want to run an Anaplan process from Informatica. How can I do it? I do not know what to put as source in the mapping and then the fields mapping as I just want to trigger the process, there's nothing like a source or target here. Thanks
Set the delimiter for CSV Exports
The European format for CSV file is a semi colon delimiter and a comma decimal point. The current behaviour is some European users seem to get an export in this format even though it is not supported in anaplan. The windows/browser formatting seems to take over while other users get the more usual comma delimited file.…
Referencing line item of module into list
Hello Friends, I use the import from module functionality to update the list from a module line item. However since its a manual process and the list wont get updated for any changes in the line item of module unless i again start the import process, is there any way wherein i can reference the line item of module in the…
Anaplan-Excel Power Query Connector
Currently, Anaplan supports connecting to Power BI via the Microsoft Power Query function * https://help.anaplan.com/e1cdf0b7-631f-4cd6-b4df-a5e0927e1ef8-Anaplan-Connector-Power-BI-Desktop * https://learn.microsoft.com/en-us/power-query/connectors/anaplan It would be extremely useful if Anaplan supported connecting to the…
Level 1 lesson 8.5.3 Volume Input modules
I am unable to recognize what's wrong is going on, have change the pivot also, but then also error is there. Can anyone help me finding out what am i doing wrong in this?
Check Import Source - CSV File
User Suggested Feature Check import source of a csv file, to check who uploaded the file. Currently the option to check is through model history but if there was a way to check import source originally (user) would be useful feature.
resetIndex
Hi I am trying to resetIndex on Anaplan numbered list. And I am running a POST through POSTMAN. https://-----/models/45B36E7BA9BB4A0/lists/101000000309/resetIndex - However, I am getting the "threshold has not been exceeded.. " error. The reason I am trying to run it is to ensure that we run the script to reset the index…
Reset a line item
Hello all, I do not find the corresponding course, but during training for MB certification, it was said that the best practice to reset values of a line item (numeric or boolean for example) was to create a line item with no data as format, and to import this line item into the first one. I would like to reset a user…
Which of the conditions require the use of a numbered list
This seems to be a tricked question, I can not figured how this is not correct [Image Removed by Moderator] This is the reference from Planual: [Image removed by Moderator]
Run Process 9 Import Data from the Hub ---
Hi Everyone , While running the process 9 import data from the hub , Am getting error , Snip attached
Process or Action runtime column within Anaplan
Team, It would be nice to have Process/Action "end time" captured within the Anaplan system. Currently, determining "run-time" is a manual process unless we use integration such as Anaplan connect or other APIs. There are several benefits of having this in the system, the one I would find most useful here is while setting…
OEG Best Practice: Import action management best practices
An import action section can quickly become disorganized, making ongoing management challenging. Learn why this happens and explore steps to take to prevent this from occurring. Import action section: why does it become disorganized? Anaplan saves every import action that you perform, no matter what. For a new build, the…
Data integration - Members are not added into numbered list during import with Cloudworks
Hi all, I need to import data from view and I have to import all records from differents views so I am using numbered list for the import. The process is working well when I launched the process with my user, all members are correctly added but not with Cloudworks 🤔 As you can guess, I want to schedule the update and I…
90 days free trail completed but sprint 2 and 3 is remaining.
hii, I completed sprint 1 , and sprint 2 and 3 are remaining for completion, but my free trail with extension is over. Please tell me how to get workspace access again.
Connect Anaplan from Databricks
Hi Team, I need to copy my Delta Tables from Databricks to Anaplan. Can someone provide details/script on how can I achieve this task as there are not much open source details available to achieve this.
import file error
Hi Anaplan Community, Below is a screenshot of the error I receive every time when I try to run a process with and excel file upload. what is more concerning is, if the same file has been uploaded by different user then system works fine? Please let me know how to tackle this issue.
How to make a line item a Subsidiary view
Hi, I'm having trouble making this specific line item in a module into a subsidiary view, in picture attached. The line item i want to make a subsidiary view is Territory. Can i please get some help? Thanks! Amanda
Vidéo - Mettre en œuvre Cloudworks pour automatiser vos imports entre modèles
Bonjour, CloudWorks permet de réaliser facilement une connexion avec des plateformes cloud comme Amazon S3, Azure Blob storage, et GCP, via une interface simple à la main de l'utilisateur. Et il est également possible de planifier les tâches pour importer ou exporter les données avec ces plateformes cloud. Enfin CloudWorks…
Display an action's Start Date and Time (UTC) on a page for the end user to view
Are there plans to allow the Start Date and Time (UTC) of an action to be forward facing to end users? This could potentially be shown as a tooltip where actions are published on to the page.
Anaplan SCIM APIs in Postman
WHAT IS SCIM? System for Cross-domain Identity Management, is a REST and JSON-based protocol open standard created in 2011 that allows companies to securely automate the exchange of user identity data between an identity provider, such as OKTA or Azure Active Directory, and an enterprise SaaS application, such as Anaplan…
Incorrect chunk counts using API
We are getting incorrect chunk counts using API https://api.anaplan.com/2/0/workspaces/{workspaceID}/models/{modelID}/files We are trying to export ~1GB file from Anaplan production model, which is ~100 chunks. But from last week, we are getting random chunk counts for all export processes across all models (incomplete…
Perform Data insertion in Anaplan Module and List through API
I have working on a integartion where i need to push data from a Asp.Net webform to Anaplan Model and List. To perform such action i am using Anaplan API's from the Anaplan suggested method of import: https://community.anaplan.com/t5/How-To/RESTful-API-How-To/ta-p/33579 While running api i am unable to update data , every…
Module 1; unable to import csv files missing csv file.
Hi, I'm not able to import the csv file into workspace ( example Products.csv). Error message displayed: he uploaded file is no longer available; please upload the file again. Can you please let me know where I should find the files? Thank you, Ana Maria
Oauth 2.0
I’m trying to understand if I can use Oauth 2.0 as a way of allowing Anaplan users to provide access to their Anaplan tenants to a 3rd party application. Can I create a single Oauth client in my tenant, and have Anaplan users from other tenants go through the Authorization code grant flow? Or is an Oauth client only meant…
8.6.4 Activity: Add Formulas to Margin Calculation Module
Need Help.. stuck here.. can't go beyond this as the initials shown is 0 even after rechecking several times. All import also seems right. Find the screenshot attached for your reference.

Data Integration

Discussion List