-
Data load to SQL using JDBC connection failed : Cannot deserialize value of type
Hi Team, one of the export from Anaplan to SQL tables failing with the following error message. This script ran successfully till 27th Aug and it was failing for past 2 days. No changes were made and it was the same export script and JDBC properties file and same target table is being used. Appreciate for your guidance to…
-
New UX and Management Reporting: Recommended Visualizations
When creating pages and reports, if you have already published a grid to a page, it would be helpful for Anaplan to suggest a visualization that corresponds with the published grid. Depending on the data, Anaplan would suggest the visualization that is the most meaningful to telling a story related to the data. (Bar vs…
-
Level 3
Should I build the dashboards in the New UX environment or the Classic environment?
-
Converting a Classic model to Polaris
Hi, Is it possible to simply port an existing model built using the classic calculation engine into Polaris? Thanks,
-
Creating and measuring value from Enterprise Performance Management solutions
Author: Mitch Max is a Certified Master Anaplanner with over 10 years’ experience in implementing Anaplan solutions, and 40 years' experience guiding and advising financial services organizations on best practices for Enterprise Performance Management. Currently, Mitch leads the EPM practice in North America for Lionpoint…
-
Subset for Versions
Adding subset to Time Ranges is of great help. On the same line, there should be an option to create subsets for versions. In our use case, we have 5 versions (Plan, Actuals, Custom 1, Custom 2, Custom3). We want to use different sets of versions for different modules based on the requirement. Current functionality gives…
-
Level 1 Exam - Activity 5
Please confirm if the formula is correct for Medical Costs. I missed the link now (and a bit lost),since My question 5 got wrong.I undertand model building activity in Question 5 is to be proper to answer question 6. Now i want attempting Question 6 and not clear what formula to use for answering question 6. Urgently…
-
Data distribution design from Data Hub to multiple spoke production models
Author: Hanwen Chen is a Certified Master Anaplanner and Principle Solution Architect at Anaplan. Use case You may have encountered a situation on your Anaplan project where the model size is too big when you try to load data from different business units (BUs)/GEOs/product groups in a Data Hub into a single spoke model.…
-
CloudWorks - Model to Model Processes
I am trying to schedule automated Model-to-Model processes using CloudWorks so that it doesn't have to be done manually by a human. What I've noticed is some of my Actions within the automated Process don't run properly when CloudWorks runs it vs. when I manually run it. It seems that Cloudworks, "Internal (Full Access)",…
-
Duplicate Rows or Columns Excel Add in
After closing and reopening an excel add-in linked workbook I am seeing the attached error. The workbook worked fine before being closed. It has also broken the connection on another tab that was working correctly, I think this may be a separate issue.
-
Time filter not working properly
Hi everyone, I have a grid where i show Products in rows, time/multiple line items in columns (Sales, Py Sales, %growth etc..). I want to control the time dimension based on selector provided to user (Attaching Screenshot). There is a final time filter line item and it is at month level and works fine if i use it when…
-
Gantt Chart Card
There is a center alignment of row header text on the Gantt Chart card, which makes hierarchal presentation impossible. You are not able to differentiate any of the children from the parent line items as all are in the center. This one aspect renders this functionality, useless unless the center alignment of text can be…
-
Formula to allow duplicate
Hello, I am trying to make a formula in order to be able to create duplicate codes. At the moment my formula goes like this: IF Boolean THEN Concatenated Code ELSE Blank And I want for my formula to do this : IF my boolean is checked, then my formula should return the Concateneated Code but i want to allow a duplicate not…
-
Anaplan on Mobile Browser( Safari )
Experts, I am accessing Anaplan ( UX pages) through safari browser on my mobile and tying to export the page using the "export to pdf" option. I am able to download the pdf but with no data in it. The pdf is blank ( off course I have the right data access and able to download on the pc/laptop). Could it be a bug or…
-
Boomi to Anaplan Connector Failing - Password expires every day
We have Boomi integration to push data from Netsuite and Openair to Anaplan. Boomi is using Basic Authentication with Email and Password and WE DO NOT USE ANY SCRIPTS. Just one connector object with Basic Authentication and is the only place we give the password and user id. All the jobs keep failing early morning every…
-
Set up Aligned DCA and Selective Access Management
Author: Kay Kuang is a Certified Master Anaplanner and Principal Data and Insights Architect at Anaplan. On a list level, you can use two ways to manage the access: Dynamic Cell Access (DCA) and Selective Access. There are benefits and limitations for both approaches. I'd like to share an approach that could leverage the…
-
Python API - 401 - 'Auth scheme not supported - AnaplanCertificate'
Hi all, I tried to use the certificate authentication method with the Python API. I used one of the many Python scripts provided but I get a 401 Response : 'Auth scheme not supported - AnaplanCertificate'. Do you know if it is required to enable the Anaplan certificate authentication method somewhere in order to use it ?…
-
Activity: Prepare Data Exports - comparing results to INV01 Inventory Ordering.csv
In the Level 2 Conclusion, Activity: Prepare Data Exports, Anaplan gives a csv to download and compare our results to. Is anyone else having issues with their numbers tying out? After a lot of analysis, it seems the Weekly Order Schedule that I uploaded from the Level 2 Sprint 3 exam is not what should actually be loaded.…
-
Time dimension formula
Source Module has Year, Target module has Months. Source - Time dimension (YEAR), Cost center dimension, Line Item Target - Time dimension (Months), Cost Center dimension, Line item Source has rate by year, for example for FY23, Want to bring FY23 rates to all the months in target module. What formula would i use in terms…
-
New UX - Allow page builders to enable / disable the "Model is busy" notification
It would be great if page builders are able to control if the "Model is busy" notification appears on a page. We have been recently seeing instances where the "Model is busy" appears on worksheets for a few seconds, which causes the whole table to "Jump" around which some end users have voiced grievances to.
-
CloudWorks - possibility to cancel Export Process
It would be nice to have an option to stop export process to external data bases in CloudWorks. We ended up a few times with situation where a process exporting data to Google Cloud was stuck for 16h and it could not be stopped by us or by Anaplan Support.
-
Cloudworks - view the queued processes and/or cancel process queuing
In case of Anaplan issues with Cloudworks servers, processes that were on schedule start to form a queue that is released once Anaplan solve the problem. We ended up a few times in situation where the same 30 min process (normally scheduled every 2h), run 3 times one after another. This is causing problems with other…
-
Update Current Period Action
From April 24, 2021, model builders will be able to update Current Period via an action. Workspace Administrators (WSAs) can always update the Current Period manually via the Model Calendar, however, this may not always be convenient. The Update Current Period action enables the WSAs to increase efficiency and reduce…
-
January 2024 Community Member Spotlight: Tristan Silverio
We are thrilled to kick off 2024 with our latest Community Member Spotlight, @TristanS ! Tristan has been part of the Anaplan ecosystem for the last eight years and an active contributor in the Community for nearly seven years. Continue reading to get to know Tristan, his inspiring Anaplan journey, and contributions below!…
-
Formula
Hi, This strikes me as a very simple question, but I cannot seem to find a working solution. I have a module which list a number of Farms
-
How to mass-delete data from a List
Hi experts, Could someone give me a way to mass-delete data from a list? There are 300,000 of product data in the L_Product, and when I try to select all and delete them, "Cannot delete over 10,000 records" error appeared. Regards, inoue
-
Formula SUM
I have A List of Farms - 'FarmNames' - showing the Farm name, and a Property - 'Shop NameShop Name' -which shows the shop the farm serves. A module - 'Farm Apples' - showing the name of the Farm, and the manually entered number of apples by month for the past two years, where apples is the only line item. I want to show -…
-
Assign values to duplicate items
Hi I have below module that is update every few days UID Name From Date To Date 1 A1 17-Jan 2 B1 17-Jan 3 C1 17-Jan 4 D1 17-Jan two records were updated when the next time(eff from) the job runs like below UID Name From Date To Date 1 A1 17-Jan 2 B1 17-Jan 3 C1 17-Jan 4 D1 17-Jan 5 A1 25-Jan 6 B1 25-Jan I want to…
-
Is there any way to export the line items wise view, by using export action(date format line item)
Line-item kept in page selector as Date format
-
Linking Personal Pages
Hi there, upon a quick search in Community I did not find anything about this issue. Please let me know if it is a known issue. I have created 2 personal pages, and linked perosnal page A to personal Page B using a Text Card. When using that link to go from Page A to PAge B, Anaplan does not find the Page B. Still, I can…