QMIS (Quality Management Information System), 31
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
Team-Fly |