-
Power Bi service refresh error
Hi All, I am encountering a data source expression error in Power Bi service when scheduling a refresh indicating that a column was not found and with a error message "The exception was raised by the IDbCommand interface" . I have verified my data source, and everything appears to be in order. Additionally, when I refresh…
-
I would like to know the maximum amount of data that can be imported into a module from a CSV file.
What is the maximum number of rows and columns a CSV file can be imported into the module when viewed as an Excel file?
-
Bulk copy
Can you set up a bulk copy between models? I have two models. One is a stand alone Financial Forecast with numbers adjusted in various modules and saved views. The version in that model is named the working forecast. The other model is our main Financial Forecast and I have created a version specifically for the data to be…
-
Model Integration details
Hi Anaplanners, I would like to know what are the different ways to fetch information about the integrations (versions, type of integration etc) that are present in my model? Are there any direct API calls using postman or I can find this information somewhere in the model itself? Regards
-
Anaplan & MS Access Transactional API using Python
Hi, I'm trying to update the data in Anaplan module line items directly from MS Access by converting into json format using Python transactional APIs. I'm keep getting the "Status code 400" , "Message - Post body is not a valid json". I have tried by printing the json format before sending the data into Anaplan and format…
-
Anaplan Connect Chunk Splitting
When importing/exporting data using Anaplan Connect 3.0, if the file is 100MB or larger, it will be split into chunks according to the chunk size setting. When this happens, if the file contains multibyte characters such as Japanese, the characters will become garbled. Does anyone know how to solve this problem? Or will…
-
Anaplan batch files need both JRE and JDK or JDK is enough
we are planning to reduce number of software and driver in server. Also we are using batch file to import and export data in the server. Do i need both JRE and JDK
-
Power Shell Script Usage with Anaplan
Hi Team, I have received a project that requires experience with PowerShell scripting. How does it work with Anaplan Connect? I have experience with CloudWorks, but I would appreciate any resources or insights on using PowerShell scripts with Anaplan. If anyone from the group can share guidance or useful links, it would be…
-
Issue in Power BI Service with wiews having dimension on pivot pages
Dear community members, Since a few days, in power BI service I only get the first column of my good old export views having dimensions on pivot pages. This issue only happens in the power bi service but not in the desktop app. Does somebody experienced the same issue and is there a workaround or a fix planned to be…
-
How to create a new import action
I have my csv file and upload in the option "Import Data Sources" and when i click next, is supposed to be appear new windows in this windows map the columns of the new file to the current modules in Anaplan, but when i click Next the system automatically closed that windows and i cannot map the columns, is this the way to…
-
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
-
Retrieve Action and Source IDs
Hi, We are working on pushing data from SAP Data Sphere to Anaplan. We are establishing a connection from SAP Integration Platform to a model in Anaplan. When setting up the process, we have been asked to provide the Action ID and Source ID. Does anyone know how to get those IDs? thanks
-
Is it possible to access Amazon Redshift data warehouse via ADO?
Hello, Brain Trust! My organization uses Amazon Redshift data warehouse and some data we need for Anaplan will be stored there in the near future. The current assumption is that we will use Informatica to query, stage, and then import to Anaplan, BUT…. I really was hoping we could use ADO. In a prior life, I used Anaplan…
-
I want to sum actual data by account and Time.
https://us.v-cdn.net/6037036/uploads/LKPRFTYBDVFT/i-want-to-sum-actual-data-by-account-and-time.xlsx As shown in the image, actual data is on the left and detailed data is on the right. The detail data is created to be in the hierarchy below the Department Code that we want to total. I want to sum from left to right by…
-
;Create a formula without changing past data
Hello, in the past, I had to manually insert data into an input module. Meanwhile, our anaplan models have been further developed and from now on I could automatise the line items of this input module with a formula by looking up this data in another model. But if I start adding a formula for this line item, I am going to…
-
Connecting Shine with Anaplan
Hello ! Do you think it's possible to connect Shine with Anaplan ?
-
ADO - Select File on "Run"
Using Anaplan's traditional data import functionality when an import action linked to a csv file was triggered through a dashboard\UX page the end-user was prompted to select the file to import. The import uses the structure defined from the original file and applies it to the chosen file. Can this same prompt be achieved…
-
IFRS 16 Model - Export file to SAP
Hello, I have a model for IFRS16 calculation. At beginning of year I need to extend time ranges so my Export file for SAP Journal can calculate data. This year I have also done this. However my journal shows only Balance Sheet for Contracts and P&L is not calculated. In what options should I search for settings of Export…
-
How to display one previous month of custom time
I am using a list with its own time. If it is a normal time, I can set it to the previous month by doing Time-1, but I can't do it with my own time. Please let me know how to do this. Thank you in advance.
-
Workspace for practice analplan
I completed all my activities and assessments for The Anaplan Way course. And i want to access workspace for practice, & how can i get it.