tailieunhanh - 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 .