Business Information Warehouse for SAP (Prima Techs SAP Book Series)

queries, 47, 280

analytical functions, 182

analyzing, 54

analyzing data, 243-246

attaching chart, 239-240

characteristics display attribute, 238-239

CKF (Calculated Key Figures), 182-183

Columns area, 236

composing, 421

computing values for new data elements, 183

cross-InfoCube, 57

customizing display layout, 238

defining, 233, 236-239

defining dimensions and key figures, 314

defining new key figure, 182-183

deleting from instances, 130

drill-down analysis, 236

drilling down data, 244-245

edit mode, 248

executing, 233, 237

executing without BEX Browser, 50

Filter area, 237

filtering data for, 183

filtering results, 236-237

filters, 241-242

Free characteristics area, 236-237

improving performance, 338

improving response time, 278

on InfoCube and aggregate usage, 338

InfoCube data source, 237

key figures, 236

limiting scope of result set, 241

Lines area, 236

loading from business content, 182-183

navigational attributes, 243

navigational drill-down values, 243

optimization, 339-348

publishing BEX, 311

publishing on Web, 44

query cube, 55-56

reading all data, 339

reading data during navigation, 339-340

refreshing, 248

restricted key figures, 241-242

restricting data characteristics, 237

result characteristics, 236

saving current view, 237

selecting, 81

setting up query read modes, 340-341

star-joined optimization, 53

storing, 251

suppressing repeated key values and row totals, 245-246

target, 232

templates, 182

type, 237

variables, 130, 247-250

Web pages, 419

Query Builder, 234

query cubes, 55-56

memory, 56

relating to InfoCube, 57

uniqueness of, 56

query definition window, 237

query object, 314

Query Properties dialog box, 246, 248, 315

Query properties dialog box, 250

Query Properties icon, 248

Query property and variables, 250

Query View, 417