background image

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 either registered trademarks or trademarks of Adobe Systems Incorporated and may be 
registered in the United States or in other jurisdictions including internationally. Other product names, logos, designs, titles, 
words, or phrases mentioned within this publication may be trademarks, service marks, or trade names of Adobe Systems 
Incorporated or other entities and may be registered in certain jurisdictions including internationally.

Third-Party Information

This guide contains links to third-party websites that are not under the control of Adobe Systems Incorporated, and Adobe 
Systems Incorporated is not responsible for the content on any linked site. If you access a third-party website mentioned 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 converted to any electronic or machine-readable form in whole or in part without written approval from 
Adobe Systems Incorporated. Notwithstanding the foregoing, the owner or authorized user of a valid copy of the software 
with which this manual was provided may print out one copy of this manual from an electronic version of this manual for 
the sole purpose of such owner or authorized user learning to use such software, provided that no part of this manual may 
be printed out, reproduced, distributed, resold, or transmitted for any other purposes, including, without limitation, 
commercial purposes, such as selling copies of this documentation or providing paid-for support services. 

Acknowledgments

Editorial Manager: Stephanie Gowin

Writing: Jody Bleyle

Editing: Mary Ferguson

Production Management: Adam Barnett

Media Design and Production: Adam Barnett and John Francis

Second Edition: January 2006

Adobe Systems Incorporated

 

601 Townsend St.

 

San Francisco, CA 94103

Содержание BREEZE-MANAGING EXTERNAL BREEZE REPORTS

Страница 1: ...Managing External Breeze Reports ...

Страница 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 ...

Страница 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 ...

Страница 4: ...4 Contents ...

Страница 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...

Страница 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...

Страница 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...

Страница 8: ...8 Understanding Breeze Reports ...

Страница 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...

Страница 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 ...

Страница 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...

Страница 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 ...

Страница 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...

Страница 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...

Страница 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...

Страница 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 ...

Страница 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...

Страница 18: ...18 Using Breeze Reporting Views ...

Отзывы: