-
Level 3 Sprint 1: SYS03 Account>Product Details
Hi Community, I was wondering if I have missed out something here. Why P2 Product column did not get populated.
-
Level 3 4.6.5 Sale Planning Model: DAT01 module
Hi Community, I was wondering if I did my DAT01 correctly? Because to import DAT05 historical sales from Datahub to Sales Planning module, I will need to set both dimensions as A1 Account and P2 Product list. However, when I start to build DAT02, my dimension was A2 Accounts>Product list (according to the learning module)…
-
Check if a product belongs to a subset of products
I have a product list with a subset for a particular type of products (e.g., sweets). I have another module that is NOT dimensioned by products; however, product is one of the columns. I want to create a line item that returns true if the product belongs to this subset. How do I do that?
-
2.3.9.3 Update Historic Volumes for Baseline Forecast
Hello everyone, I encounter a problem concerning the formula of "Offset Volumes for 1st Forecast Year" . I wrote the formula that seems logical to me but it doesn't work. Can someone help me correcting it ? Thanks in advance. N.B : The first image represents hints for the formula and the second image is the formula that i…
-
Add new line item to import action
Is there a way to add a new line item for a source module into an existing import action? I have created a new line item 'X' in both the source and the target module. The new line item 'X' appears as an option to map to in the target module when editing the action, but it doesn't appear in the source module list to select…
-
Do ignored columns (from imported files) take up space from my model?
Hi guys! Do ignored columns (from imported files) take up space from my model? Thank you very much!
-
Level 3 4.6.5 Sale Planning Model: DAT02 module
I have tried to formulate the PY actual sales revenue as 'DAT01 PY Revenue'.Revenue[Lookup: 'SYS00 Time Settings'.PY Qtr,Lookup: 'SYS03 Account>Product Details'.'A1 Account'] Below is my screenshot for DAT01 whereby I imported the numbers from DAT05 in Datahub. Below is my screenshot for DAT02 module: However, I received a…
-
MOVINGSUM Formula
Hi, I have a snapshot of what I require done in excel but can't get the MOVINGSUM formula to replicate this. I have Pass Sales on a Generic Weeks Timescale model. The pass is then spread out by the number of days in each week that it applies to. Basically I'm trying to defer revenue over the time of the pass. Sales in the…
-
Seeking Guidance on Dynamic Addition of custom Planning Versions in Anaplan
Hello, I am currently working on dynamically adding planning versions to my Anaplan custom planning version list at the onset of each new month. To achieve this, I am in the process of creating a corresponding workflow. The challenge I'm facing is that the details of the next version are stored in a module. I need to fetch…
-
Can't add a parent to a existing list
Hi all, I am having some troubles adding a new hierarchical level to an existing list, which is called BU01 Business Unit and it's not a numbered list; the new parent should be BU00 Business Unit Combine: If I try to compile the parent hierarchy column, I get this error: If I try to delete All Business Unit from the Top…
-
Version ?
Hi all, I have a model and i need to Visualise my Company's sales history, Forecast compared to actual. input history sales for the year 2022. Calculate Bidget for the year 2024 Artual periode : septembre 2023 Is it possible to use versions to achieve this, and if so, how? I haven't worked with versions before, so I'm not…
-
Anaplan Workflow Access
Hi All, I've given access to myself as workflow owner but not able to see workflow tab . Can anyone have idea about that?
-
2.4.4 circular reference error
Hello Everyone can I know why there is a circular reference error when I try to enter this formula ?
-
Need ideas: Waste of Space to Accommodate Simple Report - Dynamic totaling, User Dim
Seeking some brainstorming ideas! The situation: We have a full final P&L module where one single line item is 17 gigabytes (and has to be, don't bother questioning this please - it is due to us doing ultra granular reporting, in Polaris, no combo-list is not on the table). We need to create a second line that is IDENTICAL…
-
Fake Version vs Anaplan Version - What to use
-
Tips for Solution Architect Exam
-
Need documentation on Model Optimization techniques
-
Adding new list failure
Hi guys, I have a system generated numbered list concatenated with an attribute. It is marked as a PROD list. I created a form in the NUX to enable the user to add into the list but I keep getting failure What could be the issue and is there a workaround to resolve this issue? Thanks in advance
-
App Dashboard Exports
Hi Anaplan Community, I am wondering if there is a way to do a mass export of multiple exports and combine them all into one excel file with multiple sheets. It would be one sheet for each export, but they would all be in the same excel file. I am hoping I could publish this process button to my app dashboards. Thank you!…
-
First Non Blank within Hierarchy
Hi, how do I get the first non blank, or min, or max on the date here within the hierarchy. The first 3 lines should all have the same date 9/25