-
ADO connection from postgreSQL
Hi everyone, I am trying to create a connection ADO from PostgreSQL, but I consistently receive the following error: Failed to establish a connection The following message was sent from the target system: The SSL certificate is either invalid or not in unencrypted PEM format. Please check your certificate and try again.…
-
Lookups to apply to LISS Parent Line items
Hi Anaplan Community, I'm encountering an issue with my Anaplan model where a lookup function isn't picking up values from line item subset with line items that have "Is summary" turned on. If I keep the "Is summary" checked in the source module, the only way I can retrieve the values in this line is by using the "SELECT"…
-
How to Implement Selective Access with Flat Lists
Hi Anaplanners I need assistance on achieving this. I have: Flat Region list (e.g., Region A, Region B…) Flat Retailer list (e.g., Retailer 1, Retailer 2…) In the spoke model, these become a composite hierarchy (Region → Retailer), which makes selective access easy. But in the Data Hub, the lists are flat, and I want users…
-
FCR: Improve input parameters for calculations
When we have to run calculation for a specific entity, it can we very time consuming to select that entity, because we have a rather deep hierarchy for entities. It would be so much more convenient if we can also enter the the name manually. Next, please show the parameters from the prior run. When the prior parameters are…
-
How connect ADO TO FCR
Hello, I want to connect a data set or a transformation view of ADO to FCR. I already have the staging tables and data imports ready in FCR, but I don't know what steps I need to follow to make the connection... Is there any documentation or a guide?
-
Getting data integration right: Best practices for building robust, scalable connections
Author: Dmitri Tverdomed is a Data Architect and Director at Zooss Consulting. Data integration isn’t just a technical exercise anymore — it’s foundational to a business’ ability to move quickly, make informed decisions, and scale sustainably. Whether you’re integrating Anaplan with upstream data platforms or pushing model…
-
New User Experience (Report) Filter by user bug?
I have a question, is this a filter bug? The initially setup for this slides is based on Store A (with 5 years data), but then after i tried change to 4 years, 3, years, 6 years, the filters doesnt apply even after refresh. It only reflect when i go to the card configuration > filter > apply. Store A with 5 years data…
-
Forecaster Explainability Results Clarification
We transitioned from PlanIQ to Forecaster and started importing explainability results into the model. But I’m struggling to interpret some of the since there is no information in Anapedia. Here are examples from the sales explainability results list: Historical: trend (ETS, ENSEMBLE) Historical: linear_trend (ENSEMBLE,…
-
Do scheduled CloudWorks actions run in parallel or sequentially?
If we schedule two CloudWorks actions to start at the same time, using the same source model but different saved views, and updates two different target models, will they run in parallel or sequentially (with one finishing before the other starts)?
-
BETA View - Search Module option and the Export Modules functionality
Enabling the Search Module option and the Export Modules functionality in the Beta View version would be extremely helpful for model builders. While optimization it will help to find where module published on UX and referenced.
-
Level 1 model building - Numbered emp
Required import My import Can someone help with this? How to get the name of the employees in above e.g. instead of #1039 get Shala Engle.. Thank you,
-
Online Access to Fluence Training
I know its a bit early (and a bit cheeky) but wondering whether the usual/fab/free online training is in the pipeline? 🤞 Thanks M
-
Dividing (not formating) all the results by 1000
Hello, Is there a quick way, in Anaplan XL to divide all the results by 1000 without creating a measure for every row or every column?
-
Subset Update on Selective Access Enabled list - Workaround Suggestions?
Hi All, I'm Currently Optimising some of our Cell-Count Intensive Reporting Modules, I've an almost working solution except for this limitation I'm facing. We've around 5-6 Reporting modules in our model which is Dimensioned by Levels of Promo Hierarchy X Users, promo Customer Hierarchy X users. Since the promo customer…
-
Role based security filters for Anaplan XL reports
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: We have multiple legal entities, and each entity contains the same set of functional departments (HR, Finance, IT, Administration,…
-
Trash Bin in ADO
In case an object is deleted by error, it should be retrievable back from a trash bin.
-
How to Combine AI Technology with Anaplan
Any idea —- How can an AI‑driven monitoring layer be built for Anaplan integrations to analyze logs, schedules, and execution results, and generate contextual alerts for support teams when failures occur ?
-
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…
-
New UX : Source model selector unsable from page to page
Hi Sorry for the repost if somebody already realized this issue. A client implemented to new ALM feature for the standard UX. She realized that the selector can randomely switch form one source to the other while switching the page. Of course it's very dangerous. She is performing some UAT on the DEV and suddently she…
-
User Access Management in the UX
Author: Lis de Geus is a Certified Master Anaplanner and Customer Success Consultant at Bedford Consulting. Setting the details of a user’s access is usually a job for the workspace admin: decide their role and selective access to lists members. However, the Users tab is not always the friendliest, especially when thinking…
-
How I can enroll for Level1 training
I am interested to learn Anaplan as part of my new role. How I can enroll for self instructor training?
-
Clear user access rights to selective access list using import - best practice request
Hi I manage user access to modules with selective access enabled lists from admin dashboard with processes importing data user access and roles data. It worked pretty well, but recently I noticed an issue. To apply new access rights for a particular user, I first clear all his current access and import new one. To clear…
-
Import Shipping Expenses into OTH01 Module :
Import is showing Successful, but i didn't see the shipping cost updated on OTH01. I doubt may be because of Year is different in both the modules. OTH01 Shows 2019 and INV05 Shows 2020. Would like to have your suggestions, please. Thank you
-
Issues with AnaplanXL background Functions
I am having issues with Anaplan XL messing with some of the standard Excel functions such as: 1. The "marching ants" around copied cells don't show up when I copy cells 2. I get a "could not copy to clipboard" message where you can't copy things out of Excel into say ppt or an email 3. When two workbooks (or even multiple…
-
Is there any module-level setting that affects date display format?
I'm currently preparing for Anaplan Level 1 certification independently and came across something I'd like clarification on. In the same model (Classic view), I have two modules where a line item formatted as Date is displaying differently: One module shows dates in dd-mm-yy The other shows mm-dd-yy Both modules: Are in…
-
FCR: Request to enhance the audit functionality
Backgrounds We have a question regarding Logs > Session Log. Currently, system activity logs are only available for a limited number of functions, such as Journal operations and metadata updates. As a result, some system administrators on the customer side have found the current audit capabilities insufficient and have…
-
Workflow historization for auditability
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: Currently it is possible to delete a completed workflow. Unfortunately this does not meet internal requirements for auditability. Who…
-
"Azure blob http error" when establish connection between Cloudworks and Blob Storage
I have this error message " Azure blob http error " when i save cloudworks connection to Blob Storage. I follow this link: Connect to Azure Blob | Anapedia Can someone help to identify the root cause and how to resolve? is it related to permission or security?
-
Sort User List / Group Users by Model Role
Would be great to have the option to sort the User List in Anaplan. We have multiple models in the same workspace, and therefore, each model has a long list of users who aren't relevant - they are assigned the "No Access" role designation. Would be great to be able to visually manage this in Anaplan, rather than have to…
-
Level 2 Conclusion 4.3.5.5
Hello, I’m experiencing an issue in my currency conversion. The values are displaying with too many number. I’ve already tried changing the format to Decimal and adjusting the minimum significant digits, but the numbers still show a lot of decimals. Could this be related to the formula or another setting? Nevermind, i…