Frank

Stratum provides predefined calcs that can help out if you want to use either the total for a measure or the subtotal amount. To use the total there is a specific calc function you can use in the Stratum Viewer Functions. For the subtotal you can back into the subtotal amount from the Stratum provided % of Subtotal function. I’ve included a…[Read more]

Do invalid users and users that are marked disabled cause an impact on performance?

Not anymore! Previous versions (prior to 7.1 I think) users that were marked disabled were still processed in the post process authority (role) processing. If a user was no longer a valid user, say they had left the company and their user id was no longer valid,…[Read more]

Most importantly I hope this finds everyone doing well. You may have some time on your hands right now and it’s a perfect time to learn more about Stratum. There are some great resources you can take advantage of that are easily available. So break out the popcorn and tune in for some edge of your seat Stratum video learning!

You can find the…[Read more]

Here’s an example of a view that shows inventory that is ‘dead’ or not moving based on 2 different business rules.

A couple of things:
1. The view only shows me my dead stock which we’ve defined as – Anything that has averaged less than 100 units moved in the last 13 weeks, or anything that has 0 movement in the last 4 weeks. Of course you…[Read more]

Just want to add a simple calc – the difference between a couple of columns.
This is easy to do in Stratum via the Add Calculated Measure window.

1st just a little terminology – in Stratum the numbers that you report – things like Sales Amount, Units, Inv. Qty, Budget Amount, PO Qty etc are called Measures. When you want to add a calculation…[Read more]

Using the new view search feature (V7.1) or in View maintenance in the Admin group at the top right of the display is the search field – to the left of that is a drop down with Active, Inactive and All. What is Inactive vs. Active?

Got this from a customer after a Stratum Product Briefing (if you’ve not had one yet contact us and we’ll give you…[Read more]

Can I change the tab name in the browser for Stratum? – Simple answer is Yes! This question comes up from time to time. A couple of scenarios usually bring it up.
1. – You don’t call Stratum – Stratum – you call it Silvon or something else
2. – You’be got multiple instances of Stratum – Production, Dev etc.

You can control what the browser…[Read more]

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]

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]

We have a couple of dimensions that we no longer use and have become obsolete, is there a way to hide or remove them?

This question has come a recently for a variety of reasons and there is new functionality to handle it. There are a number of scenario where it might be useful to hide a dimension or a measure.

A few of the scenarios we’ve heard…[Read more]

Calculating the % of total or the % of subtotal is simple in Stratum. We got this question during phone call with some new users and I thought I’d post a response here.

In the Stratum Add Calculated Measure window (you can get to this a number of different ways – via the new in 6.9 measure control window, by right clicking in the Stratum grid…[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]