VIDEO LINKS

See Intelligencia Olap Controls in action in our short introduction videos.

IQ Demo

DOWNLOADS

Download additional information about Intelligencia Query.

	Evaluation Software
	IQ User Guide

PURCHASE

Buy Online using your credit card.

From iT-Workplace
From ComponentSource

Need information about purchasing larger quantities?

tel: +44 (0)115 852 4711
email: sales@it-workplace.com

Analysis Services/Reporting Services the way it should work

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.

Implemented using the Microsoft Fluent^TM user interface the query builder is simple to use but also provides a high level of functionality for advanced users including, for example, the ability to create asymmetric queries and parameterized reports. Unlike standard Reporting Services you create queries the way you wish to see them displayed, making the process intuitive and the Mdx generated more efficient. The custom data extension provided with IQ renders these queries directly to the matrix layout control without having to transform the data into a flattened rowset.

Unique formatting and layout attribute allow you to build reports that are simply not possible with the standard functionality provided in Reporting Services.

Intelligencia Query has been developed with the co-operation of well known Mdx guru Chris Webb.

P&L Report

Features

Intelligencia Query solve a number of issues with the use of SQL Server Analysis Services (SSAS) and other OLAP databases when working in Microsoft Reporting Services.

	Problem Definition	Solution
	Reporting Services will not allow you to place the measures dimension on the row axis and this therefore prevents the possibility of parameterizing reports on members in the measures dimension.	Intelligencia Query treats the Measures dimension in the same way as any other dimension/hierarchy.
	Reporting Services is not able to interpret the role of any member regarding its formatting in a report.	Intelligencia Query provides built-in attributes that indicate that a member is a total/subtotal. When used in conjunction with conditional formatting expressions this provides improved clarity and readability.
	Due to the field naming conventions in Reporting Services it is not possible to create a single report that allows users to select the members of a level within a hierarchy as a parameter.	Intelligencia Query uses abstracted field naming which allows a single matrix control to be used for parameters that represent different levels within hierarchies.
	The Reporting Services query builder does not allow the selection of anything other than all members in Parent/Child dimensions.	Intelligencia Query allows you to select any set of members irrespective of dimension type.
	Only SQL Server Analysis Services supports the use of MDX parameters. You cannot create parameterised reports for other providers (E.g. SAP BW)	Intelligencia Query allows you to create single and multi-value parameterised reports for SAP BW as well as SSAS.
	Reporting Services will allow only the Measures dimension to be placed on the column axis. This prevents the use of standard Mdx expressions.	Intelligencia Query can process any Mdx expression into a Reporting Services report. You can use the IQ query builder to create Mdx queries or paste Mdx created in other applications. This encourages the re-use of Mdx and allows Mdx queries to be built where the structure of the returned cellset corresponds to the report output.
	The Reporting Services query designer has very limited functionality for creating sets that represent a subset of the members of a hierarchy (For example the descendants of a single top level member). As a consequence most reports will require “hand cranking” of Mdx to obtain the correct subset of data, a process that is time-consuming and leads to maintenance problems when a report needs to be modified.	Intelligencia Query provides rich functionality for selecting the sets of data to be used in a query. The user interface also encourages the creation of efficient Mdx. You build your query with just the data you want to extract laid out the way you want your report to look. Some examples of functionality offered by IQ that is not available in the Reporting Services designer are: Select individual members, their children and descendants. Order sets of members so that totals are displayed at the bottom of data groups. Create asymmetric queries with multiple select clauses on the same axis.

Key
	Unique Feature		Productivity Benefit

Report Gallery

The following screen shots are from the samples shipped with Intelligencia Query and show how the extended functionality allows you to create reports that are not possible with standard Reporting Services.

Click on the thumbnails below to view the reports:

Simple Sample	Advanced Selections	Formatting


Drill Down	Parameterized	Parameterized Hierarchy