How to

Is it possible to change the order of list items in Saved View?
Hi! I want to change the order of items in the list used in the horizontal axis of the Saved View　used in the Export Action. It is possible to rearrange the order of list items in the Apps screen, but is it possible in Saved View? Is the only way to change the order of items the only way to change the item order in the…
Application Lifecycle Management for the User Experience
Application Lifecycle Management (ALM) enables your governance, development, and maintenance of Anaplan use cases. You can now work with ALM features in Anaplan’s User Experience (UX) to manage the lifecycle of your pages alongside that of your models. With the UX, you now build pages inside apps. Apps contain all the…
Optimizer Inventory Rollover Exercise
Inventory Rollover setup is required to avoid circular references when using previous function and will allow for rollover within dynamic time construct that the Optimizer requires. Review and complete the Dynamic Time portion of the exercise prior to starting Inventory Rollover.
Similar department in each entity
hi Community, I have a new requirement where I need to flag similar department from all entities. Using the first 3 letters of their code. below is just a sample of the list: as you can see TMCI and TMSL has the same department (L3) Laboratory and Pharmacy they also have a similar code the 1st three letters starts with LAB…
Optimizer: Hands-on exercises
Now that we know what Optimizer is and how it can help your organization solve complex business challenges (quick reminder here) it's time to get under the hood and practice. We curated for you 3 different exercises based on different use cases; we also have an available E-learning course. Immersion Optimizer overview…
PlanIQ - Deep dive on the algorithms under the hood
Baseline time series algorithms Advanced statistical time series algorithms Flexible local algorithms Neural network algorithms Summary Companies often develop plans and business strategies to drive decisions and actions around finance, operations, supply chain and other areas. They do this based on how they perceive the…
Common Department in 1 List
Hi Community, I would like to ask a question in my new setup where I can flag similar departments in a list. Using only the 3 letters of the code present on the list. In my example below there is 2 Office of the President 1 which is the child of the TMC Main parent and the other is the child of TMC SL. Requirement: I need…
dynamic Parent heirarchy
Hi Community, I created this system mapping module, and my Solution Architect asked me to make it dynamic by creating the hospital parent heirarchy. I have no idea what it means or how to execute it. She is unavailable at the moment for clarification so I am trying my best to build it. Do you guys know what it means or how…
Update Time range in dropdown to start from FY10 instead of FY15
Hello All, I have a "Time Range Question". I have a Schedule below that in the dropdown starts with FY15, but we need it adjusted to start with FY10. Would anyone know how I should go about making that change. Sidenote: In the 2nd screenshot below, our partners included a time range in order to increase the years through…
How do I have a different summary method for a single line item?
I have three line items: budget, reforecast, and variance. My dimensions are three different lists - type, subtype & quarters. Some of the subtypes for budget and variance need to be sums and others are closing balance. What would be the most efficient way to do this?
Automatic status updates for line items
Hello We are looking for functions for the following When a new item is added to this module, I would like to know the function that automatically sets "Americas" to the "Region" item. please tell me
for Label of MR
Hi Community, I need a little help on this module, we will use the line item here as a label on the MR report we are building. Particularly the line item (vs Budget(M Narrative – the column beside vs Budget (M) – Morse) . Basically what I need to be done is that in the Budget Morse column (IF vs Budget (M) Narrative is UP…
Save incomplete changes when synchronizing in ALM
Imagine this scenario: You are in the middle of making changes in your development model and have been doing so for the last few weeks. The changes are not complete and are not ready to synchronize. However, you just received a request for an urgent fix from the user community that is critical for the forthcoming monthly…
Revision Tag: Roles -> Actions
Hello, I have a quick question in regards to revision tags. If I were check the box to grant a user access in "Roles → Actions" in DEV, would that require or qualify to use a Revision Tag in order for it to sync to PROD? Or what would be the best way to update the change, so it reflects in PROD?
How to fill a line item recursively
Hi! I have one module where one of the line items is my inventory amount and on the columns I have a list where I put diferent fiscal years (note that I cannot use the formula PREVIOUS() because this module is not connected with Time, and I can't connect it either). So my list is composed by: FY22, FY23, FY24, FY25, FY26,…
How to convert Month Line item in text format to Month Format
Hi All I have two month line items in text format as shown in picture and want to convert to Month formatted line item. What steps should I take so that I convert it into Month formatted line item. Thanks in advance
Absolute value on List
Hi Community, I would like to inquire something to make absolute value on a module with specific list members only.So the requirement is that the COS and Admin list members will be alsolute value. see below. Blueprint view: only the highlighted items should have an absolute value. the columns are the line item and the row…
Error
Hi Community, I was trying to follow the instruction given by @pyrypeura on conversion of time to text. I followed how he made it but I keep getting error. Am I doing something wrong here? Kindly correct me if I am doing something wrong. THanks and Regards,
Date Conversion
Hi Community, Can i have help in converting date into a text formatted version date. Like1/1/2019 convert it to January 01 2019. I already have the days line item I just need to convert it to a text format date. Any ideas is welcomed, Thank you and Regards,
How to differentiate when a line item is input and calc on the same module
Hello! I'm trying to build a module where one of my line items is an input on one hierarchy but a calc on another level of the hierarchy, but I'm not sure if this is possible to build in anaplan, let's have an example: My Hierarchy is: Season Winter Summer On the module I have the following line items: Account Receivables…
Get to know the model experience as an end-user
Welcome to the Anaplan modeling experience (MX)! The Anaplan functionality you know and love, with a modern look and feel and simplified, intuitive navigation. In February 2023, the updated model experience became the default for all users. In April 2024 the ability to toggle back to the old classic experience will be…
Help me with this issue.
I have this two modules: AND I want to pull the territory ref ID sys/fil07 to the inp/ter01 so it would only show territories available for that employee, i have tried to do loots of formulas but they dont seem to pull it correctly, not sure if because inp/ter01 is made with subsets its messing it up or something is wrong,…
Line item to match boolean
Hi Community, I would like to ask a little bit simple question. i already have the Current Month +1 line item working. So now the requirement is to match Current month +1 to a line item which is a Boolean. I tried the formula IF item(time)= Current MOnth +1 (text) then true else false. it was not accepted. I am thinking…
Next month label.
Hi Community, I have a simple question and a new requirement by the client. What the client wants is to display in the title page a label that shows Next Month. So for example if the user selected a Jan 23 time, the label on the header form our sys module will show Feb 23 instead of Jan 23. Right now we have a sys module…
Current Date
Hi All, Just a simple question, I may need to know how to get the current date for my system time module. The client want to display the current date currently we are displaying the End of Month date instead. Hope you can assist. Regards,
Schedules Mapped by Entity Name in Anaplan
In Anaplan, I have a schedule that needs to have the name of an entity name change to the English version. I was put on notice recently, that the schedule is being mapped by the entity name. Can anyone provide guidance on how I would be able to see in Anaplan exactly how that schedule is being mapped by entity name and…
Time selection line item
Hi All, Just a quick question, is there a way to create a line item with dropdown menu of the time selection that has Month Qtr and Year all in the same dropdown.? I am creating a selec time period for the MR i am working on and with @AjayM assistance I was able to create the filters. Now i have a separate selection for…
Different formats for one line item
Hi all, A user can input data in the following way: Event type Event Date of the event Is there a way to define different formats for the line item "Date of the Event" on the basis of the other line item "Event Type"? As an example, when I input "Event type 1", the "Date of the event" is Time Period Format, (Type 1, Event…
Line Item Subset SUM
Hi there! I have growth assumptions on different cost lines in module(A) where am using a Line Item Subset for cost lines and regular line items in different years. In another module(B), I calculated the Net revenues also using Line Item Subsets and the COLLECT() formula. Now I am trying to build a third module(C) where I…
エクセルのToday関数のように現在の日付を特定する方法
みなさん、こんにちは。Anaplanモデルビルダーのセナです。本日は、エクセルのToday関数のように現在の日付を特定する方法を紹介したいと思います。現状Anaplanでは、エクセルのToday関数のように現在の日付を特定するためのネイティブ関数はなく、Idea Exchange では多くのビルダーに要求されており、保証はできませんが、今後の新機能として追加されるのに期待です！追加されない間は、以下の方法で実施してみてはいかがでしょうか？今回は、わかりやすく表現したかったため、"Power Automate"を使用しました。実際には、API叩けたら、どんなプログラミング言語やツールを使用してもOK！ 1.Power Automate…

How to

Discussion List