-
L2 Conclusion Import Currency
I am struggling with importing the currency by country into the Country Currency LIS. I continue to get errors on Euros in that it won't import due to repeats. I am starting here: Then: I have tried Code Only, Combination of Properties (as shown), and Adjust Duplicate Names to Form Unique Names. I cannot get this list to…
-
I've entered the formula for the beginning inventory but it doesn't seem to work completely.
Can anybody please help with what is wrong in the formula? IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory
-
Input Modules
Hi, How can we identify the number of manual input forms that can be built in Anaplan? Is there any way by which we can reach to a ball park number for a client on the number of input forms to be created in Anaplan. Thanks in advance!
-
data tags
what is the use of data tags in anaplan
-
Help in tracing an error message when removing parent hierarchy from a list
Due to a change in functionality, I have to de-connect one list (Sub-Regions L5) from its current parent list (Org L4 - Region). I have gone through every module that has this list in its "applied to" and removed any references to its current parent list. When I try to remove the current parent list I get an error message…
-
DAT03 Historic Volumes module
I'm working on the Level2 modeling and I'm stuck with this step: 2.3.9.1 Import data into DAT03 Historic Volumes module * Run Process 9 Import Data from the Hub. * This will pull the data into the Supply Chain model from the Data Hub model. * Make adjustments in order to avoid errors in the import process. When I run the…
-
Unable to download copy of Level 1 Model Building 2.0 (New UX)
Hi Sir/Mdm, I am not able to download a copy of the Level 1 Model Building 2.0 (New UX) model as part of the model builder training. Could anyone kindly assist.
-
parent hierarchy properties
hi! I want to view the properties of an item in the parent hierarchy from the child hierarchy. How can I do this?
-
Question on how I set up my List
Hi, I need advice on how to set up something in my Model. I need to pull into my Modules a Time Setting that excludes Bank Holidays. I have created a List of all the Bank Holidays and plan to use this as a filter in my Module's. I want to know if this is the correct way to approach this task? A screen shot is attached.…
-
YTD and YTG returning zero
Hi, I'm trying to calculate YTD actual revenue, and YTG budget revenue but they are returning zero. For example: this returns zero - module.Revenue'[SELECT: VERSIONS.Actual, SELECT: TIME.YTD, SELECT: Products.X] This statement works when I replace TIME.YTD with TIME.'current period', so the issue just relates to TIME.YTD.…
-
Max value in a time dimension
Hello! I'm trying to get the maximum value of the item test1 in the time range FY19-FY30 and then use that value in an operation in item2. Any idea? In the example screenshot I attached, the maximum value of item 1 is 10 (FY30). In item2, I would like to do the operation 10*line item3. Any suggestions to obtain the max…
-
Consolidation of P&L
Hi, I am sure this is very basic but much appreciate any advice. I need to consolidate 2 P&L say Entity A and Entity B. Assuming both P&Ls are in 2 different modules (Module A and B) and both have different P&L line items. Module C is the consolidated module. I need to bring A and B onto C's P&L (assuming all 3 P&L line…
-
November 6th Updates - Examples? Documentation?
Great updates over the weekend. Bulk copy is huge. Anyone see any documentation on the optimizer and what changed? I'm anxious to learn more about what "solve more complex problems" means. https://community.anaplan.com/t5/Releases/What-s-New-November-6-2021/ba-p/124249
-
Formula Help Required :-)
Hi, I've recently been contact by our finance team with the below query - I wondered if someone could help point out where in the existing formula I can tweak to resolve. OLD Formula: NEW Formula: This has resulted in incorrect output in the field known as 'B6', please could you help me work out what i need to amend in the…
-
Get Monthly Data from Yearly Module
Hi! I am quiet new to anaplan and I just got stumbled into this problem. So I have 1 Module which has dimension of Malls(list) and year(list) and line item Revenue. Then from that module I wish to show how many Revenue per Mall per month(the amount should be Revenue / 12). So I create Module 2, which contain mapping of…
-
1.4.4.1 Create Build SKU Saved View
anybody please as stuck here @Misbah
-
Multiple location budget access for users
We have a Multiple dept planning dashboard in budget model where end users can select multiple dept.to see their budget . Dept list are selective access enabled for the end users.Here is the issue: For example : User A select 2 dept on the dashboard ,Now any other user go to that dashboard and select their location (based…
-
How can I find an overview of which line items are used as filters in saved views?
Hi Anaplan Community, I am wondering if and where I can find an overview of line items which are used as filters in saved views. This would be a great help in maintaining models!
-
Select function with subsets?
I have a subset A which is a selection of the Global Customer List. In my module which applies to the subset A, I'm trying to retrieve the Sales for the top level of the subset "total customers" (only the total of the selection of the customers from the global customer list). I tried [Select:'Subset A'.'total customers'].…
-
Optimizer Process Success with FALSE Booleans
We created an optimizer process to maximize net income. The specific issue relates to a constraint where where revenue (optimizer variable x revenue constant) cannot exceed the forecast, which sits at an aggregated level. So, my logic is to first multiply the decision variable (at P4 Product) by it's calculated revenue…
-
Help with formula - select both recently item what a list.
Hi. Please could you help suggest how I can identify in an additional column what the both recently (bottom of the list) retention figure is? Most recently figure is the one highlighted below. This figure is pulled through to another dashboard but its currently provide the total sum. SUM is being pulled through to here,…
-
Need help with a Lookup - Dimension used for lookup doesn't match any dimension of the source
Hi All, I have a Lookup that I'm having a really hard time figuring out. I need to create a mapping line item but I am at a complete loss trying to figure out what that line item needs to be. Here are the details of what I'm trying to do: Target Module: Credit by Opportunity by Month Dimensioned by * Time (Month) * List:…
-
My formula is not giving me the expected result, need some help (LIS, LOOKUP)
Hi Anaplan community, I am a bit puzzled with the result of a formula, which is not giving me what I expect. I have a target module (O4. EB Summary) with two dimensions: a list with a year and a list with platforms. I have 3 line items: "NY Plan IBT" and "EB IBT" are referring to a line item in another module (O1. EB…
-
Multiple Sorting/Nested Sorting
Anaplanner, Hope all of you'll are doing good. I had a query if we could have multiple sorting implemented or in other words nested sorting. I have projects dimensioned by Region, Importance and Priority (all are lists). I have currently sorted it based on Importance where Most Important Project is shown first and then the…
-
Movingsum formula
When using list versions, how do I make the movingsum formula include the forecast output for previous months in the calculation of a given months forecast?? I cant include a "previous" function within the movingsum formula
-
I get error when i try to make a graph which is dynamically updating with date selection.
Hi, I am trying to create a dynamic graph for stock overview (see picture below). I created a table with dates in the columns and I have 3 line items. I added a time filter on the module that is triggered by the selection of the graph start and graph end date. The module is published to a dashboard with the time filter in…
-
Need some help with formula
Hello, I am Sylvain. I work in a french confectionnery. Not the unicorn candy company 🙂 I am building a cash flow monitoring and I have to import the bank book in a data module : Only one line item is list formated : "compte" Other are text, number or date And the trouble is about the date. i have to take the data from the…
-
IF user Selects any checkbox within 3 booleans then I want to include that in a scope
Hello, I am wondering if I can use the IF formula to say that if a user selects any of the checkboxes within three separate columns (booleans) then I want to consider that within a scope. OPTION 1OPTION 2OPTION 3AX B X C XD EX F Let's pretend this is the dashboard and that the "x" represent a check in a boolean list Then I…
-
Different ways to do employee transfer in workforce planning model
Hi, I am looking for various methods possible in Anaplan to transfer an employee. My use case is as follows. Employee is tagged to a position/grade and cost center. Employee can be transferred from one CC to another. Target CC currency may be different from source CC. Multi currency Model and each CC will plan at their…
-
use FIND but also limit the number of characters for boolean
I have multiple store codes that are not within my perimeter and I am trying to create a boolean that reads the start character "S" I managed to reduce the list but still need to reduce it saying that the code starts with "S" but the character count limit is 4. SJ5 SJ6 SJ7 SI5000002 SI5000003 SI5000004 SI5000005 SI5000006…