|
|
|
- How to show remarks, or find the definition of the table(s) and field(s) you are selecting
- Learn in advance how many records your query will retrieve
- To clear data out of reports: pivots, charts and details
- Logoff from the warehouse server when you are away from your desk
- Control the size of the query results that will be displayed on your screen
- What numbers to use to calculate sums
- End a query: (to stop the row retrieval process)
- Get correct date when exporting a section from BrioQuery to Excel
How to show remarks, or find the definition of the table(s) and field(s) you are selection
After you have placed the table(s) on the Query screen,
- For a table, highlight the table name, and press CTRL+I keys (for Windows users) and COMMAND+I keys (Mac users).
- For a field, highlight the field name, and press the CTRL+I keys (for Windows users) and COMMAND+I keys (Mac users).
[Top]
Learn in advance how many records your query will retrieve
Use the Query Size command under the Query menu. However, be aware that asking for the size of your query involves all the work of processing your query except returning the rows. If you believe your query will return at least several thousand rows, you may want to go ahead and process it.
[Top]
To clear data out of reports: pivots, chargs and details
BrioQuery stores a "printing image" in the report tabs with your query showing information from the last time the query was processed. Clearing data from report tabs before closing your report will ensure that information is kept secure.
To do this, process your query with a false limit. Instead of selecting a "Faculty Rank", for example, type in a custom value such as "xxxx". Process the query--it should return zero rows, and both the results and all detail tabs should not have any data.
Please see the next tip for some related information.
[Top]
Logoff from the Warehouse server when you are away from your desk
Once BrioQuery is open and a user logged on, either by processing a query or by requesting the table catalog, the connection to the warehouse server is left open until it is terminated. It is a good idea to develop the practice of logging off the server when you are going to be away from your desk. That way, no one can process queries using your access in your absence.
To log off, either go under the File pull-down menu and select Logoff, or double click on the connection icon in the lower right corner of your screen (it looks somewhat like a dumbbell). After doing either action, the connection icon will have a red X through it, signifying you are no longer connected to the server.
[Top]
Control the size of the query results that will be displayed on your screen
Limit the results. For example, you can indicate "return first 100 rows only." To do this, go to the Request Line and double click on the word "Request." When the Modify Request screen appears, click on the Return First box (the default is 100), and then click on the OK button.
[Top]
What numbers to use to calculate sums
When your query uses both Fact and Dimension tables, do not put any number fields (such as SAT Math Score) from a Dimension table into the lower right side of the Outliner. Number fields in Dimension tables are not meant to be summed in this context and should be treated as text. If you need to find sums, take fields from the appropriate Fact tables.
[Top]
End a query (to stop the row retrieval process
This action will cut off communication with the server. Your query will continue to run in the server until it is finished.
- For Windows, press ALT+END keys.
- For the Mac, press the COMMAND+PERIOD keys.
[Top]
Get correct date when exporting a section from BrioQuery to Excel
Some users note that when they export dates to Microsoft Excel, the date that is transferred is one day greater than what is in the BrioQuery report data. To resolve this, go into Excel and make sure it is not set for the 1904 date system:
- Windows Users: Tools/Options/Calculations: uncheck the box that says 1904 date system
- Mac Users: Tools/Preferences/Calculations: uncheck the box that says 1904 date system
[Top]
Warehouse Guide
| e-mail aaude-warehouse@mit.edu
| Warehouse home
| AAUDE home