-
Convert date to time format
I want to calculate the # of days in a month without using the PERIOD function. No time scale for this module. E.g. 10/15/2015
-
Alternative to SELECT:TIME.ALL PERIODS?
Hi, Is there an alternative to SELECT:Time.All Periods which will allow us to query whether a line containing time contains data not equal to zero across all time periods. The target line item does not contain time. I would usually just use SELECT but I would like to get the same outcome without having to use All Periods…
-
Why is there a round at the end of a number converted from text?
Hello, I am converting a text into a number to do a complex sort. It adds code from several different dimensions to create a large text. Then I convert it using value. When I do this, the final 3 digits are being rounded unnecessarily. Does anyone know how to get past this? Original text: 23921101010004270452 Converted to…
-
Refresh data hub to Spoke model
Hello, I have two lists on my Datahub. On the Spoke Model, I import these lists through a saved view, and on Apps I have a spoke model refresh page that should import me the changes made on the Datahub app. On the Data Hub App: I can add a line to the list and I can delete it. The problem is that when I refresh my spoke…
-
Complex GL Account Mapping to Cost Centre for Allocation
Hi Anaplaners, I want to mapp certain GLs to CCs and vice versa. Additionally I want to map certain cost centre to all GL Account and vice versa. Based on the mapping I would input an Allocation % for those mapped GL & CC. The mapping is done on the lowest levels of the hierarchy. It will also have the Parent of the GL…
-
How to manage Workflow-Approve/Reject
Hi, I am trying to create workflow for my project. My module has product(10 prod), customer(10 customers), channel, & version dimension Product, customer & version list has selective access enabled. I want to create workflow for single quarter, Step 1) Assigner workflow to planner , he will plan everything in top grid and…
-
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…