Summary of BREEZE-MANAGING EXTERNAL BREEZE REPORTS
Page 1
Managing external breeze reports.
Page 2
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, f...
Page 3
3 contents introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 intended audience . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 what’s new in external breeze reports . . . . . . . . . . . . . . . . . ...
Page 4
4 contents.
Page 5
5 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 ...
Page 6
6 introduction ■ 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...
Page 7
7 1 chapter 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 anal...
Page 8
8 understanding breeze reports.
Page 9
9 2 chapter 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...
Page 10
10 using breeze reporting views 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 sho...
Page 11
Database views and data relationships 11 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 a unique transaction id ...
Page 12
12 using breeze reporting views ext_transactions sample entries constraints the ext_transactions view excludes the following fields: ■ certificate number, which does not exist in the database ■ max score, which is often unavailable ext_transaction_details the ext_transactions_details view manages qu...
Page 13
Database views and data relationships 13 ext_transaction_details sample entries 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.1 schema...
Page 14
14 using breeze reporting views ext_users this view lists users and associated profile attributes. The ext_users view uses data listed in the following table: data is generated in this view whenever a user creates, updates or deletes a user. Ext_users sample entries constraints the ext_users view ex...
Page 15
Database views and data relationships 15 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: data is generated in this view whenever a user does any of the following: ■ creates, updates, or deletes a group ■...
Page 16
16 using breeze reporting views ext_user_groups sample entries 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 sche...
Page 17
Database views and data relationships 17 ext_objects sample entries constraints the ext_objects view excludes the following fields: ■ duration, which can be calculated by date_end - date_begin ■ size on disk, which exposes business rules regarding copies versus originals ■ folder id, which is often ...
Page 18
18 using breeze reporting views.