-
How to Use Lookups from Multiple Modules with Different Dimensions
I have three modules with different dimensions: Product Details: Dimension: 'Product' Line Item: 'Dispatched Qty' Formula I used is : 'Order Import Data'. Dispatched Qty [LOOKUP: 'Order Import Data'. FIND_PRODUCT] Attributes Allocation: Dimension: 'Allocation ID' Line Item: 'Dispatched Qty' Formula is : 'Order Import…
-
User rights - summaries
I have access rights set for a user on customer list and on product list. Because they are both under hierarchies, once I set their visibility in the lowest level list of the hierarchy, the user can't choose a total to view all the customers/products. how can I still provide them with a summary?
-
Column type issue
There are some columns, like 'ReportingPeriod' and "Curr_Q" should be Number type while "Comments" field should be Text type. In this case, any suggestion how to set the line item format? For example, the first line item "Global Allocation", what format to be set? either Number or Text is not correct I think. Thanks.
-
Best Practices for Optimizing Anaplan Model Performance?
Hi everyone, I’m working on a fairly large Anaplan model that’s starting to experience some performance issues, particularly when running complex calculations and data imports. I’ve already tried reducing cell counts by removing unnecessary modules and optimizing sparsity, but it hasn’t made as big of an impact as I hoped.…
-
Returning same value from same Line Item but different items
Hi all, Is it possible to return a value from an item on the same line item? For example, picture this as my module: I want to be able to calculate a delta between S1 and S2 or S3 and S1, like this: Here I'm using SELECT but this will be a lookup since I want the user to be able to select which scenarios he want to…
-
Definitive Current User in a formula
Hi, I have a list of invoices with an approver selected from the user list for each line item, what I want to do is check if the 'current user' is the same as the 'approver' and if so then allow them to write to the item. I have a fake users list, and i can have a module with users with show all set to off, but none of…
-
Current year filter with YTD and YTG
Hello Community, I need a filter in my sys module which should show only current year (this should be FY24). I also need YTD and YTG for this year, i.e current year. I also need a filter for next year. i.e current year +1 and again should be filtered on same year YTD and YTG. Is this possible in Anaplan. Kal
-
Summary module - referencing list with properties
Looking to create a module that provides a summary of a fairly detailed data set that has multiple dimensions, with having originally built this by adding the relevant dimensions to the module and then using a formula similar to the below, just referencing more elements…
-
How to use TimeSum?
Hi! I am new with Anaplan and still learning the functions. May I ask how can I make a summary from a module with time dimension to a module without dimension? Here in the 1st picture is the by field with its actual value, input on a daily basis. Then I have to create a separate summary to show the total actual without…
-
Restrict access to summary items in a line item drop down when using a ragged hierarchy list
Hi, Is it possible to remove the summary items from a drop down list when a line item is formatted with a ragged hierarchy list? Cheers
-
How to make picklist selection user dependent
I have a situation where target lineitem is populated based on the picklist selection. The problem is when multiple users are making the selection, the latest selection is being used. I need this to be dependent on users i.e., one user selection shouldn't affect the other.
-
How to transpose data
I have a module A - Dimension Class and Subject In the module, I have a line item (list formatted) called Order. User will use this module to define Order for each Subject for each class. eg. For Class X; SubA - Order 1 , SubB-Order2 etc. Now I want to create another module dimensions by Class and Order, That can show that…
-
Level 3. Finalize Assignment button in dashboard
Hello, About "Finalize Assignment". There is not much info about this action in training material nor in the community. What does it supposed to do? Thanks,
-
Average Market
Hello, I have a list of 200 companies with all their P&L numbers in a module. Now I want to sum all the data of the 6 biggest of these companies into one artificial company to have a market average. How do I sum the 6 companies that I chose into a company called "benchmark Market" and then compare any single company to…
-
6.6.3 Activity: Add Formulas to Time Settings Module
When i add formula to Current Period Start ..it is not giving any result. Further the Forecast Period? and Forecast Months Only should come as untick. Any help will be appreciated
-
"Unable to Find Workspace Model Data - Check your connection and try again" Issue in Anaplan
Hello Anaplan Community, I am encountering an error message in Anaplan: "Unable to find your workspace Model Data. Check your connection and try again." This issue seems to be related to the connection, but I’m unsure of the exact cause. Has anyone experienced this before? What could be the potential reasons for this…
-
History export fails & unable to view history
Hi All, We are facing one issue that we are unable to export or view history as there is too much entries & error shows time out. Can anyone have any views to resolve same? Thanks Ashutosh
-
Level 1 exam Activity 5
I'm stuck on Level 1 exam model building exam Activity 5. I've spent over 2 hours and I'm frustrated. I've followed these steps and my solution is below with the updated formulas. Can someone offer any suggestions as these updated formulas result in the output being NIL/$0. I'd really appreciate it. And my formulas now…
-
Top Down Approach
Hi All, Check if you can help in the following scenario. I have 2 list PRODUCT & PRODUCT FAMILY (parent of product). Module 1 : (with PRODUCT as dimension) Line item : Check? (Boolean) User will select the product as needed. Module 2: (with product family as dimension) Line item : Check Product Family : ???? (if the…
-
Level3. Commission Forecast
Hello, I have my total target per sales rep yearly as seen below and the numbers does match with ones in the study material: In the Commission forecast I am using monthvalue formula to compute the commission forecast but the numbers are not showing up. Please advise: P.S I have tried quartervalue also and it didn't work.…