Frank

Frank started the topic Can I easily see last months data when using time as a dimension? in the forum Stratum User Stuff 3 days, 16 hours ago

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]

Frank started the topic How can I hide or remove unused and obsolete dimensions? in the forum Stratum Admin and Tech Stuff 2 weeks ago

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]

Frank started the topic How can I see % of total in the forum Stratum User Stuff 2 months, 3 weeks ago

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]

Frank replied to the topic This year vs. last – in a View by month in the forum Stratum User Stuff 4 months ago

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]

Frank started the topic The fastest way to export to Excel? in the forum Stratum User Stuff 4 months, 1 week ago

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]

Frank replied to the topic Working days and remaining days in the forum Stratum Admin and Tech Stuff 5 months, 1 week ago

Excellent! Apparently my response was slightly clearer than mud.

Frank replied to the topic Working days and remaining days in the forum Stratum Admin and Tech Stuff 5 months, 1 week ago

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.

You’ll need…[Read more]

Frank replied to the topic false cube being processed message in browser in the forum Stratum Admin and Tech Stuff 5 months, 3 weeks ago

Bryan – these types of questions are best handled via our Support Team. We’ll probably need more info than what you’ve posted and Support can help out with what you need.

Frank replied to the topic test in the forum Stratum Admin and Tech Stuff 5 months, 4 weeks ago

Your test was successful! Welcome.

Frank replied to the topic How can I provide access for users to create User Lists in the forum Stratum Admin and Tech Stuff 6 months ago

This question came up during a user review session recently. There are two solutions to this. The simplest is to include the Admin View Group in a users User Profile Group. Depending on the level of the user different options will appear in the Admin View Group. These are automatically set by Stratum and provide access to different functions…[Read more]

Frank started the topic How can I provide access for users to create User Lists in the forum Stratum Admin and Tech Stuff 6 months ago

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

Frank replied to the topic Merged Columns in Excel – How can I get rid of them? in the forum Stratum User Stuff 6 months ago

This question came up in our open question Insight session a couple of weeks ago. The solution is to remove any conditional formatting you have in the view. When a measure has conditional formatting on it Stratum creates a set of merged excel columns so that the formatting can be included. If you remove the conditional format this will not…[Read more]

Frank started the topic Merged Columns in Excel – How can I get rid of them? in the forum Stratum User Stuff 6 months ago

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?

Frank started the topic Adding Stratum to your bookmarks/favorites in the forum Stratum Admin and Tech Stuff 7 months, 3 weeks ago

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]

Frank started the topic Can I drill on a YTD measure to see more detail? in the forum Stratum User Stuff 9 months, 2 weeks ago

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]

Frank started the topic Changing the Excel output Font and size? in the forum Stratum Admin and Tech Stuff 10 months, 3 weeks ago

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.

Frank replied to the topic Can I show different types of values depending on the Month? in the forum Stratum User Stuff 10 months, 3 weeks ago

Here is a screen shot of the a view using the techniques described in the last post – the highlited line is the Outlook created using the calcs described.

Outlook for the current year:

Frank started the topic Can I show different types of values depending on the Month? in the forum Stratum User Stuff 10 months, 3 weeks ago

I’d like to see sales for the closed months and the forecast for the remainder of the months, giving me an Outlook for the year.

This can be accomplished in Stratum using a Calculated measure that looks at the month name and determines if it is a past month, the current month or a future month.

Step one is to have a hidden measure that…[Read more]

Frank started the topic Can I use Stratum data in Excel? Yes! – Insight Examples included in the forum Stratum User Stuff 1 year ago

Yes! We just finished up an Insight class on this topic. You can register for these classes right off the homepage of Stratum or by gong to Silvon.com and checking out the Resources section. Also most of the Insight classes presented in the last year or so are available in the Archives section.

I mentioned I’d include some of the excel formula…[Read more]

Frank replied to the topic Tracking User Activity in the forum Stratum Admin and Tech Stuff 1 year, 2 months ago

I’ll check and pm you with the costs.