-
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…
-
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 :)
-
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…
-
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.
-
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
-
How to Apply Finditem for Lists loaded with Combination of properties
Hi All Say I have a list A (Numb List) loaded thru combination of properties having item count of 10. Then List B (Numb List) again loaded thru combination of properties having item count of 6 We cannot have code in both the lists. I want to find items in List A which are matched in List B items, so as to delete them. i.e…
-
Can I use the time stamp of the user from different Time Zones on the Admin dashobard ?
We have a requirement from the end user that they want to track the "start time" and "end time" based on the "Time Zone" they are working from. Can this be done ? If "yes" how can we approach this. Thanks in Advance.
-
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?
-
Copy data from one item to another item by cloning
HI
-
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.…
-
Erlang C- Application
Hi! I am leveraging Erlang C for a staffing model. As I use Erlang C the service level that Anaplan is calculating is producing inconsistent results. Has anyone had this similar problem?
-
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
-
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.
-
Can I add multiple lines of data to a MAILTO link?
I have several links to create an email for me based on highlighting a line of data and that pushes data from each of the fields into specific places in the body of my email. What about if I select multiple lines of data? Can I add all of those lines? Can I add a saved view of selected data to a MAILTO? Hope you can help…
-
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…
-
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…