-
User Dimension-User Filter
Hey, I have been stuck on a particular issue. I have a module dimensioned by list A. One of the line items is called "Approver", list formatted to a fake user list-subset. So every list item of List A has one approver of its own. In my second module which is also dimensioned by list A, I want to ONLY show the list items to…
-
Line items number
Hi Is there a limitation on the number of line items in a module?
-
To be able to use an action to change the order of items in a list
Description of the enhancement required: To be able to use an action to change the order of items in a list. An example of the enhancement: I have a list, FRED, which is populated from a SQL query containing an ORDER BY clause. However, new items are always inserted at the end of the list (or rather, at the end of the…
-
9.2.5 Activity Error
Hi I am not able to edit 0 to 5% in unit cost %. Please guide what could be wrong here. Screen shot attached. Thanks -Pooja
-
User filter-User Mapping
Hey, I have been stuck on this particular issue for sometime now, wanted to check if someone here could help me out:- I wanted to filter list items of List A for the end user based on a non system users list subset. I have a module 1 dimensioned with list A, one of the line items in that are list formatted to a non native…
-
Defining levels on Ragged List
Hi team, Is there a method to define levels within a ragged list? I have a ragged list which is being used in a complex filtering exercise & for 1 of the conditions I want to only display the Lower level of of the ragged list (see screenshot whereby both Income and Profit & Loss are L1 but I wish to create a condition for…
-
Copy model from point in history
Description: Take a copy of the model from a point in history, based on the model History ID. Impact: This would allow investigation and audit of production models without affecting the source model. But there could be concern about this affecting storage, if people begin to create more copies. Example of enhancement: I…
-
Level 1 Exam
Hi Can anyone please let me know if there is time limit on Level 1 exam? what is the format? how many tries we will get for each question? Thanks -Pooja
-
Level 2 - Sprint 1 - Data hub - 1.3.10.4 Check Your Work - not getting data as expected
What is expected: 1.3.10.4 Check Your Work After completing the import processes, the G3 Location list in your Data Hub model should look like this example: but what i get is: 😞 Below are from other lists: G1 Region: G2 Country: i feel i missed something in the G2 Country, but please check the above screen shots and advice…
-
Move Format column to before Formula column in Blueprint mode
Description of the enhancement required: I would like to submit an enhancement request in regard to the Blueprint Mode of modules. I would like to move the format column before the formula column. An example of the enhancement: When you are creating new line items in Blueprint mode, the first column that you see from left…
-
Custom Filter for Multiple selection
Hi, I want to create custom filter using a dropdown but in that dropdown I want to do multiple selection. I tried doing it but was successful with one selection. I even tried using Boolean selection method but that is not a user friendly way. Can anyone please help me what should I do for multiple selections in a custom…
-
SYS01 DEM03
Hi Team, I am struggling with DEM03 and the SYS01 Time Settings by Week Firstly, in SYS01, 1st Forecast Year remains empty, please see attached the blueprint of the same and the associated formulae as well as the time settings view. This in turn I believe leads to DEM03 Demand forecast to be empty for Baseline Forecast.…
-
While Importing a numbered list the name row is not getting populated
I am trying to import a numbered list. while importing I have selected the source as Code and Target as Employee list. when I run the import , all the column headers(department, country) are getting populated , except for name. What could be the issue here?
-
Calculation Function - Minus Disposal Month
Hi Everyone, I need some help in building a model. So basically, from the above image, I have manage to read the Total Nominate TEUS for each month but I'm not sure How to: 1) let the system to know that, if there's a disposal in a particular month (eg. March and June) then the follow month (Apr and Jul in this example)…
-
9.2.5 Activity help!
I read a bunch of other comments regarding the 9.2.5 activity and tried to follow along to troublshoot the error I was receiving. however, I am still unable to find the root cause of the issue. I keep getting the below error. Can someone please help me in figuring out where I may be going wrong?
-
Boolean Filter Line Item
Hi team, I have a Filter module to calculate filtering at a row level due to some complicated requirements. There are 3 dimensions being: Location L3 SS: GL - EBITDA Report (L3 in Hierarchy) SS Channel - Budget Channels (No Hierarchy) On Level 1 of the GL dimension (List Item: Income) it is returning TRUE in the 'OPEX…
-
Sorting items by code or name in number lists
Description of the enhancement: New items are added at the bottom of a list or at the bottom of a node when there is a Parent. How this enhancement will improve you processes: Re-ordering or sorting a list is a one-by-one manual operation that can be time consuming.
-
Level 1 Anaplan Model Training Data Mismatch
Here are the formulas that I'm using, but every time I input them in EMP02 I get this error: Data type mismatch: format other than LIST or DATE being referenced as a relation Bonus - IF Employed? THEN Salary * 'EMP03 Employee Drivers By Role'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee…
-
Import Issues
Hello all, I am having some issues in importing the data for Level 1 Lesson 10.2.2. I have made the module correctly but when it comes time to import the data I keep getting the following error messages. Is my matching correct or have I made a mistake somewhere? I have attached screenshots below. Any assistance is greatly…
-
Import into DEM01 module failed: The column headers in the file you are attempting to import do not
Hi, I'm trying to import data into the DEM01 module. I'm getting this error: "Import into DEM01 module failed: The column headers in the file you are attempting to import do not match the import definition". How do I resolve this issue? Please help. Thanks, Dora.
-
Rep 03 Module
Hi I have a confusion in Sum Function: why 'SYS08 Employee Details'.Country is used as cross function in Sum formula of Rep 03 module. Thanks -Pooja
-
"Search" box for the list when list is assigned as a line item format
As a model builder, I would prefer to have a "search" box to look for a list name when I assign a list as a line item format. Currently, I can only scroll to look for a list name. "Search" box is more efficient than scrolling when the list is quite extended . What do you think?
-
9.2.5 Cost % is not flowing to Rev 05
Hello, This percentage is not flowing to Rev05, what could be wrong here? please advise. Thanks -Pooja
-
The page selector to show only the year
hi! I want the page selector to show only the year when the Time axis is month. What should i do?
-
selection control
hi! I want to create a module that allows me to select only some of the items in the pull-down menu. Example:I want User to be able to select only Apple, Peach, and Orange. I want to make it so that Fruit and Grape cannot be selected (not displayed). Can i do it? Please help me.
-
Calculating Levels in Hierarchy / Filter out sub-level
Hi team, We have a 5 level composite list & in the top level (Region L1) there is a sub-composite list (by that I mean there are list items with parents within the same list, i'm not sure of the technical name for this - see attached screenshot where China, Korea & Japan are child parent of Asia, all within Region L1) I…
-
Revenue Formula is not working
Hello I am stuck here, not able to add formula. Error is unit price is not a valid item. " 'REV01 Price Book'.Unit Price is not a recognized line item or list member Thanks-Pooja
-
Filter for both List Items & Parent Item on 1 view
Hi team, I'm trying to create a view whereby I filter on all list items for 1 section & then on the Parent list items in another 1 have 2 lists, being GL & Subsidiary both on rows. My requirements are: - For the GL List Item GL.Sale I wish all Subsidiary items to display - For all other GL List items I wish only the Parent…
-
L2 1.5.6.1 DAT03 Level 2 Sprint 1
Hello Community, I am currently having difficulty figuring out where I have when wrong with the L2 DAT03 Historic Volumes module. The lesson states that the time frame is FY19 (which I have selected), and I have imported the csv file fine, but the module is not showing FY19. Instead it is showing FY20 & FY21. This is…
-
Lookup, Sum and Textlist Cheat Sheet
Hi all, During the last CPX in London, which was fun and insightful, came to my attention the fact that still now-a-days the most searched topic in Anaplan Community is "how to use Lookup and Sum". That is why I decided to share with you all this visual and brief explanation of how Lookup, Sum and Textlist work, I hope you…