 |
If using Brio 5.x, see Brio 5.x and Data Warehouse Tips.
The following tips apply to all data subsets in the University of Maryland Data Warehouse. Some tips are specific to the Brio Intelligence Explorer software.
CONTENTS
Blank Fields
Blank fields in the Transactional Systems are treated in the following ways in the warehouse:
| Transactional System Type |
|
Data Warehouse |
| Text fields (alpha) |
|
* (asterisk) |
| Code fields |
|
* (asterisk) |
| Numeric fields |
|
NULL |
| Date fields |
|
NULL |
| Yes/No |
|
Y or N |
Limits
When building your own queries, limit with the "code" field rather than the "description" field. If you use the description field and misspell a word, your results will not contain any records.
Show Values
The Show Values feature in the Limit dialog box, shows only those values that exist for the limited subsets requested via the limit line, rather than all possible values for that field. For example, if you limit your query to request faculty for a particular department which does not have any faculty in it, none of the faculty categories will appear in the Limit dialog box for that limit.
Quick Counts
To get a quick count, use the Pivot report feature available with the BrioQuery software. Request Um Id in the Request Line as part of your query. Process the query and then insert a New Pivot section. Place the appropriate field identifier in the Side Labels section and Um Id in the Facts section of Outliner. Highlight Um Id's column in pivot chart and select Pivot menu, select Data Function and select Count.
Data Element Attributes
To review the attributes of a data element, highlight the data element in the table and select the View menu and select Properties or right-click and select Properties. The Topic Item Properties dialog box will list the item type, i.e. long string, timestamp, real number, integer, and the length. These attributes are integral when creating computed columns and performing functions such as SUBSTR [substring] and CONCAT [concatenate](BrioQuery feature).
Alphabetizing Data Elements in a Table
To alphabetize the data elements in a table on the workspace:
- Select the topic on the workspace by clicking on the topic name.
- Select the View menu and select Properties or right-click and select Properties.
- In the Topic Properties dialog box, press the Sort button.
- Click on OK.
Changing Your Database PasswordFor security purposes your password should be changed upon your account being activated and periodically thereafter. To change your password:
- In order to change your password you must first be logged on!
- Select Tools menu and select Connections Manager
- Click the name of the .oce that you are using and want to change the database password.
- Click Change Database Password
- A Change Password dialog box will appear:
- Type in your current password and press Tab key on keyboard.
- Type in your new password and press Tab key.
- Type in your new password again and click on OK.
- Upon changing the password you will see a Change Password notice appear:
- Click on OK.
|
