SAP Business objects Enterprise XI 3.1 Building reports using the Web Intelligence HTML Report Panel
Building reports using the Web
Intelligence HTML Report Panel
BusinessObjects Enterprise XI 3.0
Copyright
© 2008 Business Objects, an SAP company. All rights reserved. Business Objects
owns the following U.S. patents, which may cover products that are offered and
licensed by Business Objects: 5,295,243; 5,339,390; 5,555,403; 5,590,250;
5,619,632; 5,632,009; 5,857,205; 5,880,742; 5,883,635; 6,085,202; 6,108,698;
6,247,008; 6,289,352; 6,300,957; 6,377,259; 6,490,593; 6,578,027; 6,581,068;
6,628,312; 6,654,761; 6,768,986; 6,772,409; 6,831,668; 6,882,998; 6,892,189;
6,901,555; 7,089,238; 7,107,266; 7,139,766; 7,178,099; 7,181,435; 7,181,440;
7,194,465; 7,222,130; 7,299,419; 7,320,122 and 7,356,779. Business Objects and
its logos, BusinessObjects, Business Objects Crystal Vision, Business Process
On Demand, BusinessQuery, Cartesis, Crystal Analysis, Crystal Applications,
Crystal Decisions, Crystal Enterprise, Crystal Insider, Crystal Reports, Crystal
Vision, Desktop Intelligence, Inxight and its logos , 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. SAP is the trademark or registered
trademark of SAP AG in Germany and in several other countries. All other names
mentioned herein may be trademarks of their respective owners.
Third-party
Contributors
Business Objects products in this release may contain redistributions of software
licensed from third-party contributors. Some of these individual components may
also be available under alternative licenses. A partial listing of third-party
contributors that have requested or permitted acknowledgments, as well as required
notices, can be found at: http://www.businessobjects.com/thirdparty
2008-09-03
Contents
About Web Intelligence 11Chapter 1
How Web Intelligence performs business intelligence over the web.........12
How Web Intelligence performs business intelligence offline....................12
Interacting with Web Intelligence reports...................................................12
Creating and editing Web Intelligence documents....................................14
Accessing Web Intelligence from InfoView 17Chapter 2
To log in to InfoView...................................................................................18
To log out of InfoView................................................................................19
Web Intelligence InfoView options.............................................................19
Viewing and printing Web Intelligence reports.....................................13
Drilling on Web Intelligence reports......................................................13
Performing on-report analysis..............................................................13
Web Intelligence Query - HTML...........................................................14
Web Intelligence Java Report Panel....................................................15
Web Intelligence Rich Client................................................................15
Web Intelligence HTML Report Panel..................................................16
Web Intelligence document creation and viewing options...................19
To set Web Intelligence drill options.....................................................22
Web Intelligence locale options............................................................24
Creating and editing documents 29Chapter 3
To build and run a query in the HTML Report Panel.................................30
To edit a Web Intelligence document with the HTML Report Panel..........30
Building reports using the Web Intelligence HTML Report Panel 3
Contents
Building and editing queries 33Chapter 4
Creating, editing and saving documents...................................................34
To select a universe..............................................................................34
To edit a Web Intelligence document...................................................34
How universe objects map to data............................................................35
Classes and subclasses.......................................................................35
Dimension object..................................................................................35
Detail object..........................................................................................35
Measure object.....................................................................................36
Building queries.........................................................................................36
To build and run a query in the HTML Report Panel............................36
To add objects to a query in the HTML Report Panel..........................37
To remove objects from a query in the HTML Report Panel................37
To set query properties in the HTML Report Panel..............................37
Controllling how queries retrieve data.......................................................38
Max retrieval time query property.........................................................38
Max rows retrieved query property.......................................................38
Retrieve duplicate rows query property................................................39
Setting the scope of analysis.....................................................................39
Scope of analysis.................................................................................39
Levels of scope of analysis..................................................................40
To set the scope of analysis in the HTML Report Panel......................41
Query contexts...........................................................................................41
What is an ambiguous query?..............................................................41
What is a context?................................................................................41
To choose a context when you run a query..........................................42
Choosing a context when you run a query...........................................42
Reset contexts on refresh query property............................................42
Using queries.............................................................................................43
To run a query......................................................................................43
4 Building reports using the Web Intelligence HTML Report Panel
Contents
To interrupt a query..............................................................................44
To remove a query................................................................................44
Table types in Web Intelligence 45Chapter 5
Vertical table..............................................................................................46
Horizontal table..........................................................................................46
Crosstab....................................................................................................47
Forms.........................................................................................................48
Allocating data to tables 49Chapter 6
To select a table or chart template.............................................................50
To add an object to a table.........................................................................51
To remove an object from a table..............................................................52
To reposition an object on a table..............................................................52
To reorder the columns or rows on a table................................................53
Chart types in Web Intelligence 55Chapter 7
Bar charts..................................................................................................56
Line charts.................................................................................................56
Area charts................................................................................................56
Pie charts...................................................................................................57
Radar, polar and scatter charts.................................................................57
3D charts...................................................................................................58
2D charts...................................................................................................59
Allocating data to charts 61Chapter 8
To add objects to chart axes......................................................................62
To remove an object from a chart axis.......................................................62
To reposition objects on a chart axis.........................................................63
Building reports using the Web Intelligence HTML Report Panel 5
Contents
Grouping information with sections 65Chapter 9
To create a section on a report..................................................................68
To create a subsection on a report............................................................68
To remove a section from a report.............................................................69
To change the order of sections on a report..............................................70
Multi-report documents 73Chapter 10
To insert a report........................................................................................74
To duplicate a report..................................................................................75
To rename a report....................................................................................75
To move a report........................................................................................76
To delete a report.......................................................................................77
Saving documents 79Chapter 11
To save Web Intelligence documents in InfoView......................................80
To save updates to a document that has already been saved..................80
To save a document with a new name or to a new category.....................81
Sorting the results displayed on reports 83Chapter 12
Sorting data in tables 85Chapter 13
To sort values on a table............................................................................87
To prioritize multiple sorts on a table.........................................................88
Applying sorts to sections 91Chapter 14
To sort values in a section.........................................................................92
6 Building reports using the Web Intelligence HTML Report Panel
Contents
Breaks 93Chapter 15
Breaks defined...........................................................................................94
Breaks compared to sections....................................................................94
Default sort order in breaks.......................................................................94
To insert a break........................................................................................95
Break properties........................................................................................95
To set break properties.........................................................................96
Using standard calculations in reports 97Chapter 16
Standard calculations................................................................................98
To insert or remove a calculation...............................................................99
The Result Preview pane 101Chapter 17
Defining page size, orientation and margins 105Chapter 18
To select the paper size...........................................................................106
To select the page orientation..................................................................106
To set margins.........................................................................................107
Displaying report titles 109Chapter 19
To display the report title..........................................................................110
Aligning tables and charts on the report page 111Chapter 20
To position a block on a report.................................................................112
Formatting sections 113Chapter 21
To format a section..................................................................................114
To format a section cell............................................................................114
Building reports using the Web Intelligence HTML Report Panel 7
Contents
To set the page layout for a section.........................................................115
Formatting page headers and footers 117Chapter 22
To display or hide a header or footer.......................................................118
To specify cell contents for headers and footers.....................................118
To set the height and background color of headers and footers..............119
To format a page header or footer cell.....................................................119
Formatting hyperlinks 121Chapter 23
To format hyperlinks.................................................................................122
Formatting vertical and horizontal tables 123Chapter 24
Formatting options for vertical and horizontal tables...............................124
To format a table......................................................................................124
Formatting crosstabs 125Chapter 25
Formatting options for crosstabs.............................................................126
To format a crosstab...........................................................................126
To display headers in a crosstab........................................................127
To center column values on a crosstab header..................................127
Formatting forms......................................................................................128
Formatting options for forms..............................................................128
Formatting charts in the HTML Report Panel 131Chapter 26
Formatting options available for charts....................................................132
Formatting options for 2D bar charts..................................................132
Formatting options for 3D charts........................................................133
Formatting options for pie charts........................................................133
Personalizing chart formats.....................................................................134
8 Building reports using the Web Intelligence HTML Report Panel
Contents
Chart formatting options.....................................................................134
Formatting chart axes.........................................................................140
Keyboard shortcuts for accessibility in the HTML Report Panel 145Chapter 27
Configuring JAWS...................................................................................146
Logging in and selecting the HTML Report Panel as your document
editor........................................................................................................146
To log in to InfoView...........................................................................146
To select the HTML Report Panel as your document editor...............147
Creating and editing Web Intelligence documents..................................148
To create a new Web Intelligence document......................................148
To edit a Web Intelligence document.................................................148
Navigating the HTML Report Panel frames.............................................149
Overview of the browser window frames...........................................149
Navigating between the report panel tabs..........................................152
Selecting a tab....................................................................................152
Using the Back and Next buttons to navigate between tabs..............153
Navigating the Query tab....................................................................153
Navigating the Properties tab.............................................................158
Navigating the Format tab..................................................................162
Logging out.........................................................................................164
Third party shortcuts................................................................................164
Get More Help 165Appendix A
Index 169
Building reports using the Web Intelligence HTML Report Panel 9
Contents
10 Building reports using the Web Intelligence HTML Report Panel
About Web Intelligence
1
About Web Intelligence
1
How Web Intelligence performs business intelligence over the web
How Web Intelligence performs business
intelligence over the web
Web Intelligence provides business users an easy to use interactive and
flexible user interface for building and analyzing reports on corporate data
over the web, on secured intranets and extranets. The Web Intelligence
software is installed by your administrator on a web server on your corporate
network.
To use Web Intelligence from your local computer, you log into the business
intelligence portal InfoView via your Internet browser. Then, depending on
your security profile, you can interact with the reports in corporate documents
or edit or build your own documents using a Web Intelligence report panel
or query panel.
How Web Intelligence performs business intelligence offline
Web Intelligence can be used offline as Web Intelligence Rich Client, a
standalone Microsoft Windows application, equivalent to the Java Report
Panel, that you can install on your computer. Web Intelligence Rich Client
lets you continue to work with Web Intelligence (WID) documents when you
are unable to connect to a CMS, when you want to perform calculations
locally rather than on the server, and when you want to work with Web
Intelligence documents without installing a CMS or application server.
Web Intelligence Rich Client can also be used when connected to a CMS.
Interacting with Web Intelligence reports
Depending on your security profile and on how Web Intelligence is deployed
across your organization, you can view, analyze, or enhance and modify the
data displayed on reports.
12 Building reports using the Web Intelligence HTML Report Panel
About Web Intelligence
Interacting with Web Intelligence reports
Viewing and printing Web Intelligence reports
Once logged into the business intelligence portal InfoView, you can access
Web Intelligence documents and view reports. Onscreen navigation is made
easy with page-to-page navigation buttons and a document map that allows
you to jump from section to section or report to report.
The same document can provide the information adapted to each user due
to prompts that request each user, who opens the document, to specify the
data they want to return to the reports.
When you print reports, Web Intelligence automatically generates a copy of
reports in Portable Document Format (PDF) format for optimum print quality.
Drilling on Web Intelligence reports
Drilling on Web Intelligence reports enables you to analyze the detailed data
behind the displayed results. You can turn the report you are viewing into a
drillable report or drill on a duplicate of the original report to retain a version
of the results before your drill analysis.
1
Once you have found the information you need, you can save a snapshot
of the drilled report to share the results of your analysis with other Web
Intelligence users, or save the document in Excel or Portable Document
(PDF) format to print or email to other business contacts.
Performing on-report analysis
Viewing Web Intelligence reports in Interactive view format enables you to
enhance reports and fine-tune the data reports contain, to highlight the
information that most interests you on demand.
On-Report Analysis is designed for:
• users who need to build queries and then want to build reports
• report consumers who need to manipulate the reports created by others
With On-Report Analysis you can:
Building reports using the Web Intelligence HTML Report Panel 13
About Web Intelligence
1
Creating and editing Web Intelligence documents
• view document metadata to understand the data behind reports and see
how reports are structured and filtered
• filter and sort results
• add new tables and charts
• add formulas and create variables
• format and change the layout of charts and tables
• slice and dice results by adding other data to charts and tables
Note:
On-report analysis of Web Intelligence reports in Interactive view format is
only available if your administrator has deployed Web Intelligence in JSP
mode.
Creating and editing Web Intelligence
documents
You can create or edit Web Intelligence documents using several tools:
•
Web Intelligence Query - HTML on page 14
•
Web Intelligence Java Report Panel on page 15
•
Web Intelligence Rich Client on page 15
•
Web Intelligence HTML Report Panel on page 16
Web Intelligence Query - HTML
Designed for users requiring a pure HTML environment to build queries,
Web Intelligence Query – HTML offers the ability to define the data content
of documents on multiple data sources. You can use Query – HTML to create
new documents from scratch or edit the queries in documents created using
any of the other Web Intelligence tools.
Used together with On-Report Analysis, Query – HTML provides a complete
solution for building queries and designing powerful reports in a pure HTML
environment. Once you have run the queries to generate a standard report,
you can leverage Web Intelligence On-Report Analysis features to format
multiple reports, add formulas, and create variables.
14 Building reports using the Web Intelligence HTML Report Panel
Creating and editing Web Intelligence documents
Note:
Web Intelligence Query – HTML and On-Report Analysis in Interactive view
format are only available, if your administrator has deployed Web Intelligence
in JSP mode.
Web Intelligence Java Report Panel
The Java Report Panel is designed for users who need more flexibility with
designing report layout and defining formulas and variables. A graphical
Formula Editor enables you to build formulas rapidly using drag-and-drop.
Note:
The Web Intelligence Java Report Panel is available if your administrator
has deployed Web Intelligence in ASP mode and if your administrator has
deployed Web Intelligence in JSP mode.
Web Intelligence Rich Client
About Web Intelligence
1
Web Intelligence Rich Client is a locally installed Microsoft Windows
application that lets you work with Web Intelligence (WID) documents that
are stored locally or in a CMS.
When working without a CMS connection you can work on your local machine
with either CMS-secured or unsecured documents.
Web Intelligence Rich Client is based on the Web Intelligence Java Report
Panel and provides equivalent document creation, editing, formatting, printing
and saving capabilities.
There are a number of reasons for using Web Intelligence Rich Client to
work with WID documents:
• You want to work with Web Intelligence documents but you are unable
to connect to a CMS (while traveling, for example).
• You want to improve calculation performance: Web Intelligence Rich
Client performs calculations locally, rather than on the server, and local
calculations can perform better than server calculations.
• You want to work with Web Intelligence documents without installing a
CMS or application server.
Building reports using the Web Intelligence HTML Report Panel 15
About Web Intelligence
1
Creating and editing Web Intelligence documents
Web Intelligence HTML Report Panel
Designed for users who need to build basic reports, the HTML Report Panel
provides query and report features in a simple wizard-like interface. Each
document is based on a single data source and can contain multiple reports,
displaying different subsets of information.
In addition, the HTML Report Panel is 508 compliant and can be customized
for specialized deployments.
Note:
The Web Intelligence HTML Report Panel is only available if your
administrator has deployed Web Intelligence in JSP mode.
16 Building reports using the Web Intelligence HTML Report Panel
Accessing Web Intelligence from InfoView
2
Accessing Web Intelligence from InfoView
2
To log in to InfoView
You access Web Intelligence reports and set global Web Intelligence options
from InfoView, the corporate business intelligence portal.
To log in to InfoView
Before you can use InfoView and Web Intelligence you need the following
information:
• a URL to the InfoView server
• the InfoView server name and port number
• your login and password
• your authentication, which controls the InfoView resources available to
you
Contact your adminstrator for these details if you do not already know them.
Note:
By default the InfoView server name and authentification method are not
displayed on the InfoView logon page. You need to supply this information
only if your administrator has made these options visible.
You access Web Intelligence by using your web browser to log into InfoView,
the corporate business intelligence portal. Once you are in InfoView, you
can analyze and enhance Web Intelligence reports.
1. Launch your web browser.
2. Point your browser to the InfoView bookmark or URL.
The InfoView login page appears.
3. If the System box is blank, type the name of the InfoView server followed
by a colon (:), and then type the port number.
4. In the Username box, type your user name.
5. In the Password box, type your password.
6. In the Authentication box, select the authentication provided to you by
your administrator.
7. Click Log On.
The InfoView home page appears.
18 Building reports using the Web Intelligence HTML Report Panel
Accessing Web Intelligence from InfoView
To log out of InfoView
To log out of InfoView
When you finish using InfoView or Web Intelligence you need to log out,
instead of simply closing your web browser.
Logging out of InfoView ensures that any preferences you modified during
your InfoView session are saved. It also lets your administrator track how
many users are logged into the system at any given time and thus optimize
InfoView and Web Intelligence performance.
• Click Log Out.
The login page appears. You are logged out of InfoView
Web Intelligence InfoView options
Web Intelligence document creation and viewing options
2
You can set your Web Intelligence options to determine how you create,
view and interact with documents using Web Intelligence.
You create documents using a query editor to build the query to retrieve the
document data. After the query returns the data to the document, you can
view and interact with the data.
Building reports using the Web Intelligence HTML Report Panel 19
Accessing Web Intelligence from InfoView
2
Web Intelligence InfoView options
Advanced
DescriptionDocument creation option
You create documents using the
Java Report Panel, a Java applet
than launches in your Web browser.
The Java Report Panel is a combined query building, report editing
and data analysis environment. If
you choose Advanced as your
document creation option, you also
use the Java Report Panel for
working with the data returned by
the query. The Select a default
view format option is not taken into
account.
The Java Report Panel provides
the richest feature set of all Web
Intelligence query building, report
editing and data analysis environments.
Interactive
Desktop
Web Accessibility
20 Building reports using the Web Intelligence HTML Report Panel
You build queries using Query HTML, an HTML-based query editor.
You build queries, edit reports and
analyze data using Web Intelligence Rich Client, a standalone
version of the Java Report Panel
that runs outside your web browser.
You create documents using the
HTML Report Panel, a 508-compliant
query-building and report-viewing
environment.
Accessing Web Intelligence from InfoView
Web Intelligence InfoView options
You can use the following view formats to view and interact with existing
Web Intelligence documents, or documents that you have just created using
a query editor:
DescriptionView format
Use Web (HTML) format when you
Web
Interactive
want to open reports, answer prompts,
navigate reports, and/or perform drill
analysis.
Use Interactive format when you
want to apply filters, sorts, calculations, modify formatting and data
displayed on tables and charts,
and/or perform drill analysis.
Use Interactive format if you are using Query – HTML to define queries,
and you want to format reports based
on those queries and add formulas
and variables.
2
Interactive view format is only available if your administrator has deployed Web Intelligence in JSP
mode.
PDF
Use PDF mode when you want to view
static reports.
To select the Web Intelligence query editor
1. Click the Preferences button on the InfoView toolbar.
2. Click Web Intelligence Preferences to display the Web Intelligence
options.
3. Select the query editor beneath Select a default creation/editing tool.
4. Click OK.
Building reports using the Web Intelligence HTML Report Panel 21
Accessing Web Intelligence from InfoView
2
Web Intelligence InfoView options
To select the Web Intelligence view format
You can select different view formats for Web Intelligence documents
depending on how you want to interact with the information displayed on the
reports. You select your Web Intelligence view options in InfoView. When
you modify your view options, the new settings are implemented the next
time you open a Web Intelligence document.
1. Click the Preferences button on the InfoView toolbar.
2. Click Web Intelligence Preferences to display the Web Intelligence
options.
3. In the Select a view format section, select the view format.
To select a default universe for new documents
1. Click Preferences on the Infoview toolbar.
2. ClickWeb Intelligence Preferences to display the Web Intelligence
options.
3. Click Browse beneath Select a default universe and browse to the
universe you want to select as the default.
To set Web Intelligence drill options
Drilling on reports lets you look deeper into data to discover the details behind
a good or bad summary result displayed on a table, chart, or section. Before
you begin a drill session, you can set your drill options in InfoView to specify
how reports will change each time you drill.
1. Click Preferences on the Infoview toolbar.
2. Click Web Intelligence Preferences to display the Web Intelligence
options.
3. Select the drill options under Drill options and Start drill session.
22 Building reports using the Web Intelligence HTML Report Panel
Hide drill toolbar option
When you drill on a value displayed on a report, the Drill toolbar appears
and displays the value on which you drilled. The value displayed on the
toolbar filters the results displayed on the drilled report.
For example, if you drill on year 2001, the results displayed on the drilled
table are Q1, Q2, Q3, and Q4 for year 2001. This means that the quarterly
values you drilled to are filtered by 2001.
Note:
If the drilled report includes dimensions from multiple queries, a ToolTip
appears when you rest your cursor on the value displayed on the filter. The
ToolTip displays the name of the query and the dimension for the value.
The Drill toolbar allows you to select alternative values on the same level,
in order to filter the results differently. For example, if you use the Drill toolbar
illustrated above to select “2002,? the results displayed on the drilled table
would be Q1, Q2, Q3, and Q4 for year 2002.
You can opt to hide the Drill toolbar when you start drill mode. The Drill
toolbar is only useful if you want to select filters during your drill session.
Accessing Web Intelligence from InfoView
Web Intelligence InfoView options
2
Prompt when drill requires additional data option
When you drill the results displayed on a Web Intelligence report, you may
want to drill to higher- or lower-level information that isn’t included in the
scope of analysis for the document. When this is the case, Web Intelligence
needs to run a new query to retrieve the additional data from the data source.
Since queries on large selections of data may take a long time to be
completed, you can choose to be prompted with a message every time a
new query is necessary. The prompt message asks you whether you want
to run the additional query or not. In addition, the prompt lets you apply filters
to the extra dimensions you include in the new query. This means you can
restrict the size of the query to only the data necessary for your analysis.
You need permission from your administrator to drill out of the scope of
analysis during a drill session.
Building reports using the Web Intelligence HTML Report Panel 23
Accessing Web Intelligence from InfoView
2
Web Intelligence InfoView options
Synchronize drill on report blocks option
When you select the Sychronize drill on all report blocks option, the display
of all blocks changes to correspond with your drill actions. For example, if
you drill down on a block from year to quarter, and your report also contains
a chart showing data by year, the chart display also changes to display data
by quarter.
If you do not select the option, only the drilled block changes in response to
drill actions.
Start drill session option
The Start drill session option controls how Web Intelligence behaves when
you start drill mode.
Start drill session on existing report option
When you select Start drill session on existing report, the current report
becomes drillable when you start drill mode. When you end drill mode, the
report displays the drilled values.
Start drill session on a duplicate report option
When you select Start drill on a duplicate report, Web Intelligence creates
a duplicate of the current report when you start drill mode, and you drill on
the duplicate. This allows you to compare the results of the original report
with the results you discover during your drill analysis.
Web Intelligence locale options
The locale determines how a Web Intelligence document displays data. It
affects, for example, the formatting of numbers and the default sort order.
Three locale settings combine to determine how Web Intelligence displays
data:
24 Building reports using the Web Intelligence HTML Report Panel
Accessing Web Intelligence from InfoView
Web Intelligence InfoView options
DescriptionLocale
2
Product locale
Document locale
Preferred viewing locale
Related Topics
• To permanently associate a locale with a document on page 26
The product locale
The product locale is the locale that InfoView uses by default. You set the
product locale in the Infoview General preferences.
To set the product locale
1. Click Preferences on the main InfoView toolbar.
2. Click General to display the general options.
3. Select the product locale from the Product locale list.
The locale in which InfoView displays
data by default.
The locale associated with a particular
Web Intelligence document. When you
save a document, the document locale
becomes the current product locale or
the preferred viewing locale.
You can permanently associate a locale with a document.
The locale in which you choose to view
documents
The document locale
The document locale is the locale associated with a particular document. By
default, the document takes the product locale when you save a document,
or the preferred viewing locale if this is different from the product locale and
your settings give the preferred viewing locale priority. The document retains
this locale until the next time it is saved, when it again takes either the product
locale or the preferred viewing locale.
Building reports using the Web Intelligence HTML Report Panel 25
Accessing Web Intelligence from InfoView
2
Web Intelligence InfoView options
Note:
The GetContentLocale Web Intelligence function returns the document
locale.
Related Topics
• To permanently associate a locale with a document on page 26
To display data using the document locale
1. Click Web Intelligence Preferences to display the Web Intelligence
options.
2. Click Use the document locale to format the data beneath When
viewing a document.
The preferred viewing locale
The preferred viewing locale is the locale that you choose to dislay data. The
preferred viewing locale overrides the product locale if it is different from the
product locale and your settings give the preferred viewing locale priority.
To set the preferred viewing locale
1. Click Preferences on the main InfoView toolbar.
2. Click General to display the general options.
3. Select the preferred viewing locale from the Preferred viewing locale
list.
4. Click Web Intelligence Preferences to display the Web Intelligence
options.
5. If you want data to be formatted using the preferred viewing locale, click
Use my Preferred Viewing Locale to format the data beneath When
viewing a document.
To permanently associate a locale with a document
1. In Web Intelligence Interactive, select Document > Properties from the
menu to display the" Document Properties" dialog box.
2. Select Permanent regional formatting.
3. Save the document.
26 Building reports using the Web Intelligence HTML Report Panel
Accessing Web Intelligence from InfoView
Web Intelligence InfoView options
The current document locale is associated permanently with the document
and overrides the product locale and the preferred viewing locale.
2
Building reports using the Web Intelligence HTML Report Panel 27
Accessing Web Intelligence from InfoView
Web Intelligence InfoView options
2
28 Building reports using the Web Intelligence HTML Report Panel
Creating and editing documents
3
Creating and editing documents
3
To build and run a query in the HTML Report Panel
To build and run a query in the HTML
Report Panel
1. Click the + sign next to a class folder in the Universe Objects pane.
The class expands to show the objects that belong to the class.
2. Double-click an object in the Universe Objects pane; or Drag an object
from the Universe Objects pane and drop it onto the Result Objects
pane; or select an object on the Universe Objects pane, then click >>.
3. Repeat the previous step for every object you want to include in the query.
4. The next step depends on whether you want to generate a default
formatted report immediately to view the results or whether you want to
design the document structure now and then generate the results with
your personalized formatting.
DescriptionOption
Click Run.
Click the Report tab at the top of
the HTML Report Panel, specify
the structure of the document, and
then click Run.
Do this to display the results corresponding to the query definition in a
vertical table, containing data for all
of the objects included on the query.
Do this to select a specific table or
chart template for the data or insert
additional reports and then allocate
a sub-set of the query data to each
report.
To edit a Web Intelligence document with the HTML Report Panel
Depending on your security profile, you can edit how results appear on report
tables and charts or edit the queries that make up the data definition of
documents.
1. Make sure you are logged into InfoView.
2. On the InfoView home page, navigate to the document you want to open.
30 Building reports using the Web Intelligence HTML Report Panel
Loading...