Detailed instructions for use are in the User's Guide.
[. . . ] BusinessObjects Live Office XI 3. 0 User Guide
Business Objects Enterprise XI 3. 0 Windows
Copyright
© 2008 Business Objects. Business Objects owns the following U. S. patents, which may cover products that are offered and licensed by Business Objects: 5, 555, 403; 5, 857, 205; 6, 289, 352; 6, 247, 008; 6, 490, 593; 6, 578, 027; 6, 831, 668; 6, 768, 986; 6, 772, 409; 6, 882, 998; 7, 139, 766; 7, 299, 419; 7, 194, 465; 7, 222, 130; 7, 181, 440 and 7, 181, 435. Business Objects and the Business Objects logo, BusinessObjects, Business Objects Crystal Vision, Business Process On Demand, BusinessQuery, Crystal Analysis, Crystal Applications, Crystal Decisions, Crystal Enterprise, Crystal Insider, Crystal Reports, Desktop Intelligence, Inxight, the Inxight Logo, LinguistX, Star Tree, Table Lens, ThingFinder, Timewall, Let there be light, Metify, NSite, Rapid Marts, RapidMarts, the Spectrum Design, Web Intelligence, Workmail and Xcelsius are trademarks or registered trademarks in the United States and/or other countries of Business Objects and/or affiliated companies. [. . . ] You do not need to know complex programming languages. With minimal effort, you can define queries and retrieve meaningful answers to business queries such as the following: · · Get sales figures for the first three quarters of this year for all customers in North America by region. Get a list of all customers worldwide who are partners.
The data is arranged in table format where you can access it from your Microsoft Office Excel, Word, Outlook or PowerPoint documents. This document contains information about creating, editing, and revising queries in Live Office.
Related Topics
· · · ·
Viewing query properties on page 78 Creating and running queries on page 68 About query building in Live Office on page 66 Query fundamentals on page 64
Query fundamentals
A request can be simple, such as give me total sales in California for the first quarter of last year. Or, it can be more complex, depending on your business need. Although queries are usually sent to databases in a language called Structured Query Language (SQL), you don't have to know SQL to query for information in Live Office. The Live Office Insert Wizard presents the information available in the database as objects that have familiar names and meanings.
64
BusinessObjects Live Office XI 3. 0 User Guide
Working with Queries in Live Office Query fundamentals
5
Related Topics
· ·
What are universes?on page 66
What are universes?
In Live Office, a universe is a representation of the information available in a database and is made to answer certain types of business questions. For example, you may see a universe for sales data, one for marketing data, and one for customer service data. Universes are created by universe design specialists. The universe object appears on the Manager pane to the left of the Result Objects and Filter Objects panes in Live Office.
BusinessObjects Live Office XI 3. 0 User Guide
65
5
Working with Queries in Live Office About query building in Live Office
Note: Business users of Live Office will most likely use an existing universe
to build their queries. For existing universes, however, you may have to specify a query context to avoid returning ambiguous data from the database.
What is a prompt?
A prompt is similar to a parameter in Crystal Reports. This term refers to a dynamic filter that displays a question every time you refresh the data in a report. You respond to prompts by typing or selecting the prompt value(s) you want to view before you refresh the data. Prompts may be either mandatory or optional and are used for creating queries that can used by Live Office objects.
Related Topics
·
To specify prompt values on page 54
What is a query context?
A context is a defined group of objects in a query that share a common business purpose. Contexts are used in universes to avoid ambiguous queries, queries that contain objects that return more than one kind of information. It is possible, however, that the data you retrieve is linked to more than one query. If you were querying annual sales figures for a particular product, that information could be linked to both the Sales and Marketing databases. If more than one context exists for your data, you must specify the one you want to use.
About query building in Live Office
Below is an overview of how the Live Office Insert Wizard is used to build a query. For more detailed instructions, see Creating and running queries on page 68.
66
BusinessObjects Live Office XI 3. 0 User Guide
Working with Queries in Live Office About query building in Live Office
5
Use this page in the wizard
To do this task
· ·
Browse available universes Locate the universe you want to use. See Selecting a data source on page 69.
Choose Universe
·
Select Universe objects from the Manager pane and drag them to the Results Objects or Filter Object pane. Specify a constant value for your filter object Specify a list of values for your filter object Specify a prompt for your filter object See Building your query on page 69 and Defining your data filters on page 72.
· · ·
Specify Query
Select a query context for existing, previously defined queries. [. . . ] Users can insert a table from an existing Web Intelligence report to get the same rowset.
·
·
Unsupported features
An unsupported feature is a feature that may or may not ship with the product but for which support is no longer provided. This means that technical support calls and enhancement requests relating to this feature will no longer be accepted. The following Live Office functionality is unsupported for this version of Live Office. · In place drill functionality for both Web Intelligence and Crystal Reports rowset and report part. [. . . ]