Frank

There are at least 3 different ways I can think of that can help you fit more stuff across the view grid in Stratum. There could be more – but this is what quickly comes to mind.

1. Use the Display Options and go to the Grid Format tab (available in version 7.2 and later – if you don’t have this option contact Silvon or your Admin to get an…[Read more]

Roles in Stratum allow you to define what information a user has access to. This can be for dimensions (things like divisions, business units, regions etc.) and measures (things like costs, GL amounts, margins etc.). A user can be assigned a role in two ways – directly in the User Profile admin function or via a User Profile Group, in which a…[Read more]

Of course! This is pretty easy to do since the updated dashboarding features were added to Stratum in (I think) version 7.1.

So the basic idea is that you know the Stratum Views you want show when you start Stratum. You can then use a Stratum Dashboard to arrange those Views to display however you’d like to see them. Once the Dashboard is…[Read more]

Stratum displays 40 rows and 10 columns of data when I run a view, but I want more columns because my view has 12 months across the top.

This is something that can be changed at multiple levels in Stratum. The number of rows displayed often comes up in a couple of cases – one is that there are not enough rows displayed to fill the screen.…[Read more]

We have some suggestions! Any Stratum view can be uses as a data source in Power BI. But there are some general guidelines that make using a view more effective and faster in Power BI. I’ll list a couple and also supply a link to a getting started guide that goes thru a bunch of suggested items when using a Stratum View in Power BI.

My list…[Read more]

Yes you can! Stratum is very flexible in this regard. You can use both Captions and Column/Row properties to easily set up your time headers and labels.

Lets use the example below, which is a simple view showing sales by month for the current year. I’ll use the numbers in the picture to help reference what I’m talking about. You’ll need to…[Read more]

Yes they do! The latest version of Stratum (7.2) has updated the look and control of the format of Views. Silvon added a bunch of new controls on how a View looks. These are accessible at the View level and system wide in Admin.

From the What’s New doc “Stratum reports has been refreshed with a simplified design and color palette that puts the…[Read more]

Let me count the ways! In Stratum there are a number of ways to manage filters. Here I’ll list a couple that you can use that are just a couple of clicks. I’ll try to reference the screen shot included below in my comments. Filtering in Stratum is pretty easy and can be done by clicking on the funnel icon, where ever it is displayed. The big…[Read more]

Silvon will be offering a new connector for Excel that allows you to work in Excel and directly reference data from a Stratum View as a data source in Excel. For info on joining the session go here.

The session should be recorded as well if you want to watch it at a different time or pass a link to others. Once it the recording is available it…[Read more]

Stratum has a feature know as User Links that is available in Admin that allows for creating links to other apps. You could create a link to a news page for example or a link to a Stratum Dashboard, or even a Power BI dashboard. These links appear in the View Groups listed down the left side of Stratum.
You’ll need to have access to the Admin…[Read more]

No problem! If you are looking to do Rolling x (commonly 12) in a column but your time selections only go back to 6 months ago you can still easily set up for Rolling x. In this example we’ll use Rolling 12 months as our target.

In the example below we are comparing two columns one for this year and for last year – each represents a rolling 3…[Read more]

No problem! You can set up access to the Data Import (this function allows a user to import an xls into Stratum – you can see more info on it here.) via a simple User Link. You would add the User Link to a View Group the user already has access to. The Link to the Data Import function would look like https://yourstratum/DataImportListWindow.aspx…[Read more]

When the search window displays it defaults to customer number – instead of customer name which is what I normally want to search on. Is there a way to change this?

There is! In the Admin Utilities go to Dimension and click to open the window. For any dimension you can select what the default search option is set to. Stratum is installed…[Read more]

Early next year we’ll be releasing an updated look for Stratum.

I thought I’d post a quick preview of some of the look and feel changes we’ve made. There are many other new features to go along with some of the visual changes we’ve made. There’s more info coming out. Many of you may of seen some of this in a product update, if you’ve not had a…[Read more]

Adding a dashboard as a home page is now even easier in Stratum with the new Dashboarding features in 7.1. But users might not want the easily accessed Favorite and Recent window to pop up when Stratum starts since it can block the view of their dashboard.

Users can decide if they want the Favorite and Recent window to display at start up.…[Read more]

This is possible in the latest version. The business case for combining two dashboards into one that I’m aware of is:
DB1 is a dashboard that is company level and common to everyone.
DB2 is specific to the users area of responsibility – Sales, Supply Chain, Fin, Prod, etc. or unique to that user.

So…first you create the base DB’s (DB1 and DB2…[Read more]

When you filter a measure in Stratum there are 3 different types of Top counts – what are they and why have them?

Good questions we got from a customer. BTW if you didn’t get our survey on our education let us know at info@silvon.com and we’ll send a link so we can get your feedback. If you did get the survey and respond thanks! If you didn’t…[Read more]