We could also slice and dice the same query results in Brio's OLAP-oriented pivot table and chart views. In pivot table and chart views, we could easily pivot or change the dimensions on display and could also drill down from an aggregated to a detailed view of data. Broadbase's server engine is aggregate-aware and quickly delivers data to Brio from the most efficient source. Broadbase Administrator uses the familiar Microsoft Explorer outline interface to manage database objects. The Administrator can start and stop Broadbase servers and add, drop or modify database objects.
Basic security is provided through maintenance of user accounts and roles assigned to accounts.
Sites with clean data sources can implement this complete data mart in a matter of days or weeks. However, those with very large or messy databases might need to look at a combination of dedicated products from competing vendors.