TAILIEUCHUNG - Oracle Essbase 9 Implementation Guide- P84

Oracle Essbase 9 Implementation Guide- P84: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. | A New Essbase Companion Oracle Smart View Retrieving data using Smart View in Microsoft Excel Now that you have established a connection with the Essbase server you are ready to retrieve data. With Smart View you can generate reports using the Free Form or you can do your own Ad-Hoc reporting. Using the Free Form reporting option like we talked about for the Microsoft Excel Add-in you can define the row and column member names and click on the Hyperion Refresh button and you will see the data as shown in the following screenshot If you notice in the previous figure you see a small box called Book1 Sheet that is nothing but a POV Point of View . The POV has all of the page dimension information for the data you are currently looking at. Right now you are viewing data for TOTAL MARKET and you decide that you would like to see the data at a specific market level. On the POV screen you can click on the TOTAL MARKET drop-down box and then click on the . and you will see the following Member Selection screen 400 Download at Appendix In the Member Selection screen you can see all of the available members for the dimension you have selected listed in the Members list box which is on the left hand part of the Member Selection screen and you can see all of the members you have selected in the Selection list box right-hand side of the Member Selection screen . In the Member Selection screen you can also select different dimensions by clicking on the Dimension drop-down list. You can also set Filters for the members you have selected to narrow your selection further. The filter can be at the Children Descendants Level or Generation of the member you have selected. In this example we have filtered the selection by the Generation and displayed the report of all of the members in Generation 5. Select all returned members by clicking on the select all button 0 and then click on the add button to add the members into the selection list. Click on OK to return back to .

TỪ KHÓA LIÊN QUAN
TÀI LIỆU MỚI ĐĂNG
13    158    1    28-12-2024
TAILIEUCHUNG - Chia sẻ tài liệu không giới hạn
Địa chỉ : 444 Hoang Hoa Tham, Hanoi, Viet Nam
Website : tailieuchung.com
Email : tailieuchung20@gmail.com
Tailieuchung.com là thư viện tài liệu trực tuyến, nơi chia sẽ trao đổi hàng triệu tài liệu như luận văn đồ án, sách, giáo trình, đề thi.
Chúng tôi không chịu trách nhiệm liên quan đến các vấn đề bản quyền nội dung tài liệu được thành viên tự nguyện đăng tải lên, nếu phát hiện thấy tài liệu xấu hoặc tài liệu có bản quyền xin hãy email cho chúng tôi.
Đã 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.