77
528
Accessing Data and Data Analysis
Index
W
Web Connect
accessing form pages 179
accessing secured Web sites 175
adding content to a query 136
adding multiple cells in one cell 136
adding prompts to queries 124
assembling query data 122
autoqualifying cells 171
clearing data from rows 151
creating a new query 133
creating a query with prompts 192
creating Internet queries 123
creating prompts 154
creating reports in HTML 144
deleting columns 150
deleting rows 151
editing an Internet query 166
editing cells 151
generating reports 124
interpretation of separators 172
linking data to data in browser 151
making data static 151
managing queries 164
menu options 150
opening existing queries 164
pasting data into rows 151
placing data on the clipboard 151
qualifying data as details 150
qualifying data as dimensions 150
qualifying data as measures 150
query examples 183
querying multi-frame pages 169
querying pages using Basic Authentication 175
refreshing reports 124
renaming headers 150
retrieving Business Objects queries 128
retrieving corporate queries 128
retrieving HTML cell source 151
retrieving hyperlinks 151
running a query with a prompt 162
running Business Objects queries 129
running corporate queries 131
saving Internet queries 167
saving Internet query preferences 168
saving reports 149
selecting corporate queries 123
selecting the Web Connect data provider 126
setting data types as characters 150
setting data types as dates 150
setting data types as numeric 150
setting error management options 173
setting query timeout 168
using prompts with 153
Web Connect data provider 31
selecting 126
Week function
Excel equivalent 489
WordCap function
Excel equivalent 488
World Wide Web 38
X
XML
building an XML filter 106
creating a report using 106
defined 105
example of 105
setting file locations 115
XML data provider 31
XML files 37
XML query panel 113
Y
Year function
Excel equivalent 489