-
No of sums in a single line item
Hi, Need to know that how many number of sums we can use in a single line item so that its performance will also won't downgraded. Thanks, Vicky
-
the functionality of supporting multiple connections in one Excel sheet
currently the functionality of supporting multiple connections in one Excel sheet is not available yet in Excel Addin 3.4, i would suggest adding this functionality to retrieve/combine/show different reports/views in one excel tab.
-
Top Level Item Filter to Show Subtotal
Hi All, I have a module with a composite hierarchy below. I would like to filter with a boolean line item for all countries in the Americas and get their total 50 show in the ALL Regions (Top Level Item). Also when the filter is applied I want the ALL Regions (Top Level Item) to show in the list items. How can I achieve…
-
3.3.5.2A Beginning Inventory formula
Hello I need some help in this formula Beginning Inventory: This line item needs to display the value from the Beginning Inventory line item in DAT01 Beginning Inventory module for the first week of the year and the Ending Inventory from the previous week for all other weeks of the year. i have just created these in my…
-
Transactional API for Direct Module Data Access
Hi All, Has anybody built a solution using the Transactional APIs to Retrieve cell data for a view yet. There is reference of Denodo Virtualization tool on forums but it does not work for modules above 1,000,000 cells since there is restriction on the API endpoint.
-
SCIM APIs For Model, Role
Hi Folks, I am exploring the SCIM APIs of anaplan but could not find for below functionalities: - User Add into the Model: - Till Workspace API is available but did not find any tag to add users into the specific model. Same can achieve via UI. Role Assignments: - Could find APIs to add user into the roles like tenant…
-
How do I see true boolean across multiple users?
Module #1 dimensioned by 1) User and 2)Category I thought this would be simple lol but I have an Anaplan module dimensioned by users and category. Under my user i have a Boolean line item called sent for approval as true for one of the categories called refrigeration. Another user has the category "Cooking" as true. I want…
-
Ability to load in Model Quality Metrics from Plan IQ
Currently there is no way to import back in the model quality metrics back into anaplan after your forecast has run in Plan IQ. These metrics would be key to show to a planner when they are evaluating the forecasts. For example MAPE of a particular forecast model. These metrics are exposed in planIQ but there is no way to…
-
How do you import line items from one specific list in a module?
Hi, I want to import data from a module contained in another work space. This source module only has one list with no top level. Specifically, I am trying to import the line items from one list item "Cost". On my attempt, I tried the following steps: Pivoted the list item needed as a page, and the line items in rows…
-
Sync App Graph Legend
PROBLEM When I create a dynamic graph in the Anaplan App the elements sync just fine based upon user selection and list synchronization. However the legend does not sync the same as the actual graph elements. SOLUTION PROPOSAL It would be great if elements identified in the graph legend synced the same as the actual items…
-
UX (board) : Grid - formatting by list levels
Hello, It would be great to be able to apply level formatting for hierarchical lists, as is already possible for lineitems summary and row and colunm headers. The idea would be to apply different formatting for data and item names for each level of a hierarchical list, which could be combined with the formatting already…
-
Anaplan Google Sheets Plug-in
Anyone knows why Google Sheets Add-on would really slow down and then not let me sign in on Anaplan on a specific google doc? Could it be because of the size of the google doc? When I try to create connection on a new blank doc - it runs as expected. Thank you
-
Can we sort data in Anaplan with time?
Hi all, I want to sort data in Dashboards using time, showing the current year 1st and then followed by previous years, is that possible? Thanks in advance.
-
Level 3 Sprint 1 5.2 - Initial Account Sales Target (3.1.5.2)
Hi, I've been stuck on this task for some time and I don't understand what we are meant to do with Initial Account Sales Target Line Item do we use the same percentage Increases from the Data Hub model used for the Initial Country Sales Target Line Item. I'm a bit clueless and would really appreciate any guidance I've…
-
#ERROR! in Anaplan Google Sheet Add on
Hi community, This was meant to be a question, but in the last minute I found out the root of the issue. So I decided to go ahead anyways and post it as a solution, just in case it helps anyone. Using Anaplan add On for Google Sheets, I was getting an #ERROR! value instead of the items of the dimensions of my modules, in…
-
Level 3 Sprint 1 3.2
As a Regional Sales Executive, I need to be able to add an annual percentage increase “stretch goal” to the Baseline Financial Forecast to establish the Initial Country Sales Target for each country that I manage. After completing the necessary model building activities to allow for the input of the percentage increase by…
-
Level 3 Sprint 1 - 5.2 PY Account Revenue
Hello All, I have stuck with formula for 'PY Account Revenue' in 'TAR01 Detailed Sales Targets'. Looks like formula: 'DAT02 PY Revenue to CY'.PY Sales Revenue[LOOKUP: 'SYS03 Account>Product Details'.'A1 Account'] is not correct, because I have incorrect numbers in Check module. Can anyone help with correct formula for that…
-
TAR01 Detailed Sales Targets
Hello, I am having trouble getting my TAR01 Detailed Sales Targets check to reflect "1" for each country/product family/quarter intersection: compared to correct result: Am I on the right track with the PY Country and Product Family Sales line item and underlying Baseline Financial Forecast line item? I believe the data…
-
Employee Expenses User Experience Page
hi users, how to build "Employee Expenses User Experience Page " in workspace, just learning now
-
Help with Formula LI 'Currently Optimized Through'
Hi, I'm trying to create a formula that will pick up the first day when the LI 'Y02 Accounts (Forecast)'.'Closing Balance (01)' is less than 1 million in the forecasting days. The formula below is what I created. It is not pulling in a date. Formula IF 'Y02 Accounts (Forecast)'.'Closing Balance (01)' < 1100000 AND 'S01…
-
Anaplan API V2 Line Item Extraction Missing All Fields
I am currently working to extract line item detail via the API V2. Is it possible to have all fields available via the API show even if they are blank? When pulling detail from multiple models the JSON extract will have a different number of headers/columns as I show in this example. To remain consistent is it possible to…
-
Excel Add-in (Submit data from multi spreadsheets to Anaplan)
Hello, We are using Anaplan Excel Add-in to upload data. We create a write connection with a one module which have Country dimension. Each Country is presented in separate sheet, can we upload data to Anaplan from all these sheets by clicking only one button - Submit? Thank you in advance for help. Best regards, Dominika
-
certAuthGenerator batch file
Hello All I am trying to run the certAuthGenerator.bat file in order to generate the JSON and CA cert info in order to add to Postman as I need to do an authentication test. I have followed all the steps in Anaplan's documentation. I basically have the .PEM and .KEY files and I have followed the direction to create the…
-
Excel Add-In Crashing
Does anyone know what causes the crashes in Excel? When I change the department setting and hit refresh, it closes out of excel entirely each time. any suggestions? thanks in advance.
-
Sum and Lookup using 2 mapping tables
Hi All, I currently have a module with 2 lists with data that need to be in another P&L list via 2 mapping tables using a methodology. Source Data dimensions: List 1, List 2, Time: Month Target P&L dimensions: P&L List, Time: Quarter This is the methodology: * If List 1 Mapping Table.Methodology = Methodology List 1 then I…
-
Private Equity _ performance fee and carried interest calculations
Hi presently I’m in the process of building a hybrid waterfall calculation model —- where I need to show both portfolio company information as well as Investor level carry calculations. I build modules surrounding investor level carried calculations - should I proceed building out modules to incorporate the positions as…
-
Copy paste from Excel to Anaplan
Hi, I have some issues from copy several cells from excel to Anaplan. I can't copy more than One cell from Excel, and I need to copy the value in tje cell, otherwise it doesn't work Do you know how to fix this? Regards
-
Import Anaplan Data into Spotfire
Hello, Could someone explain how we can import Anaplan data into Spotfire? Is there a specific connector that I should install? I heard there is a Auth 2 connection, but I have a very basic level in all this. Don't know how to handle this. Something that explains step-by-step how to make it happen would be awesome. Thanks…
-
Anyone who can help me configure the SAP HANA JDBC driver?
I have a SAP HANA JDBC driver (ngdbc.jar") in my ANAPLAN CONNECT lib but am not able to configure it. I have attached a screenshot of the SAP HANA JDBC driver window. https://developers.sap.com/tutorials/hana-clients-jdbc/jcr:content.github-proxy.1698070514.file/JDBC-Driver-Trace-Config.png
-
Looking for AppHub users to participate in a user research study
Anaplan's User Experience Research team is looking for model builders with experience using the App Hub to participate in an upcoming research study. In this study, you will discuss your experiences with App Hub and Partner Based Solutions. This study will take place between February 7th and February 11th, and the sessions…