Arrow Storage Products EN106 Guia do Utilizador Página 195
- Página / 200
- Índice
- MARCADORES
Avaliado. / 5. Com base em avaliações de clientes
on to a relational data source, 177
on to Essbase. See connecting
on to Integration Server, 177
logging data updates from spreadsheet, 149
logical operators, 83
logouts, forced or auto, 88
M
macro functions
EssCell, 114
Spreadsheet Toolkit, 14, 26
main menu (Essbase), 23
manual calculation mode, 116
Member Information dialog box, 81
member names
aliases for, 61
alternate. See aliases
applying styles, 55
displaying with aliases, 62
entering in spreadsheet, 122, 124
formatted sheets, 104
indenting, 19
repeating, 63
with EssCell function, 115
Member Preview dialog box, 84, 85
Member Retention option, 42
Member Selection button, 26
Member Selection command, 81
Member Selection dialog box, 81
Member Selection Preview dialog box, 73
Member Selection, with Query Designer, 70
members
adding, 70
aliases for, 61
ancestors, 18
applying styles, 55, 57
children, 18
collapsing, 41
defined, 18
deleting, 49
descendants, 18
deselecting, 86
drilling down on, 38, 39
drilling up on, 41
Dynamic Calculation, 117
Dynamic Time Series, 119
finding, 80, 82
generations, 18
levels, 18
names. See member names
parents, 18
retaining, 47
selecting, 70
, 80
siblings, 18
menu, Essbase, 23
messages (Essbase)
database calculation status, 150
display options, 108
EssCell, 116
unknown member, 106
metadata sampling, 103
migrating to current release, 7
missing values, suppressing, 53
disabled, 109
in cascaded sheets, 154
option unavailable, 109
Mode page (Essbase Options dialog box), 30, 93, 109
money. See currency conversions
mouse actions, enabling, 26
moving
rows and columns. See pivot
through worksheets, 49
multi-cell selection, with drill-through, 172
multidimensional databases. See databases
multiple cell selection, with drill-through, 172
multiple filter conditions, in drill-through reports,
184
N
names
alternate. See aliases
applying styles, 55
displaying with aliases, 62
entering generation, 128
entering level, 128
repeating, 63
Navigate With or Without Data button, 25
Navigate Without Data command, 49, 52
nested columns or rows, 38
networks, 13
Next Level option, 42, 151
nonadjacent cells, 48
notes, linking to data cells, 137
null values, 115
ABCDEFGHI KLMNOPQRSTUVWXZ
Index
195
- SPREADSHEET ADD-IN 1
- USER’S GUIDE FOR EXCEL 1
- Contents 3
- Introduction to Release 9.3.1 7
- New Features in Release 7.x 8
- Visual Explorer 9
- Support for Excel 2003 9
- Metadata Sampling 9
- Support for Excel 2002 10
- Introduction to Essbase 11
- Typical Users of Essbase 12
- The Server 13
- Essbase Spreadsheet Add-in 13
- The Network 13
- Essbase Application Products 14
- The Multidimensional Database 15
- Database Outlines 17
- Attributes 19
- Formulas 19
- Consolidations 19
- Basic Tutorial 21
- Adding Spreadsheet Add-in 22
- Starting Spreadsheet Add-in 23
- Using the Essbase Toolbar 24
- Accessing Online Help 26
- Enabling Mouse Actions 26
- Select Essbase > Options 27
- 4 Select the Zoom tab 30
- 8 Select the Global tab 31
- Retrieving Data 33
- Changing a Password 35
- Drilling Down to More Detail 38
- 3 Release the Alt key 39
- Drilling Up to Less Detail 41
- ➤ To drill up only on Qtr1: 43
- Pivoting Rows and Columns 44
- 1 In cell A2, select Actual 46
- Retaining a Data Subset 47
- 2 Select Qtr2 in cell E2 48
- Removing a Data Subset 49
- Characters 52
- ● Zero data values 53
- Formatting Text and Cells 55
- Figure 45 Font Dialog Box 56
- Formatting the Worksheet 57
- Applying Styles to Data Cells 59
- Removing Styles 60
- 6 Click OK 62
- Repeating Member Labels 63
- An Example Scenario 66
- Creating Queries 68
- Saving Queries 74
- Click the File System button 75
- Applying Queries 76
- Deleting Queries 77
- Accessing Help 78
- Designer 78
- Selecting Members 80
- (see Figure 78) 86
- Saving and Disconnecting 87
- On to Advanced Tasks 88
- Figure 88 Data Filter Panel 95
- 500 in the value text box 97
- Figure 90 Data Filtering 98
- Sorting Data 99
- Advanced Tutorial 100
- 1 Select File > Open 102
- Retrieving a Range of Data 112
- Select Essbase > Retrieve 115
- Table 4 EssCell Messages 117
- ➤ To view the Asymm.xls file: 118
- Using Substitution Variables 121
- Using Free-Form Mode 124
- 1 Open a worksheet 131
- Linking a File to a Data Cell 134
- Figure 142 Linking a File 135
- ➤ To apply styles: 136
- Linking a URL to a Data Cell 138
- Figure 150 139
- Accessing a Linked File 140
- Accessing a Linked Cell Note 141
- Accessing a Linked URL 143
- Updating Data on the Server 147
- Database Calculation 149
- Caution! 150
- BUD in the Prefix text box 152
- Select Essbase > Connect 156
- Convert.xls file: 158
- Using Drill-Through 161
- Before You Start 163
- Setting Essbase Options 165
- 6 Select the Mode tab 166
- 8 Select the Style tab 166
- 10 Select the Global tab 167
- 5 Click Customize 178
- Ordering Data 180
- Filtering Data 182
- Disconnecting from Essbase 187
- ABCDEFGHI KLMNOPQRSTUVWXZ 189
© 2020, manymanuals-pt.com. Todos os direitos reservados. | 0.129 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentários a estes Manuais