-
problem in using lookup statement
in sprint 3, i have been tasked to create a country summary output module with G2 Country and P1 product family as dimensions and stock safety flag count as line item. The line item will take data from inventory module which has stock safety exception count as line item and put the data in country summary module. Now the…
-
Formula for Role of user
Hi, I am trying to create a module with the ff details : Dimension : List : Users Line item : Roles ( format is list - roles) Is there a way to create a formula for the Line item so it will pick up the role in the User setting? Thanks!
-
Lookup funtion return blank values
Hi, I have the 2 modules below and did a lookup function but it returns blank values. Am i missing something?
-
Need help avoiding Circular Reference Error while using POST formula
I am working with a system that calculates what payments should be, then when the actual payment is made we record what that value and save it back into the model. Sometimes there are retroactive changes, which cause a variance between the calculated and the actual amount. We want to be able to post the variance to a…
-
9.2.6 Activity: Unable to input data in a module
Hi Team, I'm trying to make the cells input ready as these are being referenced in a lookup. But they are greyed out and I'm unable to change it. Please help.
-
OEG Best Practice: Inside the Hyperblock
What are blocks? How blocks are calculated – General Lists How blocks are calculated – Native Time/Native Versions Hyperblock performance Summary block counts Should I worry about blocks? A reason why we shouldn’t focus on just the block count Focus Points We recommend this article to Experienced Model Builders and…
-
How to know current User ID
Hi, I am trying to create a DCA where in the requestor should be the only one to be able to Submit a request. In this example for this module, I am logged in as user id Camille@abc.com. since the requestor is Mark@abc.com, the Submit checkbox should be disabled since me(Camille) is not the requestor. Is there a way to do…
-
breakback when using average in the summary
Hi everyone, When building a model, I came across the need to do breakback with an average as summary method, but I found that this option is unavailable. Basically, what I wanted was to be able to adjust the values month by month and see the influence that it has on the average of the full year and also be able to adjust…
-
Identifying REAL First/Last Month Monday Dates
Hello everyone, Please see the picture enclosed. I am trying to get Anaplan to identify the first and last Monday-dates of a given month, but I keep getting the wrong results due to the native calendar setup. Can anyone help me with a workaround? Maybe through convertering it into text and then into values and then setting…
-
Filter to show only list items with a monthly value?
Hi! I have a P&L based on a list of accounts (rows) and months and FY (columns) where I want to show only accounts which have a value <> 0 in any of the months in current time period. Today this is solved by a filter in the P&L to show only accounts with a value <> 0 for FY21 OR FY22 OR FY23 (model holds those three…
-
Error : Time Filter to two dimension (Time*Lineitem)
Hi, I want to filter this table by Time in UX. The point is this table has two dimension(Time and Lineitems) in columns. Table A I prepare Time Filter Lineitem dimensioned by time(Quarter and Users) After I filtered Columns(Time,Lineitems) in UX, but I can't see any Time and Lineitems. Table A (Filtered) If I filtered to…
-
Add or Adjust Time Dimension On An App Page
I have a schedule that is populating Q3 numbers, even though we are only in Q2. After doing more research, I believe it relates to there not being a time dimension on this page. Can anyone provide guidance on how I would be able to add or adjust the time dimension so that only prior and current quarters are populating? For…
-
Community perspective: Add a timestamp to processes utilizing Anaplan API and Python
Anaplan is a critical tool for different business processes, and it is used to handle a variety of data. One key attribute for data quality is the timeliness and reliability of the data. It is a known best practice to use Data Hub for centralized data management and then import data to different spoke models. Even though…
-
IF Then Else Issue
I want the Repair and replacement = Flat terminal then 1 else o (or) True else false No getting the result
-
Calculate classic month summaries in week model
Hello, I have a model set with a week 4-4-5 model calendar. In this model I created a module where I input the team presence per day. My issue is that I would like to calcule number of days worked per month, I mean from the 1st to the 30th and not by week as it sums up days from prior months (see image). On the image,…
-
Making the same Line Item both Editable and Formula Driven
Hi, I was wondering if there is a way to make the same LI editable and formula-driven at the same time. Assume that I have a module with a dimension D and line item L. Now the Line Item L is a list formatted dropdown of list P. P is a property of dimension D, which is defined for certain items of list D but not all (say…
-
level 1 lesson 14.4.2
why my line chart is showing a straight line only? it should be like this.
-
level1 lesson 14.6.1
how to change the product list to pages. it is showing in Row
-
IF then Else issue
I am Having two list formated line item, NOw i want chek true or 1 base on the one list item to other list item how can i acheive that
-
add a role list
how to add a role list in the model
-
exam 1 activity 6
why my region row is blank
-
exam level 1
stuck in Activity 2 i am stuck here please help
-
Parent hierarchy & Top level
Hello fellow Anaplanners, I have a query, I was going through an existing model and where I saw there are multiple composite hierarchy built having just 2 lists. i.e one is parent list (say 'X') and another is child list (say 'Y'). Now here in first list 'X' (which is parent for the other) there is only 1 member 'All X…
-
Ability to import a table from a report page to a board or worksheet
Hi everyone, I was wondering if it is possible or if anyone knows how to move a table from a report page to board or a worksheet. In this specific case I had to use a report page in order to use the "variance in report pages" functionality which does not exist neither in board or worksheet pages. This is what I have…
-
Statistical forecasting App in UX
Hi all, I can see that there's a statistical forecasting App on the App Hub that can be downloaded but it looks like everything is in Classic dashboards. Does anyone know if there's a version of the app that uses the UX? Thanks
-
Add columns to modules with differences and ratios and between years
Hi everyone, I have I doubt which is if it is possible to add a column or more to a certain module in order to know for example the difference between the revenues in FY20 and F21 or a ratio that shows how much it grew from one year to the other. In this specific example I want to create something as can be seen bellow…
-
Compare TEXT Values in Anaplan
Technical Summary Statement The objective of this article is to compare values in a TEXT formatted line item and identify the values that occur more than once (duplicates). Problem Statement Sneakerz is an up-and-coming shoe company with a variety of shoe brands in its brand portfolio. They are expanding internationally…
-
Lookup Sales Based on drop down list
Hi, I need to retrieve the historical sales based on the selected Store from dropdown list of my module. Here in Module 1, the Store List has no sales for specific SKU that is why we're going to get the sales from the similar store. Module 1 Dimension : SKU, Store List, Time (Line Items: For Expansion?, Similar Store…
-
Add columns to modules with differences and ratios and between years
Hi everyone, I have I doubt which is if it is possible to add a column or more to a certain module in order to know for example the difference between the revenues in FY20 and F21 or a ratio that shows how much it grew from one year to the other. In this specific example I want to create something as can be seen bellow…
-
Reset boolean when selecting a new hierarchy in UX
Hi all, Hope someone can help me I have a 2 grids connected and set with restrictive access, What happens: First: When I select the country (1st card) to be updated on the graph (2nd card). The selection is kept when I change region. Example: US-Chicago Second: But if I change region to Europe, the Chicago previous…