TAILIEUCHUNG - Oracle Essbase 9 Implementation Guide- P58

Oracle Essbase 9 Implementation Guide- P58: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. | Getting the most out of the Microsoft Excel Add-in Zooming in on sample data This function allows you to return only sample subsets of the actual data that a retrieve may return. The Essbase Sample Data Zoom In function depends on how you have two Essbase Options set. First is the sampling percentage setting on the Zoom tab of the Essbase Options screen. Whatever percentage this is set to is the amount of data which will be returned when you Zoom In using this function. How much you Zoom In is determined by the Zoom setting also on the Zoom tab of the Essbase Options screen. For example if you click on a member name on your spreadsheet and then click the Sample Data Zoom In function your data will be returned as follows Let s say there are 200 children members under the member you selected for the Sample Data Zoom In function and your Zoom In function is set to Bottom Level and your Sampling setting is set to 100 . This Zoom In will return all 200 children members into your spreadsheet. Let s now say that you have the Zoom In function still set to Bottom Level but this time you have the Sampling setting set to 10 . This Zoom In will only return the first 20 children members into your spreadsheet. These 20 members are 10 of the 200 that are available. The Sample Data Zoom In function works very well for Zoom Ins on particularly large dimensions if you are just checking the data and do not need to see all of it. Linking objects to your data In Essbase it is possible to link an object such as a file object to a specific data cell in the database. This object can contain information or explanations on or about the data or it can be whatever you want it to be. The Essbase Linked Objects. command displays the Linked Objects Browser dialog box. The Linked Objects Browser allows you to create or access linked objects and displays the objects currently linked to the data cell you have selected. 270 Download at Chapter 7 You cannot create linked objects for member

TỪ KHÓA LIÊN QUAN
TÀI LIỆU MỚI ĐĂNG
Đã 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.