-
Assign values to duplicate items
Hi I have below module that is update every few days UID Name From Date To Date 1 A1 17-Jan 2 B1 17-Jan 3 C1 17-Jan 4 D1 17-Jan two records were updated when the next time(eff from) the job runs like below UID Name From Date To Date 1 A1 17-Jan 2 B1 17-Jan 3 C1 17-Jan 4 D1 17-Jan 5 A1 25-Jan 6 B1 25-Jan I want to…
-
Is there any way to export the line items wise view, by using export action(date format line item)
Line-item kept in page selector as Date format
-
Minesweeper: How we Built it?
Do you remember the good old days when we used to play games like Solitaire, Minesweeper, Pin Ball, Checkers, etc in your big and bulgy desktop? Oh! Those were the golden times of youth, even though we cannot match the high-end technological development in graphics, storyline, real life game play, regular updates but the…
-
Setting time as forward 52 week
Hello, For my model, planning cycle we look at it forward 52 week. The planning cycle start at the beginning of each quarter. so if we are in Q2 2024, 52 weeks will be from Q2 2024 - Q1 2025 I see option to set week as calendar type but for planning year, I can only select complete year. The only option I have is to select…
-
Change fiscal year without losing Data
Hi Everyone, Is there a workaround to change the fiscal year of a model without losing the data? My colleagues made their planning in a model that has timesettings for 2018, but they want to change the Fiscal Year to 2019. is this possible without erasing their data (which is manual input)? The Model only knows the current…
-
Hot fix
Hi All, I couldn't get clear outlook of implementing hot fix in prod environment, when we have development in progress in dev mode. We don't need the development to go to prod only the issue needs to be fixed and later we must progress with the dev model with out loosing the development. I am unclear of how many revision…
-
Bill of Material Explosion - Best Practice
Hi, Pondering my head around a Supply Chain use case where a bill of material explosion is required with an undefined amount of steps to get to the lowest level. This should be an iteration where an SKU can have a one level explosion or up until 6 levels of bill of material. What is the best practice of Anaplan to set this…
-
Level 2 Sprint 3 Exam
I have tried to take this exam. There are two formula questions where I provide answers that work based on the information provided. However, the system will not accept these formulas as valid answers. (Questions 3 and 9) How do I either have these formulas accepted as value or understand why they are rejected.
-
3.3.5.3 check your work numbers are out (most likely Dem03)
Hi team, Working through the level 2 model builder course and have hit a snag. My Dat03 Historic values is populated and working as intended with the forecast year pulling the value from the previous year I believe my demand forecast is also working as intended with FY21 pulling from FY20 My issue is my final forecast is…
-
Dynamic Cell Access
Hi, I need to apply two DCA in one single module. It is like I have done driver based planning and applied one DCA with that. Another DCA I need to apply is for approval. Like if a checkbox in one line item is approved then related module line items should get disabled. Can anyone please help? Thanks
-
Why am I receiving the error "Not a recognised line item or list member" in my example?
Hi Anaplan Community I have two modules (“Allocations Stage 3 Mktng Media Allocation Result” and “Allocated Expenses”) that I want to link together but I am getting the error “Not a recognised line item or list member”. Below is the blueprint of “Allocations Stage 3 Mktng Media Allocation Result” Below is the blueprint of…
-
how to average on roll up
I have a module where I have sales per country. I want to average sales and not add when I roll up to region or when I chose region from drop down. How can I do that?
-
Help on Selector
Say I have a module with multiple different items and each item has a sales amount, a corresponding sales region, customer, and line of business. I am trying to build a dashboard where I can view sales amount by customer, and then have sales region, line of business and other options as a filter. I have built a separate…
-
Help on circular reference with POST
Hello, Do you know if it's possible to force the formula POST like LAG with STRICT argument. My use case to be able to POST value in the future for stock equation. If I use LAG(value , Leadtime , STRICT) or POST(value, 2) the formula are ok If I use POST(value, Leadtime), I have a circular reference. So I try to help using…
-
Notification error
Hello, Sometimes I get this failed notification. In some cases it works, sometimes it doesn't.
-
Anaplan Excel addin and windows 11
Hi Please advise: Quilter is migrating to windows 11. However, the Anaplan Excel addin - Check your software versions and settings for the Excel Add-in | Anapedia (anaplan.com) only supports: Windows version compatibility The add-in is compatible with: Windows 8 Windows 8.1 Windows 10. Self-Service Security Assertion…
-
NPV with Rolling Period
Hi - I am trying to build a module with an NPV calculation which in each month calculates the NPV of cashflows starting from the next month until the last time period in the module. So in Jan-24 it would calculate the NPV with cashflows from Feb-24 to the end of the module. Then in Feb-24 it would calculate the NPV from…
-
Level 3 Model Building: Schema Design - Part 2
Hi Team, Plz help me with the formula for Define in Active Subset? line item from chapter (4.2) List Subsets - Advanced Topics As I am unable to add subset in to the formula. @jared @Misbah
-
NPV with rolling start date
Hi - I am trying to build a module with an NPV calculation which in each month calculates the NPV of cashflows starting from the next month until the last time period in the module. So in Jan-24 it would calculate the NPV with cashflows from Feb-24 to the end of the module. Then in Feb-24 it would calculate the NPV from…
-
I am not able to Login to my Anapla to build models
I can login to view course, but when I try to login via this link it is repeatedly saying the pwd is incorrect. Im also not able to set it right as Im receiving no email. Do we need a business email or account to access this?
-
L2 Course - Supply chain model INV05 Shipping Export
Hi, Any expert please help , I am stuck in Importing G3 location in "INV05 Shipping Export" module , I alreay crteated Subsidery view doe CODE line item , in this Module , but while importing Data from G3 location List , it is ignoring the Parents like "US", please help me to understand what is wrong in steps , please…
-
I am hearing about custom versions these days and would love if someone provides an example of same
I am hearing about custom versions these days and would love if someone provides an example of same. Does we create any list for version or the versions tab for acheiving this
-
Export with different dimensions
Hello, I am trying to make an export. In my Export, I need to show on a column category Int and category Ext (both on same column). The problem that I have is that the domensions that I need to use for this information are in the Children of my dimension. Let me make a scheme; Dimension A - the one I have to use Dimension…
-
4.5.1 Activity: Rename Organization List, what to do:
Hello I am trying do the the Model 1 Lesson 4 but I am stuck. 4.5.1. In the model you are building, click the Lists icon on the model settings bar to open the General Lists tab. This allows you to see all of the Lists included in the model. When a new model is created, the Organization list is created by default. This list…
-
Average of active months
Hi, I have a module which shows asset values on a quarterly basis. For terminated products, the current asset values are nil. However, instead of showing nil, I want to show the average asset value when in existence. In my module there is a line item for product status and this can be active, liquidating, terminated but…
-
Anaplan for Financial Consolidation Use Case
Dear Anaplan Community, When implementing Anaplan solution for consolidation, what are factors that needs to be accounted. We have taken into the * Complexity of the calculations, * Data sources (Local / International) * # Of Entities * Account mapping * Currency Translation * Intercompany matching and eliminations *…
-
Import Financial Transaction Data
I have a financial transaction file I receive every night. This file contains multiple rows that contain the exact same data in each field. Is there a way to import these rows without failing the duplicate checks?
-
Circular Reference Problem
Hi All, I am having a circular reference issue in my calculation. Module A : Is dimensioned by Cost category List, Cost Center List, Time and Custom version List. (source module for forecast) Module B: Contract List and Time and Custom version List. (source module for Actuals) Module C: Is dimensioned by Cost category…
-
How to check how hierarchy will change before implementing
Hello, Does anyone have a quick way to check in the Data Hub, of what the impact to spoke models will be? Example: I have a 5 level hierarchy in my Spoke model and I create the codes in Data Hub. Then I can export to build the relevant lists. We want to change the hierarchy mappings in the Data Hub as business needs…
-
Is there any way out restore the history of QA model without breaking ALM?
Hi All, We have one case , where we need to restore the build & Data pushed in QA & Dev Model. Thinking of following Approach . Please advise if there is any gap or other way out : QA to be change the Deploy to Standard mode Restore the QA model from required History ID Post the successful of restore the QA will be get…