I suggest enhancing the product feature to streamline the migration of workflows from the Dev Model to the UAT and Production environments. Currently, the process requires manually duplicating existin…
Objective: To create a reusable "data entry form" that allows users to Create a 'Project' The form requirements are as follows: Project Name, text Project Description, text Estimated Funding Cost, num…
My PRACTICE module has time dimension as Months 2019. I want to create an IF statement in the RESULT line item that says IF Time Period < Jul 19 THEN TEST 1 ELSE TEST 2 How do I reference the Time Per…
Until recently, the input data in applications was blue. Now both the data entered and fixed by the formula are the same black color (or too dark blue??), which is absolutely inconvenient. I hope the …
We've come into performance issues on our model and requested a Model Open Analysis (MOA) report from Anaplan support. This was very helpful in identifying modules and, in particular, line items that …
Currently ADO only has a single tenant level environment to all store source data, transformations, and links. This can make managing ALM challenging. Being able to have separate (and sync-able) ADO D…
Author: Audrey Neet is a Certified Master Anaplanner and Director at Tru Consulting. Data validation is the process in which business users ensure that the data in Anaplan ties to their source system.…
Being able to pivot/filter the add in grid without references to that grid getting removed. When I create a retrieve using the add-in and link to another excel tab (formatted for distributions to our …
Hi, I need a bit of help. I have a file of the following structure, with Time dimension going across as column headers. The system is setup to 13 periods of 4 weeks. When I try to load the data using …
I've successfully built out a Power BI semantic model that appears to connect to Anaplan just fine. When I created the model, I logged into the Anaplan Connector using my company SSO. Once the credent…
* Anaplan Connect (301) * Anaplan Data Integration Basics (303) * Creating a JAVA keystore for use with Anaplan Connect Overview This set of classes address how data is used and managed within an Anap…
Hello Everyone, I have taken over the Workspace Administrator responsibilities within the business and I am still learning about the basic model maintenance tasks. We've had a deployed PROD model sync…
I want to fix the length by appending zeroes :- Consider below example where i am having 3 Prod ID :- 1234 1234567 123 Below is the result i am expecting:- 0000001234 0001234567 0000000123 Generally w…
Author: Noah Jackson is a Certified Master Anaplanner and Principal Data and Insights Architect at Anaplan. Hello Anaplan Community! I’m excited to share this ‘How I Built It’ video with you. In this …
Probably an easy question but I am working through the level 1 course and it shows how you can aggregate based on a hierarchical list. When I try this on my own model it looks different and there are …
Currently we report our P&L using list Entity L2 which contains all our entities as a flat list. We want to create a new module that reports the same P&L information but not on a flat hierarchy. The d…
I have a module that contains ledger data and includes information such as suppliers, produts, departments and ledger mappings as well as the cost/income on a monthly basis. I want to create a module …
Hi everyone, In the source we are using pipe to separate the columns .In anaplan i have created action using .csv file and now changing the column separator from import data source ans using "|" inste…
Hi, In my FP&A model end-users can add comments(in text format) to a variance module that is dimensioned by the user list(among other dimensions). How can I consolidate the comments so we can see comm…
Anaplan introduced a new feature that allows for models that have been deleted to be restored by any workspace admin. This is wonderful for customers and partners to self serve when a model is deleted…
I am working through many many modules and removing 'bad' data or process and have come across a nested If formula, and cannot think of a better way to replace it. Have a module with 2 sources MATERIA…
So in the current setup, a module is dimensioned by Model- calendar time dimension and the horzion is from 2021 to 2026, the granularity being weeks. This setup is used in prod since go live for 2 yea…
Hello Community I have a list of BU's which is selective access enabled For example: If user have access to only 2 BU's Is there any possibility to clear data related all BU's Is Possible How it is do…
In general, data write action is a great thing, but it would be even more helpful, if the option could be set to behave the following way: When in the page context, a summary item in a hierarchy is se…
Hello everyone, I would like to move all the data in my model by a few years (Write all data from 2020 to 2023, 2021 to 2024…). For that I tried using Bulk Copy, but I can only copy individual months …
We are looking on creating some utlity or similar to it using open source API's or using Python or R or can be any other tool to intgerate Aanaplan with SAP to make our offer more cost effective and l…
Just like we have functions for Financial (COUPDAYBS, COUPDAYSNC, etc) and Call Center Planning (AGENTS,ANSWERTIME, ARRIVALRATE) can we have something similar to support Supply Chain Planning? Like En…
