MACROMEDIA BREEZE-MANAGING EXTERNAL BREEZE REPORTS Скачать руководство пользователя страница 10 | Manualshive

Страница: 10 / 18

background image

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 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.

«
...
8
9
10
11
12
...
»

Содержание 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 ...

Отзывы:

Нет отзывов

Похожие инструкции для BREEZE-MANAGING EXTERNAL BREEZE REPORTS

Бренд: Panasonic Страницы: 69

DRAGON NATURALLYSPEAKING 7

Бренд: ScanSoft Страницы: 222

Бренд: Adobe Страницы: 323

Бренд: Omron Страницы: 2

Бренд: Sling Media Страницы: 112

NAPCKE-AB-AA - VirusScan For NetApp

Бренд: McAfee Страницы: 54

Writing an embedded application loader

Бренд: Sierra Wireless Страницы: 9

Бренд: Sierra Wireless Страницы: 16

9235 - Coolscan III

Бренд: Nikon Страницы: 153

CONTRIBUTE 3 - DEPLOYING AND PUBLISHING SERVER

Бренд: MACROMEDIA Страницы: 38

18506-091462-9305 - Architectural Desktop 2006

Бренд: Autodesk Страницы: 290

Бренд: Canon Страницы: 156

Nuvi 780 - Automotive GPS Receiver

Бренд: Garmin Страницы: 14

Бренд: HP Страницы: 210

Бренд: HP Страницы: 3

D300s - Evo - 128 MB RAM

Бренд: HP Страницы: 2

ProBook 4525s - Notebook PC

Бренд: HP Страницы: 4

ProBook 4525s - Notebook PC

Бренд: HP Страницы: 149

Бренды по названию

0 1 2 3 4 5 6 7 8 9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Популярные бренды

Загрузить еще бренды