-
Don't Use Show/Hide on Production List
DON’T USE SHOW/HIDE FEATURE ON PRODUCTION LISTS We recently had faced an issue – On the dashboard there was one production list (Let’s say P1) as one of the dimension of a module. We had created a saved view by using Show feature on P1 page selector because we wanted to show only a few list items to the end user and not…
-
Filter Issue
Hi All, I have 2 modules, Module 1- Dimensions - Entity, Custom Version, Time Period, Department Line Item - A,B,C Module 2- Dimensions - Custom Version Line Items as Follows: When i apply this filter in source module (module 1) , It still shows me the estimate and budget. which i wanted to hide. (Jan 22, Feb 22 for…
-
Need solution
Hi Team, Please can you suggest how to get the values for "Shipping Costs" in my activity it is showing "0". But as for the formula 'INV01 Inventory Ordering'.Final Shipping Costs[SUM: 'SYS08 SKU Details'.Distribution Center] - In INV01 Shipping Costs values "0". "
-
Action's Start Date and Time (UTC) - removed at any time?
Hi, I wonder if anyone knows if the Date and Time (UTC) in the Actions tab gets removed at any time? I am quite sure i ran a process in oktober. When looking in actions tab now - the Date and Time (UTC) is BLANK. I can see no dates older than 2022-01-01. Thank you in advance! /Caroline
-
Dear Anaplan ... Why?
Dear Anaplan, I love the new Model Experience, it's elegant, organized, gives me easy access to things I need and the search feature is amazing. Unfortunately, I can't use the A+ Chrome extension with it. Why would you take that away from me 🙁? My productivity is at least 10% lower. (shhhh don't tell my boss) I understand…
-
How to Use Below Functionalities
There are certain functionalities which you might have ignored, seldom used or don’t know if they are available in Anaplan. Here are a few functionalities, their location in the model and the usage of these. Hope you make best use of these functionalities. Brought-Forward: You can see this functionality in the blueprint…
-
Circular Reference Error While Calculating Opening Base with Custom version
Hi All. I'm facing an issue in solving the Opening Base Calculation. Please help to resolve it!!! Custom Versions - Actual, Estimate,Budget Time Period (in Months) Country List Department List GL Accounts In the below screenshot, closing base is the sum of Opening Base,Gross Activation and Churn Rate. When i try to…
-
format of mapping used for lookup doesn't match any dimension of the source
Team, I have one System Module and other Exp drivers module. Created a new module and adding formula to get the expenses numbers. But am getting format error. This is the snapshot of my Systems module This is the expense drivers module THis is my Target module with Formula
-
When to use Lookup & Sum function
Hi all, Could you please explain when to use Lookup or SUM function, I remember there was a lesson in MB Level 1 course but I am unable to find it. I will really appreciate if someone can provide a link to the lesson or explain the difference in term of when to use them. JH
-
To Hide Blanks Cells with multiple dimensions in a Module
Hi All, I have a scenario where i wanted to hide the blank cells. (Blank cells - switchover versions using DCA). As Per my below screenshot,i want to hide JAN 22, FEB 22 , OCT 22, NOV 22 AND DEC 22. Thanks, Aish
-
2.3.9.1 Import data into DAT03 Historic Volumes module
Hello All, Need your help.I am getting Model object "'DAT03 Historic Volumes'.Export" could not be located for 9.1 Import Historic Volumes. Rest of the two : 9.2 Import Opening Stock, 9.3 Import Shipping Metrics are fine. Do I need to change DATA03 Historic Volumes Time Range from FY19-FY20 to Model Calendar? or could it…
-
Very Confused on Level 3 TAR01 Module
Hi, I'm having alot of trouble with the LOOKUP formulas for this module. I'm trying to bring in my DAT01 Actuals into the TAR01 Module by Country and it is not working. My dimensionalities are correct and all, but I think it has something to do with my G2 List. I have been trying to figure this out for 2 days now and…
-
Allow for filtering on Users tab
As a Workspace Administrator, I'd like to be able to filter and sort the Users tab based on values in different columns — just like we can do it for modules. The most important is to allow for filtering on 3 columns: Model Role, Workspace Administrator and Single Sign-on. This could really help with managing users access…
-
3.3.12 Activity: Create Product Replenishment UX Page - Time context selectors
Hi, I have created the Product Replenishment UX page and it is almost look like the prototype page shown in the lesson. The problem is I am unable to put time context selectors on the page. Can someone please advise what am I missing and please review the screenshot of the page and let me known if there is any other…
-
Discover
Getting started is often the hardest part! To support you in your journey, we've compiled a list of valuable resources to set you up for long-term success. GENERAL KNOWLEDGE * The Anaplan Planual: The Planual is a must-read resource for all model builders as it establishes a foundation of best practices when building in…
-
Formula for First week of Timescale.
Hi Everyone, Could someone please explain this formula in layman's language. OFFSET(1, -1, 0) = 0 Thanks JH
-
Grouping line item data?
Hi All, I'm new to AP and I have a question..... I have a module that has Employee, Product Line and time as the dimension. My question is how do I tell Anaplan to group by certain products only? ie. Product Line: Apple, Pears, Oranges, Fig, Lemon, Tangerines. I want to group : Apple and Pears into "Fruits" , Oranges and…
-
Level 2 Sprint 2
Iam unable to do conditional formatting and view of Line items(Intial and final forecast together).Attached 2 pics one with conditional formatting(connected to forecast cf ) and other without formatting. How to get the below
-
Sprint 2 Target Item Level 3
Could anyone please advise, why no data is showing here? If I remove the lookup function, still no luck.
-
Write Access by Column not Row
Hi all, I have a module setup with a list as the rows, and line items as the columns (there is only one line item, a boolean). I wanted to have it so each row (i.e. each item in the list) has it's own write access driver, but of course due to the nature of modules, in the blueprint view there is only one driver as it's per…
-
9.2.6 Activity: Add Formulas to Margin Calculation Module
Can you please help? I coppied formula i think no issue about formula. Expected: Mine
-
Level 2 Conclusion: Activity: Currency Conversion - Import
Hello, Please, help me I have created the module FX01 Currency Rates, but I'm troubling the import data to the module. I have the following selections, don't understand why it does not work but it gives the error Hope you will help! Thank you, Anton
-
7.2.3 Activity: Import Data into Employee Details Module
Hi Team, In the Level 1 Model Builder activity 7.2.3 Activity: Import Data into Employee Details Module , do we have to manually map mappings for E2 Employees between source and target items ? Is there any way for the mappings of E2 Employees ? Please help as it is very lengthy process to do the manual mappings for 111 emp.
-
Alternative to IF Historical Period? formulas
Hi All, It seems like almost every model I've taken over has relied heavily on something to the effect of: IF Historical Period? THEN Actuals ELSE Forecast I've seen some really **** formulas that have separate business logic for historical and forecast periods nested within the two conditions. Generally, this issue is…
-
Managing subsets from a module
Is there a best practice for managing many subsets(within the same numbered list) from a module published to the NUX? I have a numbered list with 25 subsets and need a way for the model admin to update the subsets as new list items are added.
-
Boolean Formula in List item
I have 3 level hierarchy Namely --- Country > State > District State and District has line items as properties namely Active in Boolean format i want to connect the two by using formula like if parent(district) = true then true else else is there any way to achieve it without using module?
-
How to avoid duplicate item with time (ISFirstOccurence)
Hi I want to make concatinate List. I have this table. Customer is determined by Product. Supplier is determined by Product and Time(week). Now I want to Customer-Supplier List. But in this case, I cannot identify unique key(Customer-Supplier Lineitem). So When I import to Customer-Supplier List, duplicate error has…
-
Tar 02 - PY Account Revenue
Hi - Not sure why data is not populating in PY Account revenue. Formula I am using is "'TAR01 Detailed Sales Targets'.PY Account Revenue[SUM: 'SYS03 Account>Product Details'.'A1 Account']" As the Dimensions for Tar01 and Tar 02 are different and I am mapping it through Sys03.
-
Level 3 - Read only cell error
Hi - I am not sure why below error is popping up.
-
Display a list of existing saved views when using "Save As"
When a model builder selects "Save As" in a module, it would be really helpful to see a list (dropdown?) of saved views already available for that module. This would help * When a model builder is trying to overwrite an existing saved view; they wouldn't have to type out the exact view name character-for-character, instead…