- In the Cubeview, you are provided with a Tool bar which allows you to drill-down, retrieve data, and have an HTML view of data. - The following is an example of the tool bar. - When the member selection button is clicked, the standard member selection screen will be displayed as shown in the following screenshot:. - In the Member Selection screen (shown above), you can see that all of the members are in the usual tree format. - There are options for you to Select All of the members at one time and to Add specific members to your selection rules. - Using Member Info…, you will get the dimension name of the member, the Generation number and Level number of the selected member and you can also see the Member Formula if any. - You can also view the member names by alias by checking the Use Aliases checkbox.. - In the Preferences screen (shown below), you can set the preferences for the current cube view. - You can set up the number of Undo steps and also format the Member cells and Data cells by clicking on the Format Cells tab. - Selecting this tab in the Cubeview screen allows you to set up the data formatting properties for the current cube view grid. - Some of the properties that can be set are as follows:. - On the bottom of the Properties screen you will see two buttons, Refresh and Save. - Well, we have certainly covered a lot of ground, especially in the last couple of chapters. - By now you should have a good understanding of the what, when, how, and who, when it comes to installing, designing, building, loading, and now using an Essbase database system.. - Next up, we cover the incredible Oracle Essbase Add-in for Microsoft Excel. - If ever there was a super tool, this is it! The Essbase add-in, seamlessly installed in your Microsoft Excel spreadsheet program, gives the user one of the most powerful tools for data analytics available today. - Oh, and because we want you to be right there on top of the world of Essbase, we are also including a full section in the Appendix on Oracle Smart View. - Although not a replacement for the Essbase add-in, Smart View has many similar qualities, as well as many new and exciting features.. - Getting the most out of the Microsoft Excel Add-in. - In the real world it is no secret that a very large percentage of data and financial analysts do their jobs using Microsoft Excel. - It is also no secret that a very large percentage of these same analysts actually like Microsoft Excel very much and enjoy using it.. - This is probably why, after you tell them that they can continue to use Microsoft Excel to do their jobs even with the addition of Essbase, you will see a large smile spread across their faces. - Just wait until you tell them they can continue to use Microsoft Excel but can now perform complex data analytics and create professional looking reports by taking advantage of the easy to install and use Essbase add-in.. - Our guess is that you will be peeling them off of the ceiling.. - Get ready, because after all of the prior instruction, it is now time to actually learn how to use Essbase and the Essbase add-in to connect to the Essbase database, analyze data, modify or create data, create reports, run database calculation scripts, use the really cool Query Designer function included in the add-in, and a whole lot more.. - Reporting with the Microsoft Excel Add-in. - Assuming you have the Essbase Add-in for Microsoft Excel installed on your PC you will see the Essbase menu pick available on the main Microsoft Excel menu toolbar.. - If you read how to install the add-in but did not do it, please install it now for you will need it in this chapter.. - If you have installed the add-in but do not see the Essbase menu pick there is no need to re-install the add-in. - Occasionally the Essbase add-in will not load when you open a new instance of Microsoft Excel. - If this happens you can simply re-load the add-in by following the steps below.. - Steps to reload the Essbase Add-in into Microsoft Excel:. - In Microsoft Excel, with at least the default blank workbook open, navigate to the Add-Ins screen by clicking on Tools | Add-Ins in Microsoft Excel version 2003 and earlier or by clicking Add-Ins directly in Microsoft Excel version 2007.. - From the Add-Ins screen select the Hyperion Essbase OLAP Server DLL (non-Unicode) by checking it's box and click on OK.. - You should see the Essbase menu pick as the add-in loads and now you are again ready to use Microsoft Excel for Essbase reporting.. - If, in the Add-In selection screen, you do not see the Hyperion Essbase OLAP Server DLL(non Unicode) add-in, then follow these steps to locate the add-in xll file:. - Click on the Browse button on the Add-Ins screen.. - Browse to where you have the Essbase add-in installed
Xem thử không khả dụng, vui lòng xem tại trang nguồn hoặc xem
Tóm tắt