Printer Friendly
The Free Library
14,507,090 articles and books
Member login
User name  
Password 
 
Join us Forgot password?

Business Objects Ships New Version of BusinessQuery for Excel; BusinessQuery 4.0 Brings More Powerful Queries and Faster Performance.


ORLANDO, Fla.--(BUSINESS WIRE)--Feb. 26, 1997--Business Objects (NASDAQ NASDAQ
 in full National Association of Securities Dealers Automated Quotations

U.S. market for over-the-counter securities. Established in 1971 by the National Association of Securities Dealers (NASD), NASDAQ is an automated quotation system that reports on
:BOBJY), the world's leading provider of integrated query, reporting, and online analytical processing Online Analytical Processing, or OLAP (IPA: /ˈoʊlæp/), is an approach to quickly provide answers to analytical queries that are multidimensional in nature.  (OLAP (OnLine Analytical Processing) Decision support software that allows the user to quickly analyze information that has been summarized into multidimensional views and hierarchies. OLAP tools are used to perform trend analysis on sales and financial information. ) tools, today announced that it has begun shipping BusinessQuery 4.0, a new version of BusinessQuery for Excel An Excel add-in program from Business Objects that provides an alternate front end to the BusinessObjects query and reporting tool. It allows the queries to take place from within the Excel spreadsheet, where the data is combined and analyzed. See BusinessObjects. , its Microsoft Excel (tool) Microsoft Excel - A spreadsheet program from Microsoft, part of their Microsoft Office suite of productivity tools for Microsoft Windows and Macintosh. Excel is probably the most widely used spreadsheet in the world.

Latest version: Excel 97, as of 1997-01-14.
 add-in product that gives Excel users access to information stored in corporate databases, data marts, and data warehouses.

BusinessQuery is the first product to provide the Excel user with easy access to corporate data by insulating the user from relational database relational database

Database in which all data are represented in tabular form. The description of a particular entity is provided by the set of its attribute values, stored as one row or record of the table, called a tuple.
 concepts and the structured query language See SQL.

Structured Query Language - SQL
 (SQL SQL
 in full Structured Query Language.

Computer programming language used for retrieving records or parts of records in databases and performing various calculations before displaying the results.
). BusinessQuery provides the Excel users with data access through a business representation of data via the BusinessObjects patented query technique and semantic layer Semantic Layer

The semantic layer is a business representation of corporate data that helps end users access data autonomously using common business terms. Developed and patented by Business Objects, it maps complex data into familiar business terms such as product,
. BusinessQuery is tightly integrated with Excel, is implemented as an Excel add-in, and is accessed through a supplemental menu and toolbar A row or column of on-screen buttons used to activate functions in the application. Many toolbars are customizable, letting you add and delete buttons as required. Toolbars may be fixed in position or may float, which means they can be dragged to a more convenient location in the .

"A key strength of Business Objects is our ability to deliver decision support to the complete range of business users -- from the non-technical business manager to the `Excel junkie' and everyone in between," said Dave Kellogg, vice president of corporate marketing at Business Objects. "With BusinessQuery, we've obviously struck a chord with the Excel user community, having sold more than 80,000 copies in two years. With BusinessQuery 4.0, we've listened to our existing customers' requests and have made the product both faster and more powerful."

"With the new release of BusinessQuery, Business Objects is continuing to expand the breadth of functionality that they offer to their users," said Robert Moran
For the Seattle entrepreneur (1857–1943) and mayor in 1888-90, see Robert Moran (shipbuilder)


Robert Moran (born January 8, 1937) is a renowned American composer of operas and ballets as well as numerous orchestral, vocal, chamber and dance
, director of decision support research at Aberdeen Group Aberdeen Group is a provider of business-related research services. It has its headquarters in Boston, Massachusetts and belongs to the Harte-Hanks group. Founded in 1988, Aberdeen's research is used by over 2. . "Business Objects offers their users a wide range of capabilities -- whether it's accessing corporate data from within Excel using BusinessQuery, or doing integrated query, reporting, and OLAP using BusinessObjects."

More Powerful Queries

BusinessQuery 4.0 includes all of the power of the BusinessObjects 4.0 patented query technique. Thus, the BusinessQuery 4.0 query generator now offers several key new features including:

-- Set queries. The BusinessQuery 4.0 user can formulate queries that use set theoretic operations, such as union and intersection. For example, the user can now answer questions such as "show me all users who bought a luxury car in the past year or spent more than $50,000 in the past two years."

-- Aggregate awareness. BusinessQuery 4.0 includes the ability to process queries against highly summarized aggregate tables rather than atomic-level data. This relational online analytical processing (ROLAP See OLAP. ) feature results in 100- to 1,000-fold improvements in query processing performance.

-- Multistar schema support. Today's data warehouses and data marts often make use of more than one centralized "fact" table. BusinessQuery 4.0 includes the ability to generate multiple SQL statements, a requirement for generating correct results when operating against these "multistar" schemas.

-- Shortcut (1) In Windows, a shortcut is an icon that points to a program or data file. Shortcuts can be placed on the desktop or stored in other folders, and double clicking a shortcut is the same as double clicking the original file.  joins. The BusinessQuery 4.0 query generator can bypass unneeded intermediary tables when generating SQL statements. This results in the generation of simpler SQL statements that can be processed faster and more efficiently by the underlying DBMS (DataBase Management System) Software that controls the organization, storage, retrieval, security and integrity of data in a database. It accepts requests from the application and instructs the operating system to transfer the appropriate data. .

Faster Performance

In addition to the query processing performance enhancements, BusinessQuery 4.0 improves performance through the use of:

-- 32-bit architecture. BusinessQuery 4.0 uses a new, 32-bit architecture which streamlines performance and exploits the new memory management of 32-bit operating systems Operating systems can be categorized by technology, ownership, licensing, working state, usage, and by many other characteristics. In practice, many of these groupings may overlap.  such as Windows 95 and Windows NT (Windows New Technology) A 32-bit operating system from Microsoft for Intel x86 CPUs. NT is the core technology in Windows 2000 and Windows XP (see Windows). Available in separate client and server versions, it includes built-in networking and preemptive multitasking. .

-- OLE automation. BusinessQuery 4.0 makes use of OLE automation to interface between Excel and the BusinessObjects query generator. This results in the more efficient transfer of data between BusinessQuery and Microsoft Excel.

Other New Features

In response to user feedback, BusinessQuery 4.0 now contains a host of other new features, including:

-- Shared queries. Users can now post queries and results to the BusinessObjects repository for use by their colleagues. This is an important feature for organizations where people tend to work in a collaborative manner and use the queries and results produced by others.

-- Enhanced SmartSpace(TM). The SmartSpace feature, which ensures the integrity of data in the spreadsheet, has been made easier to use through user prompts and predefined settings.

-- Enhanced QueryDirector(TM). The QueryDirector can now locate, edit, and run multiple queries, and specify the order in which they are executed. This is very useful when the results from one query are used as a condition for another, for example when carrying out simulation or what-if analysis.

-- Query on range. Query conditions have been enhanced to allow users to define a condition based on the value of an Excel cell or Excel range by clicking directly on that Excel cell or range. This new point-and-click interface makes it even easier to create queries linked to values already in a spreadsheet.

Helene Curtis Uses BusinessQuery in Retail and Corporate Sales

Helene Curtis, a leader in the personal care products market (including such brands as Finesse and Salon Selectives shampoos, Degree antiperspirant antiperspirant /an·ti·per·spir·ant/ (-per´spir-ant) inhibiting or preventing perspiration, or an agent that does this.

an·ti·per·spi·rant
n.
, and Suave suave  
adj. suav·er, suav·est
Smoothly agreeable and courteous.



[French, agreeable, from Old French, from Latin su
 hair and skin care products), currently has 200 users in the retail and corporate sales departments using BusinessQuery for Excel. Users access product information, including pricing, manufacturing, and shipping schedules; and customer purchasing patterns -- for example, who orders the most shampoo in the Midwest or who returned the most stick deodorant deodorant /de·odor·ant/ (de-o´der-int)
1. masking offensive odors.

2. an agent that so acts.


de·o·dor·ant
n.
 last month.

"Our sales people really like the familiarity of working with Excel, and BusinessQuery allows them to easily get at corporate data," said Judson Roberts, senior systems technician at Helene Curtis. "The new release of BusinessQuery for Excel will bring several new exciting features to our users: a great performance gain, a 32-bit architecture, and tremendous enhancements to Business Objects' famous query technique."

Pricing and Availability

BusinessQuery 4.0 is shipping in production status. BusinessQuery 4.0 is $150 when purchased with BusinessObjects, and $350 when purchased standalone.

BusinessQuery 4.0 is available on Windows 95 and Windows NT and requires Microsoft Excel 7. Support for Excel 97 will be available in 2H97. French, German, and Spanish versions will be available in early 2Q97.

About Business Objects

Business Objects (NASDAQ:BOBJY) is the world's leading provider of integrated enterprise decision support tools. Business Objects products provide non-technical business users with access to information stored in corporate data warehouses, data marts, and packaged business applications. The company pioneered the modern decision support market in 1990 by introducing the "semantic layer," a patented technology that maps complex databases to a business representation understandable by non-technical end users.

The company's award-winning products include BusinessObjects, the first integrated query, reporting, and online analytical processing (OLAP) tool; BusinessQuery, the first Microsoft Excel add-in to provide a business representation of data; and BusinessMiner, the first data mining tool positioned for the mainstream business user. Oracle users recently voted BusinessObjects the best DSS/OLAP tool in the Oracle Technical Journal's annual best product awards.

Business Objects has sold more than 475,000 licenses to over 4,000 organizations in more than 60 countries. The company maintains business partnerships with more than 450 organizations around the world. The company's web site is http://www.businessobjects.com. -0-

Note to Editors: BusinessObjects is a trademark of Business Objects SA. Other company and product names may be trademarks of the respective companies with which they are associated.

A full-text copy of this announcement may be obtained by calling the company's fax retrieval line at 1-800/414-2114 and selecting option "one". The announcement may also be downloaded from the Web; access "http://www.businesswire.com/cnn" and search on "Business Objects".

CONTACT: Business Objects

Tracy Eiler, 408/953-6031

Danielle Dawson, 408/953-6108
COPYRIGHT 1997 Business Wire
No portion of this article can be reproduced without the express written permission from the copyright holder.
Copyright 1997, Gale Group. All rights reserved. Gale Group is a Thomson Corporation Company.

 Reader Opinion

Title:

Comment:



 

Article Details
Printer friendly Cite/link Email Feedback
Publication:Business Wire
Date:Feb 26, 1997
Words:1228
Previous Article:SICAN Debuts Advanced System Cores for Video Conferencing and Acceleration.
Next Article:DepoTech Corp. begins pediatric study of DepoCyt.
Topics:



Related Articles
Business Objects opens up query technology - introduces BusinessQuery for Excel; New product delivers unprecedented data access capabilities for...
ESSBASE 4.0 Garners Broad Support From Leading Software Vendors; 25 Leading Products Integrate With Enhanced Essbase Server.
Business Objects reports first quarter results.
Business Objects reports first quarter results.
Business Objects customers recognized for outstanding corporate intranet solutions; ADT Innovator award winner and DB/EXPO RealWare award finalist.
Business Objects Announces Support for Microsoft OLE DB for OLAP.
Business Objects Announces Support for Sybase Adaptive Server Enterprise 11.5.
Sagent Launches New Internet Enterprise Intelligence Solution.
Informix Business Solutions and Business Objects Expand Partnership to Deliver Complete Vertical Business Intelligence Solutions.
Release 12 from Mathworks.(new software introduction)(Product Announcement)

Terms of use | Copyright © 2009 Farlex, Inc. | Feedback | For webmasters | Submit articles