-
Snapshot Challenge with #list
My scenario today, Integration runs everyday and clear the below numbered list with data. Since the build has been done without the code i'm struggling to create the code with unique combination. My objective is : I want to copy the current data before the delete process will execute. and compare it against the data that…
-
Conditional Formatting Help
Hi All, Checking the possibility of conditional formatting for FY 24 -GAP as shown below. I don't want the BP or Fcst to be formatted. 2. Is it possible to extend the Color formatting to only certain line items label (like net revenue, GM and GM %) needs color formatting 3. Is it possible to have spacing between Forecast…
-
Including Text within a Number Formatted Line Item?
Our client requests to see "no MTA" when MTA= 0 and Warehouse <> 0. However, instead of 'no MTA', I'm getting 'NaN'. Is it possible to include text within a number formatted line item? Formula - Final MTA = IF MTA = 0 AND Warehouse <> 0 THEN VALUE("No MTA") ELSE MTA
-
Anaplan Model Back Up Automation -[Copy and Archive] process
Considering that the Copy & Archive feature under Manage Models in Anaplan can copy and archive a model without impacting storage size limits. How can I implement an automated daily backup solution for Anaplan model data, given that there is currently no in-built scheduling feature for the Copy & Archive ? My clients…
-
2.4.7.1 conditional formatting add new rule option is not avaliable
Hello Can i know why I cant able to apply conditional formatting? why there is no new rule icon available when i select conditional formatting icon ? I have selected even a line item row or column and selected conditional formarting icon but still i there is no New rule option avaliable
-
Current Date Update
Is there any other way that we can update the current date with out using cloud works, Anaplan connect, or any middle ware ETL tools. Through the anaplan system i need to update it not manually and not by uploading the excel file
-
Ability to input text commentary with text formatting options in Management Reporting - New UX
While working on a project, a useful implementation emerged. Currently in Anaplan, via Management Reporting, it is possible to create documentation that cannot be customised by the user. In fact, the end user using the system can only look at the data and comments previously entered by the Page Builder. We tried creating a…
-
Challenges with Continuing to Use Version 1.3 API in Power Automate Custom Connectors
I'm currently using Version 1.3 of the API in Power Automate Custom Connectors, but our Anaplan systems have been upgraded to Version 2.0. I have a few concerns and I’m hoping to get some insights from this community: Compatibility and Functionality: Are there any known issues with maintaining the older API version in…
-
Can I add in Cloudworks a Delete Process using Selection?
Hello, I want to do the dete function automaticly with Cloudworks. Can I do it with slelection? if Not, what options do I have? thanks
-
Filter / Drop Down Selection
Hey I´m trying to add a drop down selection to use as a filter on a grid I´m working on. The grid has data by client and each client has a zone as a atribiute, I wan to add the posibility to select a zone in the drop down selection and filter the clients based on the selected zone. Is this posible? I appriciate any help,…
-
L3 Account Assignment
Guys! PLEASE PLEASE PLEASE revise this training. It is so unclear as to what exactly you are asking us to do. This is not realistic, this is not a real life scenario, right! In real life we have discussions, we go to meetings, we follow an Agile methodology, and we get to ask questions whereas here you have left us in the…
-
Ensure community members are fully on top of new enhancements (improving comms and alerts)
As a community member I like/need to be on top of any new enhancements that are made available. Most recently it seems the strategy, alerting, comms has changed and it's more complicated to be on top of new enhancements, plan, test and deploy them as quickly as we would love to. Could we improve the comms by creating a…
-
Percentage Format issue on UX page
Description: I have a module with PV(dimension) Filters as dimension and I am displaying the Value line item on UX which is same as the Module dimension. But the Value line item is getting the data from other line item Actual vs Scenario 1 % which has ss_Actual vs Scenario 1% (dimension) - Which is a subset of PV filters…
-
Text to quarter ?
Hello Everyone, what is the best formula that we can use to go from this to this: Txt Period "Format Text" (Example: Q1 FY24) ===> Quarter "Format Quarter" (Example: Q1 FY24)
-
Show the code instead of the display name in dropdown list
Hello My client does not want to have any display name, just the # generated by anaplan. In the same time, it is very complicated to choose an item in a dropdown list seeing only #s. Is there a method for me to show code of the numbered list ( which is existant ) instead of the #? Thanks
-
Adding comments for individual cell in UX page
Hi All, Can we able to add comment on individual cell in Anaplan. For example: let's say I have added 62 and I want to enter some info about override forecast. If I have not able to enter the comments on single cell then how can I achieve this. One way is we can comment in the grid level even if I have added any comments…
-
Searching for community members-- functionality removed?
There used to be the ability to search for a name and find community members. Was this moved to another area? If it was removed, why? This helped to facilitate hiring, validations of certifications and more. You can still see someone's profile if you know their username or click through a link on an idea exchange. Please…
-
Tableau to Anaplan integration
Hi team, Could you please help me with best possible way to export data from Tableau and load it in Anaplan by writing script or something. Regards, Venkatesh
-
Date Line Item using Min Summary
Hello I am using line item formatted as date with 6 level hierarchy. I am using summary as Min for the same. I am facing issues where if there is no date in my list P6, i am getting 12/31/2399 for all NonBlank list members. Please advise best way to handle it without doing any hardcoding. Regards MO
-
Conditional Formatting on User Access (Roles -> Modules)
The current interface for setting role access to module is difficult to read visually - if a model has many modules it can be difficult to spot if read and write access for roles has or hasn't been set up, or varies between modules/roles: Would it be possible to add default conditional formatting to the system that…
-
Report/Board: Table Row and Column Height
There are four options for row height in a table output in the Report Designer/Board Designer. Even with the "default/standard" option, there is significant white space between rows. It would be helpful to have a "narrow" height option for table rows, or similar to my request around fonts, and adjustable row height based…
-
Do you feel it will be good to have Supply Chain related functions ?
Since Supply chain use cases are picking up, do you feel it will be good to have supply chain specific functions in Anaplan. If yes, then kindly promote the new idea I posted.
-
Facing error in line item name referring in formula
Hi Community, We have been working on copied model and trying to replicate the same line items and formulas as well wherein we are facing an error wherein it is reflecting Line item is not identified line item or list member. Example line item name: Historic range? when we refer this name in formula we are facing error…
-
Idea for a session: Anaplan Support
Hi all, I have got an idea. What if we organize a meeting with Anaplan Support team representatives so they can share their experience of dealing with Anaplan users and modelers and we could share our feedback? Please share your thoughts. I can help to lead this @becky.leung
-
For a beginner, need guidance, and a Anaplan workspace
Dear All, I am new to Anaplan, and want to learn it, self paced. As I was venturing more into it, I realized that I need a Anaplan workspace. And then, I reached out to Talent Builder Program, which I now see is on hold. Can anyone please guide me?
-
Level 2: Model Builder - 3.3.5.2 Inventory Ordering Module Formulas
Hi everyone, I am not getting the results as expected. Does anyone of you know where my mistake is? for the first Row "Beginning Inventory" I am only getting values for Week 1. For row "Shipping Time Weeks" I am getting 0 as the result. But expected is the value 4 (for Week 1). Here are my formulas: Thank you. KR Tobi
-
How do I import only 1 occurrence without errors?
I have a DATA module with a line item named "Scenarios." I need to import this line item into a list also named Scenarios list. The data module is dimensionalized by a different list so I cannot use the isfirstoccurence() formula. What's the best practice when it comes to importing this line item into a list as to not have…
-
link text-formatted line item
Hi All, I have a question from a partner.., Can you please confirm that it is not possible to link to a file destination in Anaplan using a link text-formatted line item. The link text-formatted line-item defaults to http// and the file destination our client uses has a different prefix using backslashes (\\). The links…
-
Query on Efficient List Creation Method
I'm seeking advice on the quickest method for creating lists in Anaplan: using the UX Page "Form action" or the backend Actions for Creating List Item. Which approach is more efficient?
-
anaplan level 2 sprint 1 activity 1.5.6.1
Hi all, I have problem while importing data into Historic Volumes Module. The csv source file contains data (image 1), but when I run importing into modules (image2&3), there's no data at all (image 4). What should I do to fix this problem? And by the way, I do not get why we select "Column Headers" for "Volumes". I got…