Introduction to Business Warehouse Reporting<\/a><\/em> video series provides an overview of the BW reporting environment. <\/span><\/p>\nViewing the entire series (approximately 60 minutes in total) is a prerequisite to attend any of the introductory-level BW training workshops.<\/strong><\/span><\/p>\nTopics include:<\/span><\/p>\n\n- BUworks Portal Landscape<\/strong>: an overview of the BUworks Portal home page layout; describes help links, functions (tabs), and the panes containing system information;<\/li>\n
- BW Reporting Environment<\/strong>: an exploration of the Business Warehouse (BW) portal;<\/li>\n
- BW Report Folders and Folder Contents<\/strong>: a tour of a generic BW reporting folder \u2013 the folder list, report descriptions, and the context-sensitive help link.<\/li>\n
- What is a BW Report?<\/strong>\u00a0Distinguishes between a Business Warehouse report and a report produced when working in one of the transactional systems;<\/li>\n
- BW Data Basics and Data Access<\/strong>:\u00a0explores the basic characteristics of BUworks Business Warehouse data, including extraction from transactional systems, data load into BW, and the impact on business roles and security permissions on data visible to employees using reports;<\/span><\/li>\n
- How to Run a BW Report<\/strong>:\u00a0describes the steps involved in running a BW report, from determining the data you need through selecting a report which provides that data, specifying variable values and, finally, executing the report;<\/span><\/li>\n
- Understanding the Elements of a BW Report Layout<\/strong>: explores the essential elements of a generic layout of a Business Warehouse (BW) report. This includes Characteristics, Free Characteristics, Key Figures, subtotals, grand totals, and pagination icons.<\/span><\/li>\n
- Understanding the Role of\u00a0 Mouse Buttons in Reporting<\/strong>: describes when to use the left or the right mouse button when operating on a report.<\/span><\/li>\n
- How to Add, Remove, or Move a Column of Data<\/strong>: the ability to add, remove or move data within a report is one of the most common ways to customize Business Warehouse reports to suit your needs. This video describes (1) how to remove a characteristic, (2) how to add a characteristic from the Free Characteristics list, and (3) how to move a column from one position to another within a report.<\/span><\/li>\n
- How to Organize Report Data According to Column Position<\/strong>: the ability to organize or group and sort data within a BW report provides tremendous flexibility and power when using a report to answer a business question. Column position, from left to right, determines how your data will be organized. The left-most column has the highest degree of influence, and the impact on data organization diminishes for each column position to the right.<\/span><\/li>\n
- How to Filter Report Data<\/strong> (PDF):\u00a0filtering is the most commonly-used function with BW reports. This is a must-read to understand an essential tool.<\/li>\n
- How to Add or Remove a Report Subtotal or Grand Total<\/strong>: learn how to: add a subtotal across the rows of a report; a<\/span>dd a subtotal across the columns of a report; a<\/span>dd a report grand total; r<\/span>emove a subtotal or grand total from a report<\/li>\n
- How to Export Report Data to Excel:<\/strong>\u00a0this Guide is important to read because printing any BW report usually requires exporting data to Excel and printing there<\/span><\/li>\n
- How to Save and Use a View:<\/strong> a “View” is a customized report you can use over and over without the need to go through all the steps you followed to create the View initially. It’s also possible to share a View with colleagues, so this can be a valuable time saver.<\/li>\n
- How to Use the Online Help Search Box: d<\/strong>escribes how to access and use the Techweb Online Help Search box to easily find any of the myriad available BW Help resources.<\/li>\n
- Changing Data Display Characteristics: e<\/strong>xplains what is meant by “display characteristics” of report data and explores the various ways in which text descriptions and numeric keys can be modified.<\/li>\n<\/ol>\n
<\/div>\n<\/div>\n<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"The Process Guides\u00a0provide an introduction to the\u00a0elements of BUworks via\u00a0introductory videos and workflow visualizations categorized by business functions….<\/p>\n","protected":false},"author":1467,"featured_media":0,"parent":91924,"menu_order":5,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/www.bu.edu\/tech\/wp-json\/wp\/v2\/pages\/94922"}],"collection":[{"href":"https:\/\/www.bu.edu\/tech\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.bu.edu\/tech\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.bu.edu\/tech\/wp-json\/wp\/v2\/users\/1467"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bu.edu\/tech\/wp-json\/wp\/v2\/comments?post=94922"}],"version-history":[{"count":35,"href":"https:\/\/www.bu.edu\/tech\/wp-json\/wp\/v2\/pages\/94922\/revisions"}],"predecessor-version":[{"id":131788,"href":"https:\/\/www.bu.edu\/tech\/wp-json\/wp\/v2\/pages\/94922\/revisions\/131788"}],"up":[{"embeddable":true,"href":"https:\/\/www.bu.edu\/tech\/wp-json\/wp\/v2\/pages\/91924"}],"wp:attachment":[{"href":"https:\/\/www.bu.edu\/tech\/wp-json\/wp\/v2\/media?parent=94922"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}