tailieunhanh - Oracle Essbase 9 Implementation Guide- P87

Oracle Essbase 9 Implementation Guide- P87:Essbase is a multidimensional database management system. The name Essbase stands for Extended Spread Sheet dataBASE. Using the custom add-in provides the end-user with near seamless compatibility in the Microsoft Excel spreadsheet program. | Essbase applications types ASO 39 BSO 40 41 Unicode applications 42 Essbase ASO. See ASO Essbase BSO. See BSO Essbase calculation script commands calc 163 push down 163 rollup 163 stomp-on 163 Essbase cascade options dialog box cascade information 272 destination options 272 format options 273 274 Essbase cell 36 file about 352-355 configuration categories 355 configuration settings 356-359 memory settings CALCLIMITFORMULARECURSION 361 DATACACHESIZE 361 DATAFILECACHESIZE 361 INDEXCACHESIZE 362 MULTIPLEBITMAPMEMCHECK 360 SSPROCROWLIMIT 360 TRIGMAXMEMSIZE 360 VLBREPORT 360 Essbase Command Script calculation script running 203 coding 204 DOS command line 205 EssCmd drag and drop 205 shell command in code 205 Essbase Command Script. See also EssCmd Essbase command scripts. See EssCmd Essbase cube 35 Essbase cube. See also Essbase database Essbase data Ad hoc data 214 analyst planning 216 217 canned reporting 214 215 data exporting 215 forecast analyst 215 216 target users 218 using 214 Essbase database budget analysts 217 calculating 156 components 47 creating 51-53 data loading 147 data load types 123 data requirements determining 32-35 data sources types 123 data types 123 financial analysts 218 using 213 Essbase database creating caches tab 55 currency tab 57 dimensions tab 54 general tab 53 modifications tab 58 statistics tab 54 55 storage tab 56 57 transactions tab 56 Essbase database MaxL commands archiving 313 commands setting 314 database altering 313 database creating 312 313 database displaying 315 database dropping 315 database renaming 314 database reseting 314 MaxL commands disabling 313 MaxL commands enabling 313 working with 311 312 Essbase database outline database block size 342 hourglass outline 340-342 shape 340 Essbase database outline building about 75 members dimensions adding steps 76 77 Essbase databases types currency database 47 normal non-currency database 47 Essbase data cell 36 37 Essbase export and import no load .