Brio Query Explorer 6教程 带测验题







Copyright © 2003 Massachusetts Institute of Technology



TABLE OF CONTENTS....................................................................................I

BRIOQUERY BASICS LEVEL 1.....................................................................3

OVERVIEW.........................................................................................................3

Tools for navigating around aspects of using BrioQuery...........................9

Toolbars for performing tasks....................................................................12

Status bar for getting information about your queries..............................12

CREATING THE QUERY.....................................................................................13

Choosing the tables....................................................................................13

Getting information on tables and fields...................................................15

SPECIFYING THE ITEMS OF DATA TO RETRIEVE................................................16

Rearranging items in the Request Line.....................................................17

Removing items from the Request Line....................................................17

CHECKING THE QUERY SIZE.............................................................................18

MORE THINGS TO KNOW ABOUT LIMITS..........................................................23

PROCESSING THE QUERY.............................................................................23

SAVING THE QUERY AND RESULTS..................................................................25

WORKING WITH THE RESULTS..........................................................................25

Resize Column Widths...............................................................................26

Wrap text in a column................................................................................26

Move columns............................................................................................27

EXERCISE 1......................................................................................................28

EXPORTING DATA INTO OTHER FILE FORMATS................................................29

THE RELATIONSHIP BETWEEN TABLES...........................................................30



BrioQuery Basics Level 1

Creating the Star.........................................................................................34

USING DATA FUNCTIONS ON THE QUERY SCREEN...........................................37

CREATING A COMPUTED COLUMN..................................................................38

EXERCISE.........................................................................................................42

PIVOT REPORTS................................................................................................45

Creating a Pivot..........................................................................................45

Creating Computed Items in the Pivot......................................................46

Drilling down into data..............................................................................47

EXERCISE.........................................................................................................58

APPENDIX A....................................................................................................59

CREATING AN OPEN CATALOG EXTENSION......................................................59

ii 3/9/2022