Ad Hoc/OLAP

WebFOCUS combines the best query tools with the best online analytical processing (OLAP) functionality, enabling users throughout your enterprise to slice and dice data in an almost unlimited number of ways.

The WebFOCUS Report Assistant provides an intuitive, graphical interface that shields users from technical complexities and allows them to use business terminology instead of database terminology. Novice users running structured ad hoc reports and performing general queries can quickly and efficiently satisfy their own information needs in real time.

The WebFOCUS Report Assistant offers:

• Tree-style structures that logically organize database columns into folders, making it easier for users - especially those working with large databases - to quickly locate the ones they need
• Drag-and-drop functionality that allow users to rapidly select required columns and specify sorts
• Cell-based graphics that allow users to attach bar-graph columns to each report measure, or inspect items visually with different measures on the same screen

Additionally, business analysts and power users - the producers of information - require tools with sophisticated functionality to discover critical trends and relationships, dynamically interact with their organization's data, and conduct complex analyses that integrate OLAP and Microsoft tools.The WebFOCUS Report Assistant provides both OLAP dimensional hierarchies for cube metadata and the option to view field lists, simplifying search and navigation of data for the end user.

It also empowers advanced users with hundreds of options to pivot, filter, resort, and recalculate items so they can better manipulate and analyze information. And, WebFOCUS supports the real-time creation of Excel spreadsheets and Excel PivotTables with full styling, drill-downs, and formula capabilities. So Excel power users can analyze their corporate data using a familiar tool.

From the business analyst conducting complex analysis that integrates OLAP and Microsoft tools, to the novice user running structured ad hoc reports and performing queries, WebFOCUS enables anyone to quickly and efficiently satisfy their own real-time information needs using simple business terminology.

WebFOCUS Comprehensive User Services allow you to provide secure access to personalized and specialized information, enabling users to run reports or leverage advanced analytical functionally with broad, dynamic access to nearly any data in any location.