Modeling

"Edit From" and "Edit To" in "Versions" don't prohibit users from importing values to that time peri
Description of the enhancement: The RFE would be to disallow users from importing into a timescale that they cannot edit. To reproduce: 1. Create a module with "Versions" and "Time" as dimensions. 2. In "Settings"->"Versions", change the "Edit From" to "Feb 16" on the "Actual" version. 3. Back in your module on "Actual"…
Convert time period to a date
Description of the enhancement required: As an extension or alternative to the DATE function
Additional week formats
Description of the enhancement: We would like to have a Week format that will combine the number of the weeks in period and the period associated with the week. For example, for week 50, we'd like to see Wk 2 - P13 FY14. I imagine this is a concern for retail companies as this is the way most retail companies look at…
Drilldown displays formulas without parenthesis, and cannot be copied back into line item
Description of the RFE: Users are copying and pasting formula from drilldown dialog, which isn't possible because parenthesis are removed. This is an RFE to retain the parenthesis, or at least provide that option. Use case: Drilldown formula is removing parenthesis. This is causing come issues for us working with a large…
Syntax for a variable Line Item in a formula
Hi I'm building a module where I want to pull values from a subsidiary model, but the line item I want to pull from varies according to the member of a particular dimension. For example, if I'm looking at dimension member "APPLES", I want to get my data from the line item "line_item_a", but if I'm looking at the dimension…
Find the common parent of two list members
I have an Entity list which contains the entities in my organisation. If, as the result of another calculation, I have been returned two entities in the Entity list, how do I determine their lowest common parent? Some combination of PARENT and FINDITEM seems likely... but they might be at different levels.
How do I sort a list?
In excel, order the list members (members only, not parents, etc, just the members as they appear in the list in Anaplan) in the order you would like it in Anaplan. Then copy just the list members. In Settings->List->Grid View (not Tree view!) of the list, click Insert, choose Start as the ‘position’, paste in the list,…
Count the number of sparse cells in the MODEL
Hi There, Can anyone lemme know if we can count the number of sparse cells in our Model? Basically, we want to know the number of blank/non-zero cells in a model (Or) can we count the number of cells which has data in it? ( as per my understanding, if we get the sparse/non-sparse cells we can subtract this from the Total…
Line Item (List) link into a module
Hi everyone, i have a module with several line items. One line item is a List, another one is a number. After i have selected a value and entered a number, i want to link the value into a module which has the List as in the rows. Any idea how to link the data ? I would like to have the value number entered only appear on…
Restrict Access of Line Items to Supplier
Hi, I have a dashboard, containing a module, with approx 20 columns of data, dates and text. We are sharing this dashboard with a supplier who have their own user, and role setup. In the dashboard, there are 6 fields that are updateable by users within the business The supplier needs to be able to see ALL the fields, BUT…
Synchronizing dashboard scroll bars
Anaplanners: I am thankfully almost done with my dashboard which is essentially composed of the same modules but I need have the up & down scroll bars synchronized; I tried to sync the rows but that simply collapsed the modules. Is there an effective way to synchronize the rows so that the user will have the same rows at…
Adjusting Long Formulas Tip
Since trying to follow long conditional formulas can be tricky within the Anaplan formula bar, a tip to make it easier is to use the Drilldown capability on a cell within the line item. By doing this, you're able to see the If Statement/Formula indented with each If Statement. After seeing it in Drilldown, you're able to…
Level Mismatch on Common Dimension
Hi All, I have a data entry module with 3 lists: versions, row id, and line item list. I have 3 line items: person, cost center, country, with type of List and link to person (L3), cost center (L2), country (L1) lists. The input is to select person, then cost center and country is derived from the hieararchy. The second…
Versions to compare latest plans
I want to be able to compare to earlier versions of the plan ( so when we can to month +1 i want to be able to compare ‘current’ plan to previous plan ( and also with earlier versions). There is a solution in creating a seperate version and then bulk copying into it. Is there a more automated , best practice or simple…
Holding a Breakback on two different module views
Hi all, I have, in a Dashboard, two tables form two different views of a single module. Those tables allow to change data in it and both are linked to the source module. The first table displays by country (with product as a fliter) and the second one displays data by product (with country as a filter). I have a breakback…
Numbered Lists renumbering
Hi, The number of IDs on the numbered list is 999,999,999 (based on information in topic related with numbered lists)- what about reaching this limit. Is there any list renumbering possibility?
Multiple Selection of List items and their total
Hi, Anaplaners I have faced an issue where I am not able to select multiple list items (in the attached excel, Product A and Prodcut B) to show what is selected and their totals. What I came up with is when products in the row do not equal to Selctor 1 or Selector 2, set 0 and hide 0s. But the problem is this idea would…
creating a discount table
Hi There I am trying to drive a different profit margin based on volume (by client). Simplistically, I want my margin to be 20% for a volume of 1-5, 19% for a volume of 5-10, 18%: 10-15 etc.... I am sure this is simple but I just cant make it work Anyone got any advice, please?
How and Where can I use data tags.
Hi, I am trying to understand how to use data tags , I uderstand that we create tags in settings and assign the same to various objects in the model however I am not sure how and where can I use those tags.
Access denied to 299 Project
Hello, I have tried to get access to the 299 Case Study. But, the access is denied. Can you please help me found out where the problem is. In fact, I already passed all the courses and certifications required for this step. My username is NFWADE. Thank you for your help.
Anchoring Certain Months Data Forward Using Boolean
Hello All - i am trying to forecast out data using actuals. I want to take the weighted average of the last three months of actual data (green box below) weighted by net auctionable (purple box below) and forecast out the rest of the year using this average. I setup a boolean row (red box below) in order to indicate which…
Parallel hierarchy
Hi All, Can anyone please let me know how to create parallel hierarchy in lists? I am working on a problem and as a part of the same I need to display same data in 2 different hierarchies. Thanks
Switching calculation based on a property or a code
Hi I want to set up a module that contains a set of scenarios. The idea is that the module would contain various iterations of a set of base data, and that the calculations happening in the module could be switched to use a different scenario's data. I'd like to make that switch happen without having to change the…
Generalised currency conversion
Hi I'm building a model which holds revenue data. The revenue that the company receives is in a mix of US Dollars, UK Sterling and Euros, so one of my lists represents currency. There is a requirement as well to aggregate that revenue into a single "Converted Sterling" currency, which would be calculated as (Revenue in…
Good practices to improve model performance
General recommendations It is important as model calculations increase to ensure that the calculations and structures are as optimal as possible. Easy checks include: * Ensure the dimension order in the "applies to" is consistent * Consider if all of the dimensions for the calculations are necessary * Reduce the number of…
RANK function ONLY returns 1 when ranking in Anaplan Time dimension. Bug or intentional?
Hi Forum, I am new to Anaplan, this is my first post ... Set up to Demo problem: * 2 dimensdional module* Anaplan Time dimension in columms; * 2 line items in rows;* 1. Some numbers to be ranked * 2. RANK function ranking Line Item 1 Problem: RANK only returns rank 1 for all the numbers ranks, even though they are…
201 Intermediate Model Building Section 8 actvity #10 Numbers don't match
I'm working on Section 8 of IMB and the numbers in the sub-region Goal set don't match for US South and US Central. The totals in the bottom row do match with the guide and instruction video, but these specific sub-regions don't. PY Sales and Sub-region % are correct, but the Projected Goal is not. All other sub-regions…
Page Selectors - Isolated
Hi We have a module that has 'Customer product group' as a page slector. and then many line items. On the dashboards (3) we place the Customer Product Group' list, to allow the user to choose a customer and then synchronize the output. However, when we select CUSTOMER A on one dashboard, the other 2 dashboards also change…
Limit Date Format
Is thier a way to limit the years that is available for selection when using the format line item as date?
Circular Reference with OFFSET function
I'm getting a circular reference while using the OFFSET function, but I don't understand why. (1) IF offset_value = -12 THEN OFFSET(Gross Revenue, -12, 0) ELSE OFFSET(Gross Revenue, -11, 0) vs. (2) OFFSET(Gross Revenue, offset_value, 0) Dimension is Months and 'offset_value' always equals either -12 or -11 based on a…

Modeling

Discussion List