Intelligencia Query delivers add-in functionality for Visual Studio that transforms the task of creating OLAP reports with Microsoft SQL Server Reporting Services. State-of-the-art query tools are combined with a custom data extension that understands how OLAP reporting should work. With Intelligencia Query you get:
- Queries are built the way that your report is to be displayed. There are no restrictions on where each dimension can be displayed or how many dimensions can appear on an axis.
- Only the data required to fulfil your report is returned making IQ faster and more efficient than the default Reporting Services data extension.
- Performance is further enhanced by providing techniques for building drilldown reports that only return drilled data as it is required.
- The flexibility of the query builder dramtically reduces the need to "hand-crank" Mdx leading to better maintainability and reduced skill requirements.
- Table and Matrix report items are supported allowing all types of reports to be created without having to resort to SQL queries via the Analysis Services ODBO interface.
- Intelligencia Query support SAP BW and Congons TM1 in addition to all versions of SQL Server Analysis Services.