Soft82.com » Windows » Business » Database Management » Intelligencia Query for SQL 2005 3.0.23

View screenshots

Intelligencia Query for SQL 2005 Description

Intelligencia Query delivers add-in functionality for Visual Studio

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 FluentTM 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.

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
feature 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.
feature 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.
feature 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.
feature 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.
feature 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.
productivity 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.
productivity 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.

Intelligencia Query for SQL 2005 Download Button For Your Site

If you want to place a Download Button for Intelligencia Query for SQL 2005 on your website just insert the following code:

If you want a Link to this page you can use one of the logos bellow:

Intelligencia Query for SQL 2005 User Reviews

New Database Management Software

QueryToDoc May 21, 2012 Use QueryToDoc to export SQL Server and Oracle query results to a Word, HTML, or CSV File				DataSlave May 21, 2012 Import, Validation and Transformation of Data
Universal SQL Editor May 17, 2012 Intellisense enabled SQL editor for Oracle, DB2, SQL Server, Sybase, etc.				DTM DB Stress May 16, 2012 DTM DB Stress is a utility for database and db-applications stress testing
SB Solutions May 15, 2012 BAAC offers Small Business Database SW for managing Contacts and Accounting				ActiveData For Office/SQL Edition May 14, 2012 A Windows application that leverages the power of Microsoft Office and SQL databases
MONyog MySQL Monitor May 11, 2012 MONyog helps MySQL DBAs manage more MySQL servers, tune their current servers				MDB Viewer Plus May 10, 2012 View and edit the content of .mdb files without the need to have Microsoft Access installed
PHPRunner May 9, 2012 PHPRunner creates set of PHP pages to access and modify any MySQL database				X-SQLT May 9, 2012 A free-form, declarative, XML-based language used to describe a series of commands for data
TirePrices May 8, 2012 Click on Mfg., or Size, or Type, or Misc. Code to see 3 pricing levels				DBConvert for MS SQL & MySQL May 8, 2012 DBConvert for MS SQL & MySQL - Bi-directional db conversion tool for MS SQL and MySQL databases
GeniusConnect May 8, 2012 Add database connectivity to Outlook or Exchange				B&B Quick Quote May 3, 2012 Quick Quote displays the costs (labor or parts/products) from a selected job
phpMyAdmin May 2, 2012 phpMyAdmin is a tool written in PHP used to administrate MySQL databases				My Money May 2, 2012 My Money is a high quality personal financial software written from ground up
dotConnect for MySQL April 25, 2012 An enhanced data provider for MySQL that builds on ADO.NET technology to present a complete				DBSync for MS Access & MSSQL April 24, 2012 Bi-directional synchronization and convertion for MS Access and MS SQL Server
CDBF - DBF Viewer and Editor April 20, 2012 Easy to use, very fast and small DBF viewer and editor				DBF Manager April 19, 2012 Manage DBF files easily using this innovative tool! Free trial version available

Last 7 Days Most Downloaded Database Management Products

MySQL Workbench 160 downloads Visual database design application that can be used to efficiently design, manage				TOAD for Oracle Freeware 42 downloads Tool for Oracle Application Developers
Mobile DBViewer Plus for Nokia S60 3rd E 36 downloads View & Sync any database with Nokia S60 3rd Edition phone. Create DB on mobile.				QI Macros 35 downloads Draws pareto charts, control charts, histograms, box and whisker plots, scatter plots and more
HotRez 24 downloads The Hotel Reservation Software HotRez is a Room Booking Software for Hotels				smart report maker (MySQL Report Generator) 17 downloads Create and manage unlimited number of MySQL Reports
SQLyog MySQL GUI 16 downloads SQLyog is a tool that allows you manage MySQL database				Pabx Billing System and Hotel Management 14 downloads Compatible with any PBX, 54 bills for Pabx Billing feature, 12 bills for Hotel
Full Convert Enterprise 13 downloads Full Convert is the best application to convert structure and data of databases.				DBF Viewer 2000 13 downloads Powerful viewer and editor for DBF files (Clipper, dBase, Foxpro, VFP, DB2K...)

All Time Most Downloaded Database Management Products

MySQL Workbench 19,571 downloads Visual database design application that can be used to efficiently design, manage				TOAD for Oracle Freeware 14,512 downloads Tool for Oracle Application Developers
Mobile DBViewer Plus for Nokia S60 3rd E 11,067 downloads View & Sync any database with Nokia S60 3rd Edition phone. Create DB on mobile.				QI Macros 722 downloads Draws pareto charts, control charts, histograms, box and whisker plots, scatter plots and more
HotRez 3,950 downloads The Hotel Reservation Software HotRez is a Room Booking Software for Hotels				smart report maker (MySQL Report Generator) 252 downloads Create and manage unlimited number of MySQL Reports
SQLyog MySQL GUI 4,755 downloads SQLyog is a tool that allows you manage MySQL database				Pabx Billing System and Hotel Management 345 downloads Compatible with any PBX, 54 bills for Pabx Billing feature, 12 bills for Hotel
Full Convert Enterprise 2,338 downloads Full Convert is the best application to convert structure and data of databases.				DBF Viewer 2000 1,957 downloads Powerful viewer and editor for DBF files (Clipper, dBase, Foxpro, VFP, DB2K...)