This is another easy thing to do in Stratum. Using the same techniques as in the original post you’ll want to start with Year Weeks or Year Based Weeks Based. You must use a week dimension that includes a year because weeks start/end on different dates in each year.
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]
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]
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]
New way to easily exclude stuff in a view! Part of our upcoming 7.2 release will be a new exclude option for dimensions. You can quickly specify if a filter is to be an include (the default like it is now) or exclude (new option coming in 7.2) If you read the earlier posts in this thread you’ll find a couple of examples on excluding specific…[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]
Supply Chain Metrics – The Perfect Order.
Following up to prior posts I remembered we did a presentation at a the JDE Quest user group conference (remember those – you traveled somewhere and met in person with lots of different people….) where we discussed some detail behind the Perfect Order metric. We used a pyramid diagram to depict…[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 email@example.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]
What should I include on my dashboard – Supply Chain metrics
As I mentioned in my previous post here some ideas on supply chain metrics you may want to consider. This list is in no way exhaustive but it’s a good starting point as you think thru how to better digitally manage your supply chain.
These metrics and kpi’s are sometimes a bit tougher…[Read more]
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!