Could you please share any custom day level time scale hierarchy Fortnightly time scale For January (Jan 1 to Jan 15, Jan 16 to Jan 31 ). For Feburary (Feb 1 to Feb 15, Feb 16 to Feb 28 )
@Misbah, @Manjunath
Hey @HarishBabu ,
Could you please clarify what you are after?
Cheers!
I am trying to show the summary level Bi-Monthly instead of Month.
Instead of summing of days values in Month. I am trying to show 1 to 15 days in cycle 1 and 16 to end of month in cycle 2
Could you share best practices for that?
Hello @HarishBabu ,
It looks like you need to dimension your model as week and then create a set of fake time lists:
You could define how to split the months, it looks like you want to look at the number of days in every month and create the fake month breakdown on each of the halves. Then you will need to reconcile everything from day into months using timesum if I recall correctly.
Lastly, you could create actions with saved views so the list would populate automatically based on the items that you have within your time scope.
Hope that was clear.
Could you share anything related to custom time scale day level?
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
Hi, for some reason my shipping costs are the same over every month and I don't know what to do to fix it.
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
