-
Is there a way to change which browser is used by Excel Add-in for SSO authentication?
Using the latest Excel Add-in, it appears this is using an embedded version of Edge browser (version 95.x). Our organization has blocked this browser being used due to the age of the version. Is there a way to change which browser the Excel Add-in uses for SSO authentication so that it will use either system default…
-
Integrate Anaplan in Power BI
Hi community, Have you guys have any experience integrating Anaplan data model into Power BI? If you do, please share. Our company is planning to integrate Anaplan data soon, and I am just researching for a proof of concept.
-
Introducing Improved Anaplan DX: a browser extension for Anaplan Modelers
We at valantic are excited to share our latest development: Improved Anaplan DX, a browser extension designed to enhance your modeling experience and increase efficiency. Please see below for more details. The extension is now available in the Chrome Web Store (can be installed on Chrome and Edge): For any feedback,…
-
Anaplan Bulk API Exports (Line Splitting on last row of chunk)
Exporting a file that ends up having over 100 chunks. The first and last rows of the files are split across different chunks. Is there a a way to prevent this?
-
How to retrieve the mapping information of import action ?
Hello everyone, I have a task to check in all my import files, which columns are used (that is to say, mapped to a Linitem in Anaplan), which are not. To do so, I need have mapping information for the import actions (all at least which columns are mapped), any idea to do this? Many thanks !
-
Summary method for time
I have a reporting module that shows me gross and net revenue totals by month, with line items for each member of a hierarchy as well as the period. I can select each period to see each month's data, but I'm wondering if there's a summary method I would need to be able to see all of the months when I have the whole fiscal…
-
How can we use OAuth integration with Cloudworks and BQ
We are evaluating Cloudworks to integrate Anaplan with Google BQ. Our security team advised that they prefer OAuth-based integration. I could not find documents on how Cloudworks can use OAuth. Can Cloudworks use OAuth ? If yes, where can I get material to understand how to use Oauth with Google and Anaplan using Cloudwoks
-
Anaplan Connect cannot connect to database
Hi, We recently set up a new database to export data from Anaplan to Azure. The database is a SQL database on Azure VM. I am trying to set up connection. Export out of Anaplan is always successfull, but keeps failing when connecting to the database. Jdbc connection string: Anaplan connect is also running on a VM.…
-
Anaplan error - Error parsing key for this row; invalid data: , , ,
Hi All, When I am importing a file to a list I am getting an error as "Error parsing key for this row; invalid data: , , ," even though there is data in all the columns. Its a transaction data set that I am trying to import into a list with list properties using a combination of columns as unique identifiers. It shows…
-
Integration of custom Machine Learning model's with anaplan
I'm working on a Marketing Mix Modeling (MMM) project to analyze marketing spend across different media channels, calculate ROI, saturation points, etc., using various machine learning models. I'm interested in integrating these models with Anaplan to make them accessible to any brand within our FMCG company. How can I…
-
Get Request from API returns 'success' but doesn't include the desired list of chunks data?
Trying to follow the method described here: And I'm finding I don't get the list of chunks for our file. This has worked using basic authentication in API version 1.3, but we're trying to upgrade our process to Cert Authentication in 2.0. Is there any reason the list of chunks wouldn't be included here?
-
Allow User to Enter Comments at Parent Level?
We have a text-formatted line-item where we want users to enter comments at both the child and parent levels. The current solution works fine for the bottom level, but Anaplan won't allow comments at the parent level (Marketing - Corporate Memberships). Is there a simple fix to this issue?
-
Experiencing Occasional 'Basic Authentication Failed' errors under SSO
We recently switched majority of our workspaces over from Basic Authentication to SSO for security. To populate our models with data that is rapidly changing we push data through our internal data store through an ETL (Workiva formerly known as OneCloud) hourly sometimes more often than that. There is a dedicated service…
-
Dimension limitation while creating exports from Anaplan Cloudworks
I am trying to create an export via Anaplan Coudworks to azure blob. File generated at azure container is blank if I am keeping one dimension(list) in row and the other in column while creating the export. I created another export which had all the dimensions in rows and only line items in columns, export generated for…
-
Anaplan Connect Export stops writing after 30 minutes.
Hi, I have set up export connection to a SQL database. I have 1 connection that takes longer than 30 min to be completed. I have scheduled this one to run overnight. Each time this export is run, it seems that it's timing out exactly after 30 minutes but without a logged timeout error message. See error log (I scheduled…
-
How to make/create subsidiary view?
Create Shipping Export Module and Create a Saved View In the Supply Chain model, create a module to export the shipping costs by location and create a saved view for export: Module Name: INV05 Shipping Export Dimensions: G3 Location list, Time (months) Category: Inventory Functional Area: Inventory Line Item Format Purpose…
-
S3 - Anaplan Integration
All - Quick question on the S3 to Anaplan integration. Does Role ARN ? required in order to establish the connection Thanks Krishna
-
Question on Python Update Data
Hi all, I have been seeing the use case of python to run actions and processes. I am wondering if there is a way we can use python to write data into anaplan? (not in form of importing a list but directly writing to it) For output The use case is that I would like to run 100s of scenarios (through changing the inputs)…
-
Cloud export failed _Cloud works(Azure Blob)
Cloud export failed error while running the clouds works integration with azure blob. Do anyone knows about this error and how to fix it?
-
Adding items to numbered list using Create
I want to achieve this but getting a little bit of a problem: * End User can add an item in a number list by clicking a button. * He can choose Product Family from the drop down (Page Selector). * And after that whatever he wrote in Product Name gets imported to the list under the Product Family Selected. I tried using…
-
Multiple Sheet Add in Connection
Hi everyone, I have 2 questions about excel add in Refresh Multiple Connections function: Does the refresh multiple connections functionality refresh only the dimension selected on the selector (for example July 23) of the module/excel sheet or all the data present in the module? 2. In case of many sheets connected to…
-
Issues with CloudWorks Integration
we have been facing issues with CloudWorks integrations from couple of days. Below are some of the observations: When a integration runs on CloudWorks on one of the model, the whole workspace gets stuck. Integrations are failing with no error logs. Getting notifications about the integrations failing but those actully…
-
change of source model in target model
i am trying to change my source model in target model from actions but getting an error of An import data source ("model/module name") already exists for this object, whereas the saved view used for this action has not been used anywhere else. Can anyone please help
-
Is there a way to add a universal list to all items in a list?
Hi all, Let's say i have a list of Alphabets A B C D E Could I import another excel of 1, 2, 3, 4, 5 to this list Alphabets into A 1 2 3 4 5 B 1 2 3 4 5 C 1 2 3 4 5 D 1 2 3 4 5 E 1 2 3 4 5 Thanks
-
Plan IQ
Hi all, i have been facing an issue while doing the set up of PlanIQ (followed the tutorial on Anaplan Academy) I am stuck at the same moment, when it needs to run the Forecast Action. Do you have any ideas on why it is always displaying the same errors ? I was told to put Internal Access the the list i use (but i didn't…
-
Deploy mode
Hi All, I have deployed a model from development to Production and try to run a script for batch run from other source in production environment, the script was run successfully but data is showing blank? And when i tried to upload the same file manually in production, i am getting error as "Deployed ode is enable for this…
-
S4 HANA to Anaplan - Mulesoft Connector Limitations
Hi, reaching out to see if anyone has run into issues when pulling data from S4 HANA / ERPs into a data hub using the Mulesoft connector. The volume of data is initiating a model save in the middle of the execution (per Anaplan support) and that locks up the model. During this lock up, any batches attempting to load during…
-
Anaplan Tableau Connector New Release
Hi Everyone, Wondering if anyone if using the Tableau direct connector for Anaplan. I know there are some pitfalls and not a lot of flexibility with the current connector, but does anyone know if the new release mentioned in the link has occurred already/what changed with the new release? It's been a while since I have…
-
Anaplan - Informatica Cloud Integration
Hi All, I am trying to run mapping in informatica cloud.Mapping between source and target are valid but while running the mapping I am getting below error: "Operation failed: com.informatica.adapter.sdkadapter.exceptions.MetadataAccessException: [SDK_APP_COM_20000] error [1]". Can you please suggest and resolve the error.…
-
Import Scripts run successfully but target module did not update as expected
Hi, We're able to set up a scheduled import actions using Java scripts with certificate authentication and it appears to run successfully according to the import history, but the target module in ANAPLAN is not being updated as expected. It seems like it is still importing the old csv file instead of the new one. Also, we…