-
No of sums in a single line item
Hi, Need to know that how many number of sums we can use in a single line item so that its performance will also won't downgraded. Thanks, Vicky
-
How do I see true boolean across multiple users?
Module #1 dimensioned by 1) User and 2)Category I thought this would be simple lol but I have an Anaplan module dimensioned by users and category. Under my user i have a Boolean line item called sent for approval as true for one of the categories called refrigeration. Another user has the category "Cooking" as true. I want…
-
Top Level Item Filter to Show Subtotal
Hi All, I have a module with a composite hierarchy below. I would like to filter with a boolean line item for all countries in the Americas and get their total 50 show in the ALL Regions (Top Level Item). Also when the filter is applied I want the ALL Regions (Top Level Item) to show in the list items. How can I achieve…
-
Problems with OAuth Token Configuration
Hi all, it has been a while since my team and I have been trying to perform the Anaplan Connect Token configuration correctly. This one time, it seemed to be working for the first run, until I found out that the batch file runs correctly a second time only if remove the JKS file naturally generated in the user's folder…
-
How to Check the boolean items Based on Formula
In the source i have combo aganist the one combo item. we Have given a cycle drop down. Which consists of 8 item. If they select Cycle 1 then then Target module should be True for cycle 1 . If Cycle then Upto cycle 2 if 3 upto3. If 8 upto 8 cycles should be true . how can i achieve this in similary set up or in different…
-
What is most computational demanding on the system, if statement or max formula
Hi, I have a question, I have encountered in some of our models, where we want to limit a value to be 0 if it is negative. The way we have done this so far is by making an if statement so: if A > 0 then A else 0. Since Anaplan has Max, I thought this could be used, at least to make it easier to follow. The big question is…
-
How do you import line items from one specific list in a module?
Hi, I want to import data from a module contained in another work space. This source module only has one list with no top level. Specifically, I am trying to import the line items from one list item "Cost". On my attempt, I tried the following steps: Pivoted the list item needed as a page, and the line items in rows…
-
Updating time dimension to the correct dynamic formula
For this individual above, he started on December 2024 (H1 FY24) but the way I have the time settings set up it is 1 year before and 2 years after the current year and it is making this person start their proration at the beginning of the model calendar as opposed to their actual start date. I am trying to use these…
-
Workaround for Parent Child Relationship for Boolean Lookup
Hello, I am trying to do a workaround where I am not able to directly map a Parent and Child relationship but the users would want to be able to alert owners of a subsidiary account living in a different territory that they want that subsidiary to follow their HQ account. A specific example would be: Account 1 HQ has 4…
-
Can we sort data in Anaplan with time?
Hi all, I want to sort data in Dashboards using time, showing the current year 1st and then followed by previous years, is that possible? Thanks in advance.
-
Сorrespondence of a number to a numerical interval from the List
How can I match a numeric interval from the List to a number in Anaplan? For example: Interval list: 1 - [name: "<=80"] (min = 0, max = 80) 2 - [name: "80-90"] (min = 80, max = 90) 3 - [name: ">90"] (min = 90, max = 1000) Number = 83,257 - it should correspond to the interval No. 2 "80-90"
-
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…