| < Day Day Up > |
|
fact tables
counting items in, 246
overview of, 74–76
pointing dimension objects to, 152–153
family relationships, Microsoft Analysis Services, 603–604
Fetch Duplicate Rows setting, 677
field types vs. object types, 167–169
Fill, text alignment, 457
Filter By command, InfoView, 706–707
Filter command, InfoView, 706–707
Filter Editor, 714–718
complex filters, 504
overview of, 714–715
prompt options, 716–717
WebI subqueries, 718
filters, 501–504
applying, 501
complex filters, 501–504
drill filters, 545–546, 556–558
list of values, 195–197
OLAP, 684–686
Query Filters, 714–716
refining with Add/Remove Panel, 608–609
WebI and, 671–673
Financial block type, 658
Find button, Filter Editor, 715
Fold option, tables, 467, 494
Font tab, cell formats, 457
footers
Add Page Footer setting, 677
Block Footers, 460
page breaks and, 494
Repeat Footer, 469
Show Footer, 467
ForAll context operators, 524
ForEach context operator, 524
Form block type, 659
formats
@Prompt function, 216
block settings, 678–680
cells. See Cell format pull-down menu
charts. See Chart Format dialog box
Document settings, 676–677
Enhanced document format, 647–648, 655–657
object, 178
tables. See Table Format dialog box
WebI v. 6.0 reports. See WebI (WebIntelligence) v. 6.0
formatting toolbar, 450–454
Formula Editor, 519–520, 527
Formula tab, User objects dialog box, 633–634
formulas, 518–531
concatenation, 529–530
contexts, 523–527
converting formula to variable, 523
creating variable from, 521–523
cumulative aggregates, 530–531
extended syntax of, 525–526
guidelines for creating, 520
If Then Else, 527–528
overview of, 518–520
ratios, 528–529
report variables and, 723–726
year to date measures, 529
Free-hand SQL data provider, 581
FREE value, 217
Full Description options, 378–380
| < Day Day Up > |
|