-
Apps- Best Practise for older copies
What is the best practice to keep copies of the entire apps page in a periodic manner in case of reference required in the later period.
-
CloudWorks Integration with BigQuery: Understanding the Error Message Table
Hi Team, In the official documentation under "Google BigQuery Permissions" I found details about creating an optional error message table with the following structure: integration_id run_id run_date error_code error_message failed_row While the documentation outlines the table structure, it lacks details on how records are…
-
Model Building
Hello, I have one requirement where line items should be filtered based on the Year(FY24, FY25) Dimension. For eg: there are 12 line items, which contains both text and number formats. If User selects FY 24, The first 6 line items should be shown in the page and if user selects FY25, last 6 line items should be shown . Any…
-
users dimension for filtering
In my model user dimension is used across the model for filtering so that the users do not overlap their data. If my understanding is correct this is the standard practice. I searched community for best practices related to usage of users dimension i could not find anything. So my question is i have a model which is almost…
-
How to Integrate with the API Using a Modified File Name
Hi, Is it possible to change the file name for each integration when using the Anaplan API? We are facing an issue where files get overwritten when multiple API requests are executed simultaneously. To prevent this, we are considering adding a timestamp or making the file name unique before sending it. If modifying the…
-
Issue with ISFIRSTOCCURANCE funtion
Issue: One of our Integration task failed with an Error : Too many cells for ISFIRSTOCCURRENCE calculation: actual=50144479 maximum=50000000 Steps taken to avoid this was to chunk the files to less number of rows. The error still appears. What is the actual reason for the error? Or what need to be done get any error that…
-
Null Pointer error : While exporting data to Snowflake
Hello Team , I am getting NULL POINTER error while exporting data to snowflake , below are the development scrips and error screenshot . Anaplan connect version: anaplan_connect_4.2.1 Snowflake drivers used: Almost tried with all latest snowflake-jdbc-3.13.22 / 3.21/3.16 Error: I am able to import the csv file but it is…
-
Anaplan connection to Azure Data factory ( ADF ) using OAuth 2.0 clients
Dear Experts, we are looking to pull data from ADF into Anaplan. Has anyone tried this integration approach? if yes can anyone elaborate on how to go about it ?
-
Python Anaplan Connector
Im trying to learn about the PYTHON Anaplan Connector, can someone please share the correct documentation starting from scratch and best practices using PYTHON Connector? I need to understand about File upload, File Export PYTHON SCRIPTS how we can implement and what are the Prerequisites.
-
Importing Data into a list from module returns blank
-
How to Enable End-Users to Upload Files in Anaplan UX and Process via ADO
Hi, I’m looking for the best approach to allow end-users to upload a local CSV file from an Anaplan UX Page, but have the data first processed through Anaplan Data Orchestrator (ADO) before importing it into an Anaplan model. Currently, I see that Anaplan UX allows file uploads through an Import Action, but this sends data…
-
Data Export Options in Anaplan Data Orchestrator ?
Hi Anaplan Community, I'm new to Anaplan and exploring integration options for moving data between Anaplan and cloud services. I successfully exported model data to Google Cloud BigQuery using the CloudWorks integration. However, I couldn't find an option within Anaplan Data Orchestrator (ADO) to directly link model data…
-
Forecast Moving Average
Hi guys I want ask you, why doesn't the value on FY25 continue? it stops calculating week 1, I want to continue the calculation (for example week2 in FY25 is the sum of week 52 fY24 and week1 FY25 div 2. Is it possible for me to do that? Week 1 FY 25 = (Week 51 FY 24 + Week 52 FY 24)/2 Week 2 FY 25 = (Week 52 FY 25 + Week…
-
While importing into system, how to highlight data already present in the module/list but
While importing into system, how to highlight data already present in the module/list but not present in the file.
-
Webhook from Anaplan to SAP
Hello, We would like to implement an interface between Anaplan and SAP, where the interface would be triggered only if there are data in the view use for the export. Is there a technical possibility to have a webhook between Anaplan and SAP which would inform that there is data in the view ? Or another kind of webhook…
-
Anaplan - Postman Connection
We are currently experiencing an issue with the Anaplan API when using the OAuth connection. The connection works successfully with one workspace and model ID (specifically in the Development environment), but it is not functioning with another workspace and model ID (Production Environment) and throwing error "404 Not…
-
Integration via Amazon S3
Hi, I created a connection via Amazon S3 without any problem, the status is "Connected", but I don't manage to select a file when I try to create the integration : Thank you in advance for your help. Best Regards Alex
-
source to target data is getting loaded partially via IICS
Hello, i'm fairly new to Anaplan but come from BI products world. I have a situation, an Import action is created in Anaplan dev. This action picks up the .csv file from source location (This has been working perfectly fine in our environment for last 4 years) and loads it in to one of the Modules. This process has been…
-
Does having multiple models in a single workspace (standard or hypermodel) affects performance?
Hi All, I have a query where currently we have 3 models in 3 different workspaces(standard). In all the 3 models we have intergrations running at different times(5-6 times a day for each model) to update Actuals/Forecast from other sources. We are looking into getting a hypermodel workspace for future enhancements &…
-
Anaplan Consultant Expertise Accounting knowledge
Do Anaplan Consolidation /Fluence consultants could not be accountants? How they will understand the consolidation process if they don't have the accounting and practical expertise? Thanks !!!!