-
Line item Formula
Hello everyone, I require your assistance with a module I have created. Module 1: Forecast per month, taking inputs such as the forecasted quantity and the number of working days in a specific month. The result obtained is the CMJ (quantity consumed per day). I have also developed Module 2: Forecast per week . It takes the…
-
how to convert date to text
Hi there I was wondering how do you convert 2/3/2020 (which is a date format) to 2/3/2020 ( a text format)
-
error Invalid date or timescale identifier
Hi, I have this message "Invalid date or timescale identifier" when I try to import a data file. The date format in the file is : 30/06/2020 for example. Unsuccessfully, I tried to fix whith a "Custom fixed-position pattern" DD/MM/YYYY. Any idea? Thanks a lot :)
-
Where is the data coming from?
There is an error in the data in the spoke so I looked and the the spoke indicates that the mapping came from this module in the Data Hub. However, the data isn't flowing through in the Data Hub but is coming through in the Spoke. Is there anywhere else I can look? I've tried pivoting the view but no data pulls through at…
-
How to retrieve User Email ID from the system list "Users" in a module.
Show ID's of only those users who have either imported the data. Also if some one imports the data in future his/her ID should be shown there.
-
Remove Limit for List Reset Index
Hello Everyone, I saw a new update that user can reset the list index and allows users the discretion to reset their lists at any point on the basis the list is empty. But this "Reset" option is disabled for me. Can anyone suggest when is this "Reset" option is enabled? Many Thanks!
-
Time setting : Calendar
Hello everyone, I have developed a time setting module that utilizes the calendar month, quarter, and year . This module provides me with information about the number of days I work in a given month (picture attached). Now, I would like to determine the number of days I work in a week, taking into account that my week…
-
Import clearing out data even if list item is not mapped but time is mapped?
During a file import or module to module import, is it possible that even though the list item is unmapped or is not present in the file but since the time period matches, the other items are updated regardless of not being mapped?
-
How to calculate across Hierarchy
Hi, I'm having a hard time trying to resolve the following: I have a module "Planning Approvals" that is dimensioned by Brand Another Module "SKU planning" that is dimensioned by SKU. (SKU rolls up to Brand) Within SKU Planning module, I have a Boolean line item "Line Item 3" that compares if Line Item 1 = Line Item 2.…
-
Sum a line item based on all items in a list
Hello, I am attempting the following: I need to sum up a line item's values based on all of the list items used in the module. For example: the module I am building uses a list of adjustments as a dimension (ex: Adjustment % 1, Adjustment % 2, etc.), then there's a line item in the module for the percent amount for each…
-
Find earliest date and latest date in a non time dimensioned list
Hi, I've got a module, dimensioned by a list (numbers), and line item with the dates of various cashflows. This module is not dimensioned by time. How do I find the minimum value i.e. 23/04/08 and max value? Any help is appreciated, Thanks
-
remove double counting of projects
Anaplanners, I have a query on how i can remove double counting of Projects. Case artifacts: T1 Teams, which is a hierarchical list, so for example Team A.1 & Team A.2 rolls up to Team A, like wise Team B.1 rolls up to Team B; all rolling up to total teams. M1 Members: Flat member list. P1 Projects: a Numbered list of…
-
Check the booleand based on the list formated line item
Hey team, i emp dimesion and anothe same list formated line item another is boolean . if selcte the the emp 1 at list formated line itemn then i should check the box
-
Sprint 3 - 3.5.3 Activity: Create Distribution Center Summary Module
Hi, Can somebody please tell the formula for this line item in this activity? In the Supply Chain model, create a new module: * Module Name: INV03 Distribution Center Summary * Dimensions: P2 Products list, s G3 Location: Distribution Centers? list, Time (month) * Category: Inventory * Functional Area: Inventory * Summary…
-
Problem with Circular Reference
Hi I am building a module report and kept having a roadblock with circular referencing. Please what is a better workaround on this. I have tried to split the formulas into separate line items but kept getting circular reference. a. Referencing Modules b. Data source for Revenue The build is below:- 1. Here is the module 2.…
-
calculate time settings with out hard coding
HI All, I want achecive below attached scenario without hard code. in source if i enter y the result should be start week and end week start week can find out by current period () and how can i find out end week without adding +52 or 53 same applice to below scenario y-1
-
What is this error?
Import data into the P3 SKU list from a saved view: Use Build SKU saved view in SYS12 SKU Details module. Verify the source to target mapping before running the import. P3 SKU list is a member of the product hierarchy; assign the appropriate parent data.
-
Summary Method Problem
Hi all I'm having some weird numbers on month over month rate calculation that I did. I tried to use Formula for the summary method but it throws me this error below:- I'm not sure if the issue lies in the formula or the summary method. With calculations like this using PREVIOUS() what is the best summary method to use.
-
Use combined lists ou other parent child relation?
[Context Demand Planning for school books] I have 5 lists: SKU (Book) - e.g:5858595 Subject - e.g. Maths School Year - e.g 5º Grade Type of Subject (Mandatory/Not Mandatory) Theoretically, each subject has two parents: The type of subject and the school year. Since it is not possible I thought of 2 possible designs: A…
-
List Update Notification
Hi all, I was wondering if there is a way to notify the user each time a list is updated. In my case, there is a list named "cost elements" whose list items might change; the user checks the boolean of the list items belonging to the subset he is supposed to use. It would be nice to add an alert, maybe a KPI, every time…
-
DYNAMIC DISPLAY NAME FOR FORECAST MONTHS
Hi, I'm currently working on a project on which each entity needs to input their forecast for the current and the two following months each month. In the input module, in addition to time dimension and the list of the entities, i created a new list with three items : M M+1 M+2 to store the data each month. However on the…
-
Not able to run the 'Create' action
There are Create actions in my model, whenever I click on any of 'Create' action, this Run button gets disabled automatically for all Create actions, however I am able to run Import , Export actions of this model. I am Workspace Administrator and have full access to the model. Please suggest if I am missing some access…
-
Can we assign access to Actions in Production the same as we assign roles to production?
Hi, Not sure if this has been submitted before but I quickly searched and could not find any. Problem: Can we assign access to Actions in Production model? Sometimes, we need to create new actions and we need to assign access to those actions in development model, so when sync to production, the roles can access those…
-
How to add a button that creates a new line item in the GL that has a hierarchal structure
The current button we have in place has us add in a new SUB-GL/ vendor item to a numbered list. That numbered list uses an OpEx subset that layers in each new vendor into its respective opex area such as adding "Anaplan 2.1" under Software subscriptions in the GL. The problem im running into is that this current structure…
-
Summary method - Ration to Sum
Hello community, is there any possibility in anaplan to retrieve data from line item defined on ratio on summary method[As source] to line item with sum in summary method [target]? Any help or suggestion? Thank you
-
Full access role can't run an action
Hi, a user with the role Full Access needs to be able to run a process, when going to Users then within the Roles—>Action tab I can not see the Full Access Role to provide the access to all actions included in the process. The action brings data from our data hub into the model. Note: I should not provide Workspace…
-
How OFFSET operates? Please explain with examples.
-
ISFIRSTOCCURENCE() issue in model when more users are added.
Hi Everyone, I added 1 user into my system and as soon as I run one process, it is failing to say that "Too many cells for ISFIRSTOCCURENCE calculation: actual =50000094 maximum=50000000". But as I remove 1 user from the users tab the process starts running fine again. I am a little bit confused about why this kind of…
-
Circular Reference Issue
Hi Anaplan, Is there a workaround on circular reference issue?. I'm doing a calculation on the Profit Line Item which is: But am getting a circular reference when adding the VOD Cost line item in the formula. The VOD Cost line item references also the VOD Revenue line item, which I've screenshot below. Is there a…
-
Performance affect of "SELECT:" and "LOOKUP:" used together
Hi community! I couldn't find any information on whether it's recommended to split SELECT and LOOKUP for better performance. This thread helped me to understand that SELECT works in a similar way as LOOKUP (thanks to @DavidSmith for insight). So does it mean that SELECT and LOOKUP can be used together, unlike SELECT and…