MACROMEDIA BREEZE-MANAGING EXTERNAL BREEZE REPORTS, Manual

Page 1: ...Managing External Breeze Reports ...

Page 2: ...ioned in this guide then you do so at your own risk Adobe Systems Incorporated provides these links only as a convenience and the inclusion of the link does not imply that Adobe Systems Incorporated endorses or accepts any responsibility for the content on those third party sites 2006 Adobe Systems Incorporated All rights reserved This manual may not be copied photocopied reproduced translated or ...

Page 3: ...e Reports 7 The Breeze database 7 About stored data 7 About reports 7 Chapter 2 Using Breeze Reporting Views 9 Database schema views used in reporting 9 Database views and data relationships 10 Unique identifiers and data relationships 11 EXT_TRANSACTIONS 11 EXT_TRANSACTION_DETAILS 12 EXT_TRANSACTIONS_VIEWS 13 EXT_USERS 14 EXT_USER_FIELDS 15 EXT_USER_GROUPS 15 EXT_OBJECTS 16 ...

Page 4: ...4 Contents ...

Page 5: ...orting views and install them on Breeze Communication Server Guide to documentation In addition to this manual the following electronic manuals and online help systems are available from the Breeze Documentation Center to help you learn about Breeze Breeze Manager User Guide describes how to use the administration presentation and meeting applications of Breeze You can access this guide from the B...

Page 6: ...nd audio 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 Participant by selecting Meeting Help Breeze Integration Guide includes information necessary to make application programming interface API calls on the Breeze server from your external system such as a web application It also explains how to interpret the XML...

Page 7: ...rver 2000 User activity such as viewing or submitting data within Breeze populates the database The collected data can then be viewed in customized reports using external tools such as Crystal Reports Macromedia ColdFusion Studio or SQL based tools About stored data The following data from Breeze sessions can be captured in Breeze reports Breeze Presentation content views slide views and presentat...

Page 8: ...8 Understanding Breeze Reports ...

Page 9: ...n each column Primary keys used to map relationships Reporting data is accessible using an SQL compliant tool Database schema views used in reporting Breeze supports external reporting through a set of integrated database views You use SQL queries to develop customized reports The following database views are supported in Breeze 5 1 EXT_TRANSACTIONS EXT_TRANSACTION_DETAILS EXT_TRANSACTION_VIEWS EX...

Page 10: ... 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 ...

Page 11: ...te data in this view Attending a meeting Viewing a piece of content Taking a course Unique identifiers View s used in URL EXT_OBJECTS EXT_TRANSACTIONS TRANSACTION_ID EXT_TRANSACTIONS EXT_TRANSACTIONS _DETAILS EXT_TRANSACTIONS _VIEWS LOGIN EXT_USERS EXT_TRANSACTIONS EXT_USER_GROUPS EXT_USER_FIELDS Column name Data type Description TRANSACTION_ID INT Unique ID for this transaction LOGIN NVARCHAR The...

Page 12: ...wers 1 and 4 there are two separate rows One row contains the value 1 and the other row contains the value 4 Data is generated in this view whenever a user does any of the following Answers a question in a quiz within a course Answers a poll within a meeting Adds a custom form to a meeting or course TRANSACTION _ID LOGIN URL STATUS SCORE DATE_ VISITED 26 brice adobe com r18595812 completed 8 0 12 ...

Page 13: ...wing table Data is generated in this view whenever a user views content or a course EXT_TRANSACTIONS_VIEWS 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 Column name Data type Description TRANSACTION_ID INT Unique ID for this transaction can be merged with TRANSACTION_DET...

Page 14: ...g a max date_visited query from the EXT_TRANSACTIONS view Active session which is data from the EXT_TRANSACTION view Instead you can retrieve this data by executing a STATUS IN PROGRESS query 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 al...

Page 15: ...sociated group members The EXT_USER_GROUPS view uses the 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 Changes group membership 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 LOGIN...

Page 16: ...isted in the following table Data is generated in this view whenever a user does any of the following Creates a meeting or a course Uploads content LOGIN NAME brice adobe com admins ccarr adobe com authors lblue adobe com course admins Column name Data type Description URL NVARCHAR Unique identifier for the object TYPE NVARCHAR Either a presentation course flv swf image archive meeting curriculum ...

Page 17: ...r ID URL TYPE NAME DATE_ BEGIN DATE_ END DATE_ MODIFIED DESCRIPTION upgrade presentation plugin upgrade null null 12 15 2004 11 10 38 PM IT presentation standard meeting plugin null null 11 14 2004 10 17 39 PM QA meeting r18595152 swf datasheet swf null null 09 11 2004 08 15 38 AM release presentation r18595121 meeting demo 02 15 2004 11 10 38 PM 02 15 2004 12 10 50 PM 2 12 2004 01 17 44 PM manage...

Page 18: ...18 Using Breeze Reporting Views ...