During this session, we review some of the features of Viewer which make exporting to Excel™ a breeze. We also look at how you can extract Stratum data directly using Excel™ for use in pivot tables, reports, etc.
Using Parameter prompting with Viewer allows users an easy way to filter view results. It also helps to standardize views while providing flexibility of use. Tune into this class to learn more about the process of setting up prompts and the different types of inputs that are available for users.
Have you ever had trouble finding your favorite views or the views you just worked with yesterday? Or have you ever wondered on what date your Excel file was exported from of Stratum and what filters you applied to the data that’s in it? During this session, we discuss the new features available in Version 6.7 of Stratum to address these issues and more!
If you’d like to pinpoint selling opportunities within your customer base using Stratum but don’t know the best way to do it, this class provides some great ideas for you! During it, we discuss how you can use voids (or white spaces) in your Stratum data to identify sales opportunities with accounts that haven’t purchased from you recently but were expected to based on their past purchasing behavior. Thanks for tuning in to this INSIGHT session!
Listen in to this recording to learn more about Silvon’s newest Stratum addition, Viewer Express, which lets you serve up consistent views of targeted Stratum data to select groups of users so they don’t have to create or manipulate views or reports on their own. This can include key daily flash reports, views that show divisional executives how they’re doing compared to other divisions, and so much more. We take you through a test drive of the menu-driven interface that powers Viewer Express, how users can select what they want to see in their reports using drop-down filter lists, and how you can set up Viewer Express so that no sorting or filtering of the data is required by your users. In this case, all they’d have to do is view the data – it’s that easy!
During this class we show you how you can create and distribute “packets” of Stratum reports quickly and easily on an ad-hoc or scheduled basis. This session provides case examples using the Stratum Broadcast Server – one of Silvon’s newest applications for delivering Stratum data to others both inside and external to the business.
During this session, we discuss all of the key new features of Version 6.4 of Viewer. We show you how you can now filter and sort on Totals with this latest Viewer release, apply top / bottom filters to the most detailed level drilled to in a View, easily control how Totals are calculated, share Views with other users, assign common home pages to groups of users and more. We also show you Viewer's newly refreshed look-and-feel and easily customizable home page with on-demand access to how-to videos and other user training.
Tune into this recording on how to use time hierarchies when building your views. Our primary focus is on the use of “time hierarchies” vs. “time ranges” – although both are available to Viewer users and appropriate for different types of views. We cover both basic and more advanced (and unique) applications of time as a hierarchy, including its use in calculations and filters!
This course covers all of the filtering options available to you in Stratum.Viewer. Learn how to manage filter lists and where to apply filters in a view definition. See how to create view prompts that are used to filter results. We also show you how MDX statements can be used to get what you need out of dynamic user lists.
During this class you’ll learn how you can take Stratum.Viewer graphing to the next level! This session features live demonstrations of discussed techniques vs. the use of static Powerpoint slides. If you’re already familiar with basic graph creation, editing and formatting, you won’t want to miss this class to see how you can enhance what you’re already doing with Viewer to create graphs for visualizing your Stratum data.
During this session, we discuss all of the key new features of Versions 6.4 and 6.5 of Viewer. We demonstrate how to use the new Filter button to streamline the filtering process and some of the shortcuts we’ve added to make filtering faster and more intuitive. Additionally, we show you some of the new View management features that make finding and managing Views faster and easier. We talk about new ways to control the “All Others” rows and columns to improve performance. We show you how you can now filter and sort on Totals with this latest Viewer release, apply top / bottom filters to the most detailed level drilled to in a View, easily control how Totals are calculated, share Views with other users, assign common home pages to groups of users and more. Plus, we discuss Viewer’s customizable home page with on-demand access to how-to videos and other user training.
During this session, we show you how you can enhance the value of your Stratum implementation by leveraging Microsoft Reporting Services with Viewer. We explore various tips and techniques for creating reports that highlight Stratum data. Plus, we show you how you can build reports that link to data outside of Stratum!
During this session, we discuss all of the key new features of Versions 6.4 and 6.5 of Viewer. We demonstrate how to use the new Filter button to streamline the filtering process and some of the shortcuts we’ve added to make filtering faster and more intuitive. Additionally, we show you some of the new View management features that make finding and managing Views faster and easier. We discuss new ways to control the “All Others” rows and columns to improve performance. We also show you how you can now filter and sort on Totals with this latest Viewer release, apply top / bottom filters to the most detailed level drilled to in a View, easily control how Totals are calculated, share Views with other users, assign common home pages to groups of users and more. Plus, we discuss Viewer’s customizable home page with on-demand access to how-to videos and other user training.
During the session, we discuss the differences between Action Scheduling in Viewer and Silvon’s new Broadcast Server. Plus, we show you step-by-step how to schedule actions with the Broadcast Server and easily distribute action-related information to others via email.
Over the years, Silvon’s consultants and many of our customers have uncovered a number of unique ways to do things with Stratum. During this class, we share some of these ideas and discuss several product functions that are very beneficial, but that you may not be leveraging today!
Over the years, Silvon’s consultants and many of our customers have uncovered a number of unique ways to do things with Stratum. During this class, we share many of these ideas with you and also discuss a number of product functions that are very beneficial, but that you may not be leveraging today! For example, we show you how you can allow users to see data even if it’s not stored by some of the dimensions in the View (i.e. like viewing inventory when filtered by Customer, even though Inventory is not stored by customer). We also demonstrate how you can link a Stratum View to another View application, the why’s and how’s of linking Stratum to external websites, and so much more!
Allow your SalesForce (or other CRM) users to quickly get to Stratum with a few simple additions to your SalesForce screens! By allowing access from SalesForce to Stratum the need to import all of your sales and order information up to SalesForce can be eliminated. Let SalesForce be your CRM solution and let Stratum be your BI solution and minimize the need to replicate information between the two. The concepts and techniques for allowing access from SalesForce to Stratum can be used by many applications, not just CRM applications.
During this webinar, we discuss and demonstrate our newest solution that enables users to schedule and send existing Stratum views of information to other users without having to rely on their IT staffs to do so for them.
Operational dashboards assist management in directing and managing growth and performance by providing a snapshot of present conditions, highlighting performance against plan, and ensuring early warnings for potential issues. In this session, we show you how you can take advantage of Stratum and Microsoft Sharepoint to create easy (yet powerful) dashboards and performance portals. Our examples will include executive-level displays of various Stratum views complete with graphical indicators, real-time alerts, and drill-down functions for root-cause analysis. Plus, we’ll show you some examples of dashboards consisting of unrelated Web parts (e.g., a collection of Stratum views, favorite Web sites and often-used applications arranged into a personal dashboard for easy access).
Viewer uses MDX (Multi-Dimensional Expressions) to create calculations. If you need to define view definitions with calculated columns, this course will show you how to create various types of common calculations like column difference, percentage calculations and conditional statements, among others. Learn more about how to manipulate time, hierarchies and members in calculations to display the data the way you want it. More advanced functions will be explored to help you take your calculations to the next level. This is a brand new INSIGHT session that’s focused in most part on Advanced Calculations and intended for more experienced administrators of Stratum!
If you’re tasked with building Stratum Views, this session is packed with practical tips and best-practice techniques for you! We’ll discuss considerations that you should make when creating views in Stratum Viewer, methods for generating views that will “wow” your users, tips for working with parameter groups and view prompting, effective ways for leveraging the View Toolbar, methods for setting up drill-to Views, and more! Plus, we’ll review and demonstrate for you how much easier (and faster!) it is to deal with TIME when building your views and when it makes sense to use the traditional OLAP time of pre-6.0 releases vs. the “ranges of time” that are now available to you in Stratum V6.0 and beyond.
During this class, we’ll provide a quick overview of the Action Scheduling functionality of Viewer and how you can use it to distribute view results via email and file share. Then, we’ll get into the more technical details of setup and the User IDs required.
During this INSIGHT session, we’ll discuss the web-based collaborative planning functionality that’s now available using the Stratum Viewer user interface. You’ll get a sneak peek at how to set up a Planning view in Viewer and what’s required to do so. We’ll take you through a few scenarios of entering and changing Plans. Plus, we’ll explain how the Stratum update process handles Plans that have been created in the Stratum web-based Viewer.
We cover all of the filtering options available to you in Stratum.Viewer. Learn how to manage filter lists and where to apply filters in a view definition. See how to create view prompts that are used to filter results. We’ll also show you how MDX statements can be used to get what you need out of dynamic user lists.
Would you like to have Stratum.Planner views automatically emailed to your users as reports? Join us during this session and learn how you can make it happen! This class will show you how you can use Export Groups, Export Data Definitions and the Automated Export Groups (AEG) functionality of Planner to filter a single master view into several user-specific views, save those new views as Excel or PDF files, and then automatically distribute them to your users via email or file share. It’s such a simple way to get Planner information quickly into the hands of those people who need it. If you haven’t done it before, you certainly shouldn’t miss this class!
This class reviews the various features available to maintain historical data contained in your Stratum database. Change Sets and Relationship Change functionality allow you to realign data as your business changes. Automating this process is also discussed.
During this class, we provide some tips and techniques for managing categories in Stratum. This includes ways to create and assign categories to structure code tables. We show you how to create calculated values and calculated categories. Plus, we review ways to assign View Groups to Categories / Structure Codes and give you some tips for adding or changing dimensions. This is the perfect class for new Administrators or for anyone who could use a little "refresher" on managing categories of data within Stratum.
Prepare yourself for the administrative task of getting your Stratum environment ready for next year! This course reviews the steps needed to prepared Stratum.Server / Planner and Stratum.Viewer for the Year 2016 and beyond … and offers suggestions for getting your year-end tasks completed as effectively as possible.
Reduce those frantic calls to Silvon’s Support team and get more comfortable in troubleshooting and resolving Stratum.Server load process issues and Viewer cube building issues! In this class we will cover cube backup and recovery, as well as a troubleshooting approach in reviewing the processes involved in moving data from your source into Stratum and from Stratum into Viewer and key logs that can help.
During this session, we’ll provide an overview of the capabilities of SSIS (SQL Server Integration Services) - the powerful SQL Server replacement for DTS that’s used by Stratum for data import. We’ll review the basic process flow and components of the utility. Plus, a demo of the DTS packages currently available for Stratum will be provided.
Attend this class to learn how Stratum.InfoCenter can provide administrators with greater visibility into the usage of Stratum by end-users … giving you the data you need to make more informed decisions related to maintenance, tuning and business process compliance decisions.
This session focuses on adding Inventory data to Stratum and the benefits it offers by enabling you to create new avenues of analytics far beyond sales analysis. We show you ways to analyze inventory that’s integrated to your sales data to see key inventory-to-sales ratios and indicators. We demonstrate how you can find out (in a much more timely fashion) if you’re holding too much or too little inventory so you can avoid stock outs and lost sales. You’ll see how actions can be made to alert analysts to potential stock outs or big orders. Plus, we show you creative ways to analyze inventory data even when filtering on a customer dimension.