-
Query on Parent function
Hi Guys, Curious - Why wont we use Parent(Item('G2 Country')) for line item 3 (Region)? Thanks
-
Planual Explained - Day 12
"Rule 2.01-14": Article 2, Chapter 1, and Rule 14 – “Avoid using Select Levels and Filters together”. Don't use Select levels combined with filters on the same hierarchy. It is a double filter and inefficient. Use one or the other. Setting a Boolean line item in a System module with 'none' as the summary option will often…
-
Anaplan Foundation Model
As the Anaplan App Hub is currently undergoing a redesign and upgrade, this post will serve as the formal documentation source for the Anaplan Foundation Model. Anaplan Foundation Model Download Process: 1. Click on the link below to begin the download * (Old Link)…
-
How to cross-join 2 lists
Hi Anaplanners, I am Simon from DXC. I am working for a requirement which needs to generate a cross-join list based on 2 lists. But I doubt if Anaplan can do this like SQL queries. I would like to take any workaround as well. We have 2 lists: one is for Managment Nodes and another for Industry. In Management Nodes there…
-
Variance Calculations and QTD Formula
Hello, I’m working on developing a Variance Analysis Module. I have reviewed the posts on Community and found this training that has been helpful. I used the below link to develop the Comparison and Variance Modules:…
-
Planual Explained - Day 13
"Rule 2.01-16": Article 2, Chapter 1, and Rule 16 – “Use Data Tags”. ”If not using for any other reasons, use Data Tags to signify the DISCO category”. It doesn’t go against any element of PLANS but why not use it when we have the functionality available. Use Case: As a workspace admin I need to check if ALL Countries are…
-
Unable to paste values in text property of a list
Hi, Scenario - I have a numbered list which has some items already in it. I have to add some new items to this list. When I add, the items are getting created but when I try to paste the display name in a property (Text Formatted), it throws the below error - This error is coming only for the new items added and not for…
-
Calendar Conversion: How to Map 445 to Gregorian in Anaplan
Navigation: Retail UAG Home | Forum | Get Started - Content Directory Convert 445 Calendar to Gregorian Calendar Hi Anaplanners! Today I was really fortunate to have an article posted in the best practices forum. For the retail industry, this is the first step to connected planning between merchants and finance…
-
150 Line items
Hello everyone, I have a module without Time Range(I can't have it). I need to calculate a quarterly item in 30 years. Actually, the module is in 7 years old and we have one line item per quarter, but if I want to continue this method, I must have 150 line items. Any suggestion? Thanks in advanced, Roba
-
Level 2 Model Building Sprint 3 INV01 Module
Hi! I am struggling to complete the INV01 Module Line Item Formula Details. It seems like everything is working except for the "Confirmed PO Delivery" formula. Below is the formula I have and the result I get: IF PO Submitted = 1 THEN OFFSET(PO Submitted, -Shipping Time Weeks, -1) ELSE 0 I've found similar questions in the…
-
Filter Crash in Production
Hi, I have created a Time filter for a Dashboard and Export view in Dev Model. But when i push that to Production every time the Filter gets crashed in the Saved view, so i am not able to get the desired layout in the Dashboard and Export File. Can you let me know where am i going wrong. Attaching the screenshot from Dev…
-
how to restrict List
im I have this Lists. Region : Asia,Europe Country: Japan, France when i make a table has List(Region, Coutry), i can get table1. Table 1 RegionCountry AsiaJapan France EuropeJapan France Off course i know when I make a table has List (Country), Iget table2 table2 Country + Asia Japan + Europe France But I want this type…
-
How to match value in List with code
Hi, All Referring to the photo below Suppose that there is a line item call YMD (value is 202006) How to use this YMD to get the 'Test2' in List with matching the code (value is 20200620-2)
-
Need to lookup Employee name basis the Employee order
Hi, Source module has All Employee list and basis their "Joining Date" (Line Item 1) "Rank" (Line Item 2) has been determined, in Target Module I have "Employee Order" (Line item) formatted as number. Is their any way, basis the "Employee Order" in Target Module I can get the respective employee’s name from the source…
-
DCA - Time Dimension
Hi Team, I have a: * Time Filter Boolean/DCA Boolean for Annual Time Periods in a Time Filter module * Target module with Time Period set to months and the DCA for line item set to the Boolean above My understanding was that there would be no input fields available as the DCA is being set at the Parent level (the Year) but…
-
For Newbie Anaplanners - Learn How to Add Users
Learn How to Add Users into Anaplan Workspace We know that how good it feels when you start exploring Anaplan on your own. One very important area that needs special attention from you all is USERS section in Anaplan. This is the section where you add Users into Anaplan or remove users from Anaplan. There are other things…
-
Planual Explained - Day 11
"Rule 2.01-13": Article 2, Chapter 1, and Rule 13 – “Separate Transaction Data from Attribute/Property Data”. Keep the non-time based data in a separate module from static attributes. It goes against NECESSARY element of PLANS if you wish to go against the rule Here is how it was done in Pre Planual Era: Even after best…
-
Adust daily figures to preserve monthly totals while switching from a weekly to a regular calendar
Hello community, I am trying to adjust my daily sales forecast so that the monthly calendar total matches the monthly "weekly-calendar" total, while keeping my seasonality as close to reality as possible. A simple picture will tell more than 100 words. .Spreadsheet…
-
Practice
Hello Anaplan Community, I am new to Anaplan. How can I practice building pages and dashboards. Is there any practice environment for Anaplan. Thanks for your suggestions
-
Return Value from Module with Time Dimension
Hi Guys, This might be simple to some but I am having problem with the result here. See below Module 1 is a module where users input the start of Data of Projection, this is their input module. Module 2 on the other hand is a Line Item named Value and a Time Dimension. So if a user input a Date (Time Period format) April…
-
Sum values based on period
Hi, Need a help to build a formula, have attached a screenshot for reference. Formula Needs to be build in Revenue Seasonality which need to take the values from Revenue Column and doing the sum of Periods. For Example: Period 1 amounts: 112+ 95. Needs to be clubbed as 207 and shown in Revenue Seasonality against all the…
-
Active child under a Parent - Check only future periods
Hi - I have a hierarchy of two levels - L1 (Parent) and L2 (Child). I have a module with the L2 dimension where a boolean line item is input across time periods (past and future). As we roll into the future, only the future x number of periods (say, 8 ) is updated to check which child members are active under a parent. My…
-
Disaggregation
Hi - I have five levels of hierarchy for one dimension and four levels for another dimension. The forecast is generated at these two dimensions at the lower levels of the hierarchy and the ask from the business is that they can input any level in the hierarchy - there are different types of inputs from different…
-
Planual Explained - Day 10
"Rule 2.01-11": Article 2, Chapter 1, and Rule 11 – Keep the Dimension Order consistent. Ensure the dimension order is consistent between modules. Calculations are faster if the common dimensions are in the same order in the “Applies to” section. The size of the list is not as critical as the order. It goes against…
-
Revision of IF formula
Hi Guys, So I have an issue with my IF formula, initially I was able to get the logic of this but the client decided to add a Contract Status (Full Cancellation). After that my count seems to be out in some months. So I need to adjust the logic but for some reason I am getting the correct results in some months but after…
-
Is Lookup within same module possible?
Hi, Is it possible to apply lookup within same module? I know direct link can work but, i need to get value of a particular list item of the same module. Thanks!
-
Subsidiary Views - Synch DB from a module with a specific line item
Hi Team, Anaplan states that 1 of the only acceptable times to use a Subsidiary view is where you are syncing Dashboards from a module with a specific line item Is anyone able to help with an example of this? Thanks! Mark
-
Subsidiary Views - Ratio Formula
Hi Team, In both the Subsidiary views training video and in the Planual it mentions that Subsidiary views should be used where a ratio needs to be in the same module but doesn't full require full dimensionality Can anyone provide an example of this I'm I can't picture it Thanks! Mark
-
Select all the line items matching the text
Hi, The module is Numbered List as a dimension. Requirement: to flag all the members matching the text member of the dimension. Attached the screenshot for reference. Dimension is numbered list with the property as a text (display name) TEST 2 : selection through some formula flag. Requirement is I need a boolean to flag…
-
Planual Explained - Day 9
"Rule 2.01-06": Article 2, Chapter 1, and Rule 6 – “Avoid using Subsidiary Views”. Subsidiary views are difficult to work with and audit. Try and minimize their use especially for calculation modules; create groups of calculation modules instead with like dimensionality”. It goes against Auditable element of PLANS if you…