-
How to set a unique code based on Store/date information ?
Hi everyone, Does anyone know how I can generate a unique code by Store/date combination, knowing that the date is a current date that will be changing every day, it's going to be the order ID and and it going to have to start by a #: Thank you for the help :)
-
How can we show exactly what user wants in an input template?
Hi community, Its been a while I have not asked anything. What I need is as below. I have a module with entity (filter) and CoA dimension (in rows) for user input in forecast months. That's working fine. But now I have to incorporate a cost centre item in the grid so that users will have an option to select a cost centre…
-
How to dedupe txn assignments on owners that appears in multiple assignment columns?
Hi all, I have a module, which is dimensioned by Txn, and within this module, I have a few columns where I can assign owners. Txn Assignment Module: Parent Account Name Oppy ID TXN Name SOL Terr SOL Terr 2 SOL Terr 3 BMO 111 1 Loner's Territory BMO 111 2 Loner's Territory BMO 112 3 Loner's Territory I want to create a…
-
Rolling forecast
Hi , I have a requirement for my stakeholder to have a medium term forecast (by month for the next 6 months) and a more detailed rolling 15-week sales forecast by day which will then feed into the wider Supply Chain planning processes over time. This needs to be updated by the Sales representants for consolidation by the…
-
Saving any data against parent members in a flat hierarchy or derive their levels.
Hi, As part of our use case, we need to publish org charts. After careful consideration, a flat hierarchy works best (not as per best practices, I understand), but when it comes to publishing KPIs on Pages, it seems almost impossible to calculate something at parent level. e.g. Here is the list. It's a flat Hierarchy How…
-
Performace of using LOOKUP and SUM in the same formula
I've heard many times not to use LOOKUP and SUM in the same formula because it negatively impacts performace. However, I'm looking at the "calculation effort" cell and it doesn't appear to be negatively impacting performance much at all. I have the option of using some if statements instead of the SUM formula in my…
-
Count Unique Items Function
Hi, I have 2 lists, 1 is products and 2 is numbering - see screenshot. I have a module where it is dimensioned by product and the numbering and I want to count the number of unique values. Based on my screenshot, it should be 15. I saw there was a formula - isfirstoccurrence, but I'm not completely sure how to use this.…
-
Loading Data at Parent and Child Level but avoiding double counting
Hi Community, I am stumped on how best to handle this situation. I have to ingest data at multiple levels of a list hierarchy. i.e. Parent Level (fruit) and child level (eg. apples) but I need to avoid double counting when reporting? I am struggling with how best to handle the situation without double counting or excessive…
-
Propagate data from branches/parent lists to leaf lists
This one is not for the faint hearted lol. Functionality is to have ability to capture business policies at different levels of the hierarchy. Business policies have customer and product as dimensions. The customer/product list levels is configurable. Customer list has the following hierarchy: Country ⇒ Channel ⇒ Customer…
-
Common Reasons you cant add a dimension?
Hi all, I have a very complex model. It won't let me add a Product dimension to it. The processing time is so long (25 min) that it just times out and never gives me a reason. I was wondering, what are common reasons you can't add a dimension to a module? thanks in advance
-
Reverse BOM recommendation based on Attributes
Hi, Consider this scenario for a Diamond Industry supply chain Demand for Diamond from customer comes with various attributes [cut, carat, clarity, etc etc] Prospect has made over the years diamonds with various attributes. This historical data is available [both BOM and Recipe]. There is a unique Stage 1 BOM and Stage 1…
-
Level 3 - DAT02 PY Revenue to CY
Hello all experienced MB's Created a Module to Pull PY revenue to CY, Module has dimensions A2 Account>Product# and G2 Country. Whatever country I select the value shown is for ALL regions This is something to do with aggregations, but I'm struggling to figure out which is correct, surely SUM is incorrect. Any suggestions?…
-
resetting filters
What is the cleanest way of resetting filters on in a page in Anaplan? Is there a way of defaulting the filters to show the total level? Thanks.
-
How can I understand which columns are needed in an upload file?
I am looking at uploading a flat file and getting the error of "property-based import has one of they key properties unmapped - cannot proceed". So I was thinking, how can I understand exactly what the headers should be in an excel for flat file? is there a way of finding this in modules? e.g the columns should be…
-
List Help
Hi, I have a list of bank loans. In this list, there are some bank loans which are no longer current, but my total of all bank loans includes this in the total. As there will be new loans, loans repaid throughout the period, what is the best way so I can see a subtotal of only current loans? Thanks,
-
Numbered list
After Importing into a numbered list, the list contains Number, how to show the Name instead.
-
History Pull Inconsistent Record
I pulled the history log for a specific time period and filtered it by module, line item, and list items. I'm trying to understand how to interpret this history: Row 1: Previous value was 0.5 → changed to 1 Row 2: Previous value was 1 → changed to 3 Row 3: Previous value was 0.5 → changed to 3 Row 4: Previous value was 3 →…
-
Lookup error : invalid lookup list X is unused
Hi guys, I am facing an error for the first time and I was wondering if anyone had an idea on how to get throught it For some context I have : LI1 reference dimensionned by "Dimension A" format number LI2 target dimensionned by "Dimension B" format number LI3 dimensionned by "Dimension A" format "dimension B" (a basic…
-
Level 2 Sprint 3.3.5.2 Confirm Purchase Order Receipt Line Item
Hi everyone, would really appreciate if anyone could help me with this problem. My formula is 'IF Confirmed PO Delivery > 0 THEN OFFSET(Final Shipment Amount, -Final Shipping Time Weeks, 0) ELSE 0'. Is this formula not correct? I have been trying several different formulas using my logic but cannot seem to get it right.…
-
Context Selector filtering on UX page
Hi All, I am stuck with a request where I need to filter a list based on a Boolean condition. The Boolean condition is working all fine but when I publish and apply over the app page, there is a version selector which is causing the issue. Its asking me to choose a specific version for the Boolean to work, but I want it to…