-
Formula error
In my Stat forecast I have some items mentioned as "End of Life" and it has a date until which the item will be active for forecast but after that date it will go inactive. But the formula that I have now isn't giving me forecast for that item. For e.g.- For Item A - EOL = Jan 2025. (so this should give forecast till Jan…
-
How to add colors to worksheet
My current worksheet has color highlight for some rows, now I want to create a new page and add highlight other rows with colors, how do I do that?
-
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…
-
Adding a parent hierarchy to the existing lists
I have a hierarchy of brands which was set up a year ago. Now I want to add a parent to L1 (i.e. L0.5) as a parent of all, which should separate all brands into Private Label and Owned. Because now when I build pages and I want to see only the owned brands altogether I can't do that as in the module the brands are listed…
-
Salesforce CRM Analytics to Anaplan Connector?
Hi all Anaplanners, Does anyone know how to connect Salesforce CRM Analytics to Anaplan to enable one way/two way data transfer? Thanks, Jim
-
Anaplan Connect JDBC issues - SnowFlake - jdk.internal.misc.Unsafe
I have successfully connect to snowflake, and extract file, import to anaplan file csv, but it seems the connect api did not call the action to import into anaplan. (Because I have seen the file of anaplan has been updated, but the process/action has not been launched) It seems the problem coming from…
-
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,…
-
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…
-
Anaplan Connect JDBC issues - SnowFlake - (solved)
I have encountered some issues when configuring and running connect script. But I didn't get a specific error message, as following picture : PS: I have configured the snowflake properties files and java, anaplan connect installed etc. Can anyone give me some tips to figure it out ? Thanks
-
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.
-
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…
-
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?
-
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)…
-
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…
-
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…
-
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.…
-
Conditional Import
I have two columns, Column A and Column B. Column A is a manual input and column B is populated by an import action of the data of Column A. I have created a sperate module with Boolean checks to make the data of Column B not editable using write access driver. However when I run the action to populate column B new list…
-
Exporting CSV from Anaplan, incorrect date displays in Excel
When exporting information into Excel by month it brings the dates through as text, ex “Jan 18” = January 2018 and in Excel appears as “Jan 18” . Conversely when we export CSV files the “Jan 18” is converted to a date format with the wrong year “Jan 18” in Anaplan but = 1/18/19 in the CSV file. Is there a solution for…