What is MicroStrategy?
MicroStrategy is a business intelligence tool which allows you to view and analyze volumes of complex data from multiple perspectives. It is the university's solution for reporting and analysis tools that have become obsolete or will be soon, such as EPM 11 and "Web Reports".
The Controller's Office has implemented MicroStrategy for finance reporting and analysis. The finance data model went live for ad hoc reporting in the fall of 2015. To date, over 150 individuals have been trained to create and share reports and perform online analytical manipulations.
View the MicroStrategy Finance Overview (with audio).
The legacy Web Reports available on the Controller's web page will remain active until all of the reports have been converted to MicroStrategy. The reports are currently in development and will become available in MicroStrategy as they are approved for production.
The new Finance Reporting Menu is being introduced university wide in January 2017. Several auditorium style trainings are being offered to demonstrate how to run the new reports. View the MicroStrategy Finance Web Reporting training presentation.
Standard reports now available in MicroStrategy (Click here for more information on each report):
- Fund by Account (Year-to-date, Inception-to-date)
- Snapshot by Organization (Year-to-date, including Local Fund Cash Balance)
- Transaction Detail (Month-to-date, Year-to-date, Inception-to-date, and Custom period)
- Encumbrance Summary (Month-to-date, Year-to-date)
- Encumbrance Aging (By Organization, by Fund)
- HokieMart Encumbrances Detail (Month-to-date, Year-to-date, Inception-to-date)
- Local Cash Balance (Year-to-date)
- General Ledger Reports (Month-to-date, Year-to-date)
- PO Invoice Exception
- Posted Transactions by Document ID
Other Financial Reports
- Account by Fund (Year-to-date)
- Activity Class by Activity Code (Year-to-date)
- Activity Code Summary Reports (By Organiztion, by Fund, Month-to-date, Year-to-date)
- Activity Code Transaction Detail (Month-to-date, Year-to-date)
- Operating Statement by Account (By Account, By Account Attribute)
- YTD Operating Statement by Org (Summary, Details)
- YTD Operating Statement by Fund (Summary, Details)
- YTD Operating Statement by Org (Summary, Details)
- Snapshot by Fund (Year-to-date)
Other Grant Reports
- Department Overhead Earnings (Month-to-date, Quarter-to-date, Year-to-date)
- Monthly & Special Allocations
- Senior Management & Program Report
- Department Projections Reports (Summary, Details)
- OSP Fund Listing by Fund End Date (30 days, 60 days, 90 days, 120 days, all days)
- Snapshot by Grant
- Activity Code Listing by Organization
- Approver Listing by Organization
- Department Head Listing
- Fund Code Listing
MicroStrategy pulls data directly from the Banner finance data warehouse. The reports you run in MicroStrategy will reflect Banner transactions as of the prior day. The data you can view is based on your org/fund access in Banner. The options and functionality you can perform in MicroStrategy are determined by your assigned user role.
Finance Reporting Consumer:
- Runs standard web reports using the Finance Reporting Menu
- Can export documents to PDF and run the underlying report (data set) and export to Excel
- Can save copies of standard reports to a personal folder
- Can subscribe to documents to run automatically
Finance Reporting Analyst:
- All the same permissions as the Finance Reporting Consumer
- In addition:
- Can create ad hoc reports and other MicroStrategy objects such as documents, dashboards, filters, prompts, and metrics
- Can share ad hoc reports with other Analysts and can run objects that other Analysts have created and shared
Finance Reporting Steward:
- Manages user roles and data access
- Creates standard documents and reports for the Finance Reporting Menu
How to get access depends on the role you will have in MicroStrategy as described above.
Access for Finance Reporting Consumers will be automatically granted to all VT employees who are assigned Banner Finance access. Individuals who are defined as financial manager on FTMFUND or as principal investigator on FRAGRNT will also be automatically granted consumer access to their respective fund and grant. Note: the Finance Reporting Consumer role will be enabled at a future date.
Individuals who wish to be upgraded to the Finance Reporting Analyst role should complete the authorization form on the Controller's Office main web page. Analyst access is automatically granted to individuals who register for the Reporting Basics class outlined below.
The Finance Reporting Steward role is only granted to authorized Controller's Office employees and technical support staffs.
Training for Finance Reporting Consumers is avaliable as follows:
- The new Finance Reporting Menu is being introduced university wide in January 2017. Several auditorium style trainings are being offered to demonstrate how to run the new reports.
- View the MicroStrategy Finance Web Reporting training presentation.
Training for Finance Reporting Analysts is available as follows:
- MicroStrategy for Finance Analysts - Reporting Basics
- This training is intended for department finance analysts and business managers who perform data mining and analysis with finance data in the Banner data warehouse.
- In this class you will learn what MicroStrategy is, how to navigate the web interface and run shared reports, create reports using the Finance data warehouse, and intuitively interact with your results using standard OLAP features like pivoting and paging.
- Classroom training will be scheduled based on demand. Learning can be accomplished independently using the classroom training presentation and exercises. If you would like to request instructor led training, please contact Clara Sowers.
- MicroStrategy for Finance Analysts - Beyond the Basics
- Learners for this course should already be comfortable with MicroStrategy reporting terminology, navigating in MicroStrategy Web, running, modifying and saving existing reports and creating reports from scratch using the Report Editor.
- The course is dividied into two parts:
- Part I - includes instructions and exercises on how to filter data, define attribute elements, and create metrics on the fly; how to create your own metrics, filters, and prompts for use in multiple reports; how to format data based on different conditions; and how to run, edit and format predefined MicroStrategy reports in Excel.
- Part II - includes instructions and exercises on how to import data from external sources, create dashboards to view data using a variety of visualizations, create high quality, print ready documents that can display data from multiple reports at the same time, along with images, text, hyperlinks, headers, footers, etc., and to automatically execute reports and documents at scheduled times.
- Learning can be accomplished independently using these course materials and supplemental exercises: