Managing External Breeze Reports
Trademarks 1 Step RoboPDF, ActiveEdit, ActiveTest, Authorware, Blue Sky Software, Blue Sky, Breeze, Breezo, Captivate, Central, ColdFusion, Contribute, Database Explorer, Director, Dreamweaver, Fireworks, Flash, FlashCast, FlashHelp, Flash Lite, FlashPaper, Flash Video Encoder, Flex, Flex Builder, Fontographer, FreeHand, Generator, HomeSite, JRun, MacRecorder, Macromedia, MXML, RoboEngine, RoboHelp, RoboInfo, RoboPDF, Roundtrip, Roundtrip HTML, Shockwave, SoundEdit, Studio MX, UltraDev, and WebHelp are eith
Contents Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 Intended audience . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 What’s new in external Breeze reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 Guide to documentation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 Additional resources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Contents
Introduction Macromedia Breeze supports external reporting through a collection of read-only database views. These database views allow you to develop a wide variety of customized reports for use throughout your enterprise. Intended audience This document is for licensed Breeze customers who want to develop customized reports based on Breeze data. What’s new in external Breeze reports In Macromedia Breeze 5.1, the reporting views have been created in the database. (In Breeze 4.
■ Breeze Meeting User Guide for Hosts and Presenters includes information about using the Breeze web application to host online real-time meetings. The documentation includes procedures that demonstrate the simplicity of adding slides, Flash SWF files, images, and live audio and video to your presentation. You can access this guide from the Breeze Manager home page, or from the Help menu within a Breeze meeting room (when you enter as a Presenter) by selecting Meeting > Help.
CHAPTER 1 1 Understanding Breeze Reports The Macromedia Breeze platform allows users to share online meetings, presentations, and training courses over the Internet. Reporting access to Macromedia Breeze data allows you to track learning effectiveness, participation, system usage, and content analysis. The Breeze database Macromedia Breeze requires a database to store information about users, content, courses, meetings, and reports.
Understanding Breeze Reports
CHAPTER 2 2 Using Breeze Reporting Views This chapter describes each of the database schema views used in Macromedia Breeze 5.1. The external views allow you to develop custom reports that are based on user activity within Macromedia Breeze. This chapter describes the following: ■ Column name data type ■ Length of data contained in each column ■ Primary keys used to map relationships Reporting data is accessible using an SQL-compliant tool.
The following are not supported: ■ Use of any other views besides the ones identified in this chapter ■ Any alterations of these views ■ Direct access to the underlying database schema Database views and data relationships The following entity relationship diagram shows the seven external reporting views. The arrows depict how data maps back to the view it was created from. You can view data relationships within any diagramming tool that allows you to connect to databases.
Unique identifiers and data relationships Relationships between views are defined by unique identifiers, which are columns that share the same name. The following table shows the columns that are mapped between views.
EXT_TRANSACTIONS sample entries TRANSACTION _ID LOGIN URL STATUS SCORE DATE_ VISITED 26 brice@adobe.com /r18595812/ completed 8.0 12/15/2004 11:17:38 PM 122 ccarr@adobe.com /p7096354/ inprogress 0.0 12/06/ 2004 11:18:48 PM 150 lblue@adobe.com /p8145026/ userpassed 10.
EXT_TRANSACTION_DETAILS sample entries TRANSACTION_ID QUESTION RESPONSE SCORE 334 What is the RAM requirement? 1 10.0 340 What is the RAM requirement? 1 10.0 531 How many current users are there? 1 0.0 Constraints The EXT_TRANSACTION_DETAILS view excludes the following fields: ■ Correct or Incorrect, which can be determined by checking for a non-zero score ■ Date answered, which does not exist in the version 5.
EXT_USERS This view lists users and associated profile attributes. The EXT_USERS view uses data listed in the following table: Column name Data type Description LOGIN NVARCHAR Unique user identifier. NAME NVARCHAR Unique user name. EMAIL NVARCHAR User’s unique email address. MANAGER NVARCHAR The login of the user’s manager. Manager is always set to NULL in version 5.1. TYPE NVARCHAR User or guest. Type is always set to user in version 5.1.
EXT_USER_FIELDS This view lists custom fields that can be used for each user. The EXT_USERS_FIELDS view uses data listed in the following table: Column name Data type Description LOGIN NVARCHAR Unique user identifier. NAME NVARCHAR Field name such as telephone number. VALUE NVARCHAR Field value such as 415.555.1212.
EXT_USER_GROUPS sample entries LOGIN NAME brice@adobe.com {admins} ccarr@adobe.com {authors} lblue@adobe.com {course-admins} Nesting of multiple groups is supported in version 5.1. For example, if group A contains group B, and you are in group B, you are listed as a member of A. Built-in groups, like the Account Administrators Group, use code names in the schema, as in the following SQL query: SELECT * FROM EXT_USER_GROUPS where group='{admins}.
EXT_OBJECTS sample entries URL TYPE /upgrade/ /standard/ NAME DATE_ BEGIN DATE_ END DATE_ DESCRIPTION MODIFIED presentation plugin upgrade (null) (null) 12/15/2004 11:10:38 PM meeting (null) (null) 11/14/2004 QA meeting 10:17:39 PM /r18595152/ swf datasheet (null) .
Using Breeze Reporting Views
