TAILIEUCHUNG - Oracle Essbase 9 Implementation Guide- P40

Oracle Essbase 9 Implementation Guide- P40: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. | Calculating your Essbase Cube If GenlevNum the specific generation or level number is o o 0 then it is using Generation reference 0 then it is using Level reference Example @ancestval total vehicle 2 total sales If current member being calculated is the STINGER COUPE then the returned member is total sales at the cars level. @parentval and @ancestval are used for one dimensional value swapping. If you want to return values from another member based on multiple dimensions then you will use the @mdparentval and @mdancsetval functions. For more information refer to the online technical reference included with your EAS software. @xref This function is used to reference data in another Essbase database. The XREF requires you to define a location alias to another database. The other database can be similar to the original database or should at least have some similar dimensions. @xref location alias memberlist For more information refer to the online technical reference included with your EAS software. location alias you need to set a location alias as shown in the steps below. member LiST this is optional you can give the list of the member names for which you need the data. The following are the easy steps required to create the very useful location alias 1. In EAS select your application and click on Action. 2. Select Edit and click on the Location Alias for ESSCAR Your Application . 3. In the Location Aliases screen give an Alias name. Select the Essbase Server Application Database User name and Password and click on the Test button. 4. Once you click on the Test button it will verify your existence on that Server or Application and the verified checkbox will be checked. Now click on the SET button to save the information as shown in the following screenshot. 5. You can click on the Delete button to delete an existing Location Alias. 180 Download at Chapter 5 Operators In calc scripts you can use all of the routine arithmetic operators like - logical .

TỪ KHÓA LIÊN QUAN
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.