I am facing difficulty in setting up time (months ) dimensioni.e to include only months in time dimension in REP02 size margin report .can anybody who has done this help me out on this
@Vam1992
If you want to exclude the totals across time such as FY you will need to use a time filter.
Set up a module containing only a time dimension.
Add a line item dimensioned by boolean and type TRUE as a formula.
Ensure that the summary option is set to none.
Notice how only the time periods are selected.
Now use this to filter your view to only show time periods.
Good luck,
Chris
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.…
