-
how to pull Date from the required Date
Hello team. It is very difficult to explain in words what I want to do, but I will try. everything should be clear in the screenshot. I have a LI: days shift - the number of days for which the data will be shifted. I have a date - just START() and date days shift after - the date on which the data will be shifted. In the…
-
How I Built It: Number format converter (thousands and millions)
Hello Anaplanner Community! I’m excited to participate in another ‘How I Built It’ video with a Number Format Converter (thousands and millions) tutorial. This video walks you through how to dynamically update UX grid number formats on all tables and charts. This enables users to have different number formats enabled for…
-
Line Item Name change
Hi All, I have created a mechanism by which Line Item name can be changed using a Process/Import. It works perfectly fine in Standard mode. But, in deployed mode it shows an error " Deployed mode is enabled and you cannot change the structural data of this model. Change to standard mode if a structural change is required."…
-
CA Certificate Quick Start Guide using Sectigo
Creating an Anaplan CA Certificate using the Sectigo Personal Email Security (S/MIME) certificate involves several steps. Here's a quick start guide to help you through the process: Step #1: Purchase the Sectigo Personal Email Security (S/MIME) certificate from Sectigo's website. You can find it here. The cost is $15 for a…
-
Actuals and Forecast input in same module
Hi community, I am going through something as below. I have a module inp01 which I want to use for end user input for forecast. In the same modules I have actuals periods and forecast periods. Users want to see actuals when entering forecast. This means I need to pull actual from a module dat01 into this input module and…
-
Have multiple models in a single UX page. How do I segregate line items?
Hi all, I have a UX page which has multiple models as shown here - these are the models associated with the UX page. Now, I have a line item in Prod_1 where it shows a status message for whether an action is run or not. Now, the problem arises when the user changes the model to Prod_2 - then the line item shows a…
-
Chart Customization: Conditional Formatting for Chart
Hello Community, I'm wondering if there is a way or workaround to apply conditional formatting on chart text/numbers. Example: Red color font for negative numbers would looks more clearer to end user when it comes to chart (combination, line, column). Any ideas would be much appreciated! Thanks!
-
How to Retrieve the List of Apps and Pages Using Anaplan API
I have successfully obtained the authentication token and retrieved the list of models using the API. However, I am unsure how to retrieve the list of apps and pages within a specific model. Could you please provide guidance on how to achieve this?
-
Ability to add users to Anaplan that don't have a valid/usable email address
Description: Need to be able to add users to Anaplan that don't have a valid/usable email address. Such accounts are usually created to run jobs from source to target solutions. In this case, we want to create a System Account and use the System Account to kick-off the Anaplan Connect jobs. The System Account does not have…
-
Creating and distributing formatting themes in Anaplan XL Reporting (AXL)
Creating formatting themes in Anaplan XL Reporting (AXL) ensures your Grid Reports look professional, are easy to read, and match your organization’s brand standards. These tailored formats help you create visual consistency across teams and over reporting cycles.This guide covers two approaches for creating and…
-
Worksheet: Pivot to keep original selection
You can only pivot on an Custom view. However you make the selection of the line items that you want the end user to see. As there might be calculation items, formatting or headers. However when the end user pivots all items come available that make no sense to the end user. Would like to keep the original selection or…
-
3 Improvements for Comments in the New UX
Hi, I'm missing 3 basic capabilities on the current comments' fucntionality to be able to use it for my clients: 1- Comments are not flagged to end user 2- Not recorded in full context (in all dimensions I'm looking at) 3-No option to publish or export from Anaplan This custom fucntionality I built allows me to overcome…
-
List of subprocessors
Anaplan provides documentation that lists the affiliates and subservice organizations that are material to the provisioning or support of our hosted service. For the latest information regarding third-party subprocessor vendors, see the current list of subprocessors. To subscribe to this page and receive notifications when…
-
How to dedupe txn assignments on owners that appears in multiple assignment columns?
Hi all, I have a module, which is dimensioned by Txn, and within this module, I have a few columns where I can assign owners. Txn Assignment Module: Parent Account Name Oppy ID TXN Name SOL Terr SOL Terr 2 SOL Terr 3 BMO 111 1 Loner's Territory BMO 111 2 Loner's Territory BMO 112 3 Loner's Territory I want to create a…
-
Dependent Context Selectors
Add the ability to filter context selectors based on a selection in another context selector (like in already existing dependent drop-downs)
-
Dynamic Workflow Design
Hey builders! I'm tasked with designing an approval process through Workflow and doing this for the first time. This is a CapEx Request approval flow in which CapEx Projects roll up to Profit Centers. Approvers are assigned at the Profit Center level and go through several sequential stages of approvals. Below is my 2 step…
-
How to Enable Multi-Selection on Page Selectors for Role-Based Access in Anaplan?
Hi Anaplan Community, I'm currently working on setting up role-based access controls in one of our models, and I’m looking to enable multi-selection on a page selector (e.g., for cost centers or functions etc.) so that users assigned to a role can select and view multiple items simultaneously. Here’s the specific scenario:…
-
Input Values using UX Format
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: When using the new UX functionality that allows us to alter the number formatting display for different list items - e.g. the line…
-
Saving any data against parent members in a flat hierarchy or derive their levels.
Hi, As part of our use case, we need to publish org charts. After careful consideration, a flat hierarchy works best (not as per best practices, I understand), but when it comes to publishing KPIs on Pages, it seems almost impossible to calculate something at parent level. e.g. Here is the list. It's a flat Hierarchy How…
-
Compare/Sync new module that is working properly from Dev to PROD model _no amounts in PROD
I have created a Module "report" in DEV and it is working properly there, then I used Compare/Synce to bring into PROD, but for some reason it is not working properly in PROD. I have not amounts in PROD. I did check for any missing constants. Can anyone help with this issue or any advise?
-
Restore revision Tag
In ALM, revision tags aims to represent a certain version of a Model, it would be convenient to be able to restore them.
-
Set text encoding format for anaplan connect script upload
Hi, I would like to specify in an Anaplan Connect script that UTF-8 text encoding should be used for the file I am uploading. Does anyone know the command for this, or another way to make this happen? Thanks!
-
Setup your ADO Demo using an AWS S3 Connection
Author: Noel Rocher, Partner Success Manager at Anaplan The problem statement "I would like to Demo the ADO S3 Connector with a CSV file hosted on AWS S3 as an ADO Data Source." The solution Use a free AWS Account to host the example CSV file. Steps to take We will walk through how to setup an AWS environment using a free…
-
Performace of using LOOKUP and SUM in the same formula
I've heard many times not to use LOOKUP and SUM in the same formula because it negatively impacts performace. However, I'm looking at the "calculation effort" cell and it doesn't appear to be negatively impacting performance much at all. I have the option of using some if statements instead of the SUM formula in my…
-
Fp&A case study access
Hi, I am not able to access 299 FP&A case study. Please provide the access for the same. Thanks Nitin
-
2.3.8.2 Import into DEM01 Module
Hello, I'm attempting to import Volume Growth Rates.csv. When mapping the time (column headers) on the file, I select Periods, but there is no Y-M or M-Y option. I assume something is messed up that I'm unaware of. Any feedback would be appreciated. Sean O
-
Exactly which models are used for Level 3 training?
In 1.1 Level 3 starter model, it mentions downloading "Level 3 Model Building Start" and "Level 2 Data Hub Start". When I get to 4.2 Connect the Dimensions, it mentions a FP&A model. I went back thru the previous lessons for level 3 and I'm not finding anything about downloading an FP&A model. Not sure if it matters or not…
-
Count Unique Items Function
Hi, I have 2 lists, 1 is products and 2 is numbering - see screenshot. I have a module where it is dimensioned by product and the numbering and I want to count the number of unique values. Based on my screenshot, it should be 15. I saw there was a formula - isfirstoccurrence, but I'm not completely sure how to use this.…
-
An 'Overall Total' label on top of a stacked column or chart
Description: I would like to add an "overall total" data label to the top of a stacked column or bar chart. Example: We are looking at whether our new Agreements come from Existing Customers, Previous Customers, or Brand New Customers. But I also want the overall total represented on the graph as a data label.…
-
Ability to Post Images Behind Firewall
Just curious if the Anaplan "images" card has the ability to post images behind a firewall? Or do all images within Anaplan interfaces need to be publicly available? I saw in a thread someone mentioned an "internal server", but what I'm not clear on is how to configure that, or if the "images" feature has any way to…