Jump to other news and events
Business Systems Reporting
Search field
Search button
Purdue Facebook page
Purdue Twitter feeds
Purdue YouTube Channel
Purdue News RSS feeds
Purdue iPhone App
General Info
Staff Directory
BEx
Business Explorer Tab
Super & Power Users Group
Tips & Tricks
Training
Workgroups
Brio
Installation
Oracle Error Messages
Training
Tips and Tricks
Business Warehouse
Access
End User Material
Error Messages
Metadata
Showcases
Training
Validation
DSS
Access
Metadata
Policy
Query Catalog
Student DSS
Showcases
PageCenterX
Access
Adding Reports
Contact Information
PageCenterX Login
Tips and Tricks
Reporting
GM AIMS
Reporting Information
Other Links
BSR Mail Lists
Technical Support
Business Services
Administrative Information Services (AIS)
BrioQuery SQL Functions
NOTE: all of these tips require the creation of a
Computed Item
in Brio.
String Functions
Concatenate
Sub-string
To Char
Initcap
Aggregate Functions
Count Distinct
Summing
Conditional Function
Decode
Date Functions
Adding Months
Calculating Months Between
Sysdate
Combined Functions
Decode & Sub-String
Initcap & Concatenate
Sysdate & Concatenate
Months Between & Sysdate
Business@Purdue
B@P News
Business Forms
SecurePurdue
Training
Blackboard
Employee Portal
myPurdue
Directory
Calendars
Campus Map
ITaP
Purdue University, West Lafayette, IN 47907, (765) 494-4600
© 2011 Purdue University
|
An equal access/equal opportunity university
|
Copyright Complaints
If you have trouble accessing this page because of a disability, please contact Business Services at
bstcweb@purdue.edu
.
Maintained by:
Business Services