Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
Oracle Essbase 9 Implementation Guide- P3: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. | Table of Contents Date and Time 186 Miscellaneous 186 Order of calculation 187 Two-Pass Calc 189 Using Substitution Variables 191 Substitution Variables using EAS 192 Substitution Variables using MaxL 194 Create variables at the server level 195 Create variables at the application level 195 Create variables at the database level 196 Displaying the Substitution Variable and its value 196 Displaying the Substitution Variable in the SQL editor 198 Building your first Calculation Script 199 Writing and saving a Calculation Script 200 Executing your Calculation Scripts 201 Running Calculation Scripts manually using EAS 201 Running a Calculation Script using an Essbase Command Script EssCmd 203 What the EssCmd script looks like 204 Running a Calculation Script using a MaxL Script 205 Running a Calculation Script using the Essbase API 208 Running a Calculation Script from Microsoft Excel 209 Running a Calculation Script through the Essbase Add-In 210 Running a Calculation Script using Microsoft Excel VBA 211 Summary 212 Chapter 6 Using your Essbase Cube 213 Using your Essbase database 213 How do you use your data in the real world 214 Ad hoc data 214 Canned reporting 214 Export data 215 Forecast analysts 215 Planning analysts 216 Budget analysts 217 Financial analysts 218 The real target users of your Essbase data 218 Ways to extract your Essbase data 218 The Essbase Report Script 220 How to create an Essbase Report Script 221 Report script commands and functions 223 Report layout commands 224 Data range commands 225 Data ordering command 226 Member selection and sorting commands 226 -------------------------------------- v -------------------------------------- Download at Boykma.Com Table of Contents Format commands 227 Column or row calculation 228 Member names and aliases 230 Building your first Essbase report script 230 Executing your report scripts 234 Run reports using EAS 235 Running a report script using an Essbase command script 236 Running calc using a MaxL .
