EPM Workspace enables users to query relational databases and heterogeneous sources (for example, users of SQL Server, Oracle, flat files, Production Reporting/Web Analysis module content) and perform quick ad-hoc analysis by drilling down and pivoting on the data to see patterns or exceptions. Many features help users to analyze their data to conduct sales and key performance, financial, and forecasting analyses.
Three types of users can relational data source. “Developers” who have the database connectivity software may use a full 32-bit application. “Power users” without this connectivity or when there are more security concerns may be given access to query using a client connected to the database through a server. Users can further given permission to create content completely from scratch, using add-on software installed on their local machine and hosted by the web browser. “Information consumer users” typically use a “thin client” approach; no software is loaded for these users, who instead interact with a DHTML-based series of pages.
The topics in this section explain how use to an Interactive Reporting document (BQY) in EPM Workspace for Information consumer users.