Frank

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]

We want to allow Stratum users set to Advanced and View Admins to be able to maintain user lists. Can this be done?

When exporting to excel from a Stratum view it seems that sometimes there are merged columns for some of the data. This makes it difficult to use the data in those columns. How can I get rid of this?

Make it easy to get to Stratum and a particular view quickly. At our online Insight class today I mentioned I’d show how to add a Stratum as a bookmark or favorite in your browser. My intention is not show how to create the a bookmark, that’s a chrome or IE thing that is easy to do. What I did want to document is how you can have a bookmark…[Read more]

How can I see more detail about a YTD number? In essence we want to drill into a YTD sales measure and see sales for the months. You can do this in Stratum using the hyperlinking capability provided as a Measure property.

As an example we’ll use a simple view showing sales this year vs. last year for a rolling 3 months, current month and year…[Read more]

Changing the Excel font and size for exports can be done in the Admin Utilities in the Application function. There is a section called Excel Files – you can select a font and size for excel exports here. The common request has been to use a smaller point size to allow for more data on the Excel sheet.