-
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…
-
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…
-
L1 Model Building Exam - Activity 2, Need Help!
I am working on the L1 model exam and in activity 2 I'm confused about the mapping of the data.I think I've done everything right except for DATA02 SKU Volumes Line Items. I have no clue how to map that even though I know it begins on row 2. Can someone please help advise as to where I went wrong?
-
DEM03 Demand Forecast - adding Overrides exceeds size limits
Hi - working through sprint two of level two I am at the stage where I need to add three line items for the Override Forecast functionality, but cannot as this exceeds the size limits. The module uses the lists P3 SKU and Accounts, Timescale is Week and Time Range is Model Calendar. Total cells is 34,721,544. Perhaps my…
-
L1 Model Building Exam Activity 5 - Need Help!
I have been stuck on this problem for the past day now and have been unable to figure out where I am going wrong 😭 It says: In the EMP02 Employee Expenses module, update the formulas for Bonus, Car Costs, Phone Costs, Medical costs. Update the formulas to reference the driver data in the Drivers by Role module. The…
-
How to Connect Data Modules that have different Dimensions
Hi, I need advice on how to connect two separate Data Modules with different dimensions. I was thinking if there is a way to create a mapping module to connect them. They both have a similar LI's called Merchant ID. A screen snip is below of the two modules. Blue Print Common LI in the Modules Thank you
-
MB - L2 - S3 - 3.3.5.2 Inventory Ordering Module Formulas
Hi Everyone, Could you please help me to compete activity 3.3.5.2. I am struggling with the missing formulas in the screen shot. I will really appreciate if someone can help to resolve these formulas. Also please let me know if all other formulas are correct. Thanks JH
-
P2 Product and Product Platform Level 3
P2 Product and Product Platform is not populating any data, even though I tried to create Display name and using that in Formula FINDITEM(Product Flat, Display Name) and the message I am getting is " Display Name is not a recognized line item or list member Please advise. I am stuck here 😞
-
MB - L2 - S3 - 3.3.5.3 Check Your Work ( SUMMARY TOTAL - MISMATCH)
Hi Everyone, I am having issue with matching my work after putting formulas in sprint 3. All value are matching but summary totals are not matching at SKU level and All product level. Please advise what have I done wrong and how can I fix these issues. Please see the screenshot of my model against required numbers. SKU…
-
About Anaplan notes
Hi I want Anaplan course notes in pdf format for study, Guide me on how to get notes
-
Rank function with Time
Hi, I want to use Rank Function. I want to rank "Num" with Location-Product. I input formula into RANK Lineitem. But the Rank function doesn't run. What is the problem?
-
When do I use SUM vs LOOKUP?
Determining whether to use SUM or LOOKUP depends on how the mapping table is set up between the Source List (where the original data resides) and the Target List (where the formula pulling the data resides). A mapping table between the Source List and Target List can be set up in one of two places: (1) in a Module, using a…
-
3.3.7.2 Add DCA to INV01 Inventory Ordering
Hi, As it is mentioned in the activity to highlight the weeks when the line items are checked.I am unable to do this. Can someone please help me? please find the attached.
-
INV01 Inventory Ordering module - Shipping Method formula issue
Getting error when i am using below formal for Shipping Method in "INV01 Inventory Ordering" module , Tried so many ways but no luck can some one help me some thing is i am missed 'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)' [LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: 'SYS07 Distribution Center…
-
Feb releases and...March sneak peek!
Make five minutes in your day and check out the latest release from Feb - with a sneaky look ahead to what's coming! February was a great month with a few really neat enhancements for the UX - I'm particularly liking the enhanced show/hide on UX pages and absolutely loving the ability in the model to see which UX pages are…