I’m using a YTD date range of January (or the start of your Fiscal year..) to Previous Month so we see only the closed months of data as we move thru the year. What happens in the first month of the year? ‘January to Previous Month’ – this would be Jan This Year to Dec of Last year which shows up in Stratum as an invalid date range (as it…[Read more]
I think what you’re looking for can be found in the properties of the measure. If you look at the properties of the measure (right click on the measure header, last option is properties, or open the View Explorer and double click on the measure) the last property is ‘Total:’, change this from from Total (which preforms the calc for the measure)…[Read more]
What is the syntax to aggregate a sum of a measure over a dimension?
I’m trying to calculate YoY Price – Volume – Mix impact. Hierarchy is Customer, Part Number. The calculation works for every part number but the result at a Customer level is the sum of the results of each part number.
This is true – that Stratum will AND filters together by default when you specify them on the columns. But you can use filters on the Row or Columns – also called Axis Filters to OR multiple filters together. In addition with Row and Column axis filters you can use boolean logic, ‘and’ and ‘or’ multiple things together and filter on both…[Read more]
Trying to determine Dead Stock in our inventory – and we have a couple of criteria that we want to use. If I apply filters on the columns themselves Stratum ‘AND’s them together, but we want to use an OR. If this is true OR this other thing is true then this is dead stock.
This is a question that we have heard from a number of customers. The idea being that you want all your Stratum users to see a specific message today, or for a couple of days. It might be to let them know that you’ve upgraded Stratum or you’ve added new information, or maybe fixed some problem data. You might also want to display a message to…[Read more]
How can I easily see last months value for something like Sales so I can do a month to month comparison when I’m using time as a dimension (where you have Months or Weeks or even Days going across the top of the display)?
It’s easy to do this in Stratum, and there are at least 2 answers to the question:
1. – Use Time Ranges, yeah yeah I know the…[Read more]
An easy way to show only YTD months or weeks when displaying information with the months or weeks going across the top or down the side.
I wanted to add an update to this post. When I initially suggested that you can use an expression to filter the months to only see those months that have passed and the current month, so that the future months…[Read more]
What is the fastest way to export from Stratum to Excel?
Soooo….my first response is always, do you really need to export? Are you just looking for a calc that you are more comfortable with in excel vs. Stratum. If so, it might save you time overall to do the calc once in Stratum then you can use all the flexibility of Stratum to see what you…[Read more]
I’m assuming you have populated the category and are able to see the working days by at least one level – probably by company. If this is not the case the rest of this post won’t help…. The problem comes when you want to look at the working days by another dim, as you mentioned – customer, rep or region, or some combo of those.
Frank, hoping you can provide some insight on how to accomplish this with the system control category. We have requirements to look at the number of working days and so far by customer, rep, region or a combination of them. I am not seeing how you can use the system control value category to correctly total the working days based on the…[Read more]