-
How to reduce huge dimensions
Hello, I'm having a lot of issues with workspace size, with models going above 150/200gb in size and I'm not sure how to reduce it, to give some context, I have three main lists (size considering subtotals): Products (~1,5k) Countries (>100) Customers (>270) The issue is that if we apply all of them to a module what we get…
-
Public holidays building modules
I want to be able to display a table of public holidays by country on a dashboard. My problem is that in some countries, public holidays can change from year to year (unlike New Year's Day, which is always 01/01). The steps I've already taken: I've created a SYS10 public holidays module where I display the date and a…
-
Prorata Calculation Using Dates
Almost done with my module. I need help in developing a formula to compute the monthly amortization that looks at dates.
-
How to select only one Boolean line item at a time by disabling all other Boolean options?
I want the user to select only one boolean line item at a time. When the user selects one boolean, other booleans should not be selected, and once the user unchecks the selected boolean, all booleans should be available for selection.
-
How to get display name of list member in users tab for selective access
Hi, I have exported users access list ,getting only numbers/codes in the selected list write access(Which is a number list) But I want to see display name of that list member . Please suggest me if there is any way to sort it out.
-
Import Error
Hi All, I have a module dimension by Cost Center & Version, whenever I run an import I get this error below. What could be the reason and is there a workaround to solve this. Thanks.
-
Set up current period
My final goal is to be able to update the "Current period" from the Dashboard. I created a SYS Current Period module (with a single line item: Format: Period Month) and added an action that I put into a process. When I run the process (or Action) I have an error : - Line Item Errors: • SYS Current.Current period Internal…
-
Getting the end date...
Creating a model for asset life, figuring out the end date of an asset by using below infos Start date: 10/19/2019 Asset Life: 4.7 years which is 56.40 months
-
How to calculate active days in a month???
-
Adding specific number to imported data
What's the best possible way of adding '0's to imported data? Eg: Data > Required Data 156 > 00156 23 > 00023 62797 > 62797 0 > 00000
-
Function MONTH returning 11 for the period dec
Good morning, The function MONTH is returning in our model the number 11 for the month of December, the number 12 for the month of January and number 1 for February. Anyone know why is this happening? and why december is not the 12 month and januray the 1 month? Find screenshoots attached: We have a calendar type 4-4-5 as…
-
Comparison Report - Flags Changes but cannot Identify What
Hi, I've made some changes to a model, and run a comparison report. The report flags I've changed some Dashboards. Not to my knowledge! Digging through them carefully they look the same, with the same content as before. Also the Comparison Report says I've made changes to a list of Saved View - again not to my knowledge,…
-
Lookup from Different Dimension
I have Source Module like below. It has SKU as dimension and line item "Exhibition Year Season" and "Exhibition Year". Both line item are using list formatted data type. I want to lookup Exhibition Year in Target Module based on Exhibition Year Season in Source Module. So the result of target module will become like this:…
-
How to set automatic refresh when filter is updated to new value
Hi All, As I was building the UX Pages and came across on roadblock wherein each time when I change country and segment in field card I had to refresh the page again to get new country and segment values. Please requesting for inputs on how to set automatic refresh when I change the filter to new country and segment Below…
-
Drive dimension selectors from undimensioned module
Hi, Is there a way to drive dimension selectors from a module that has no dimensionality? I have 2 modules: Select Dimensions no dimensionality, just line items that are formatted by dimensions entity and department, etc Income Statement dimensioned by entity and department. End-users would like to make entity and dept…
-
Populate Module with Data from a module with different dimensions
Hi, I'm trying to add data that has been calculated in Module A to module B. Module A: List 1 Time Line items, where one of them is: Account XPTO1 (data's format is number), Account XPTO2 and Account XPTO3 Module B: List 1 Time List 2 (where we have accounts) Line items, where one of them is: Final Value (data's format is…
-
Error Line item for Assignees in Group Task for Workflow
Hi All, I've been working in Anaplan Workflow, when it comes to group task I am facing with a challenge. I chose a line-item driven assignee method in the Group Task, but I was not able to assign the particular line item for assignees. The error showing in the line item for assignees: "There are no valid line items.…
-
Ability for business user to override a calculated line item
I am having a requirement, where we are having a line item being displayed on dashboard, and it is being autofilled using a formula which is pulling data from another list. Business wants to have the ability where they can edit that value for a particular record. is this possible?
-
Bulk Copy Years
Hello everyone, I would like to move all the data in my model by a few years (Write all data from 2020 to 2023, 2021 to 2024…). For that I tried using Bulk Copy, but I can only copy individual months there, not entire years (if I select this accordingly, the button is greyed out). This is therefore a problem, as some…
-
Show the last date and time a process was run on a dashboard
We have a process to import live orders, and it takes a little time to import the data, it is used up to 7 staff members, and as they are working from home a great deal they sometimes all run the process one after each other, which can be draining on the system and my mood It can be run 40 times a day and only needs to be…