As you can imagine, the possibilities of using Discoverer's data analysis tools are limitless. Writing this blog post, because I m still getting some requests about it, so I feel that this subject needs a clarification. I read several notes about upgrade discoverer. You should save your workbooks in database. Oracle application server 10g Release 2 10. By duplicating your table as a crosstab, Discoverer calculates a subtotal of the profit for each region, as shown below. Like Page Items, axis Items are special Items on a Worksheet.
Page 3 of the Export Wizard lets you choose whether to monitor the export process. Discoverer gives you another tool, parameters, which gives you and other users a choice of filters when a Workbook opens. In lesson 3 you will use these data analysis tools to help you arrive at a business decision. You first need to miigrate from Discoverer 3i to 4i and then Discoverer 4i to 10g. If you don't see any percentages listed, no one has created any yet. On a Worksheet, a Page Item appears above all the other column headings.
Proceed with the following steps to allow AutoConfig to switch profile options for your remote, standalone Oracle Business Intelligence 10g Release 2 server: Edit the AutoConfig context file. When specifying a Web server name, you must use its fully qualified host name including port number if necessary. The latest patch information is listed in , Discoverer 4i with Oracle Applications 11i under Section 5: Installation Tasks. If your client no longer want to buy Noetix views. In Lesson 1, you will look at the Discoverer work area and learn the names of Discoverer components that you see on screen, and learn how to use them. However, you use the Edit Worksheet dialog after you have already chosen some initial data with the Workbook Wizard.
When you change to another Workbook, its name appears in brackets so that you can keep track of which Workbook you are using. Similarly, if the Preferences component goes down, the Locator component will continue to function and sessions already in progress are not affected. For almost every business question, there is a way to analyze data and arrive at an By using combinations of sorting, pivoting, and drilling you can arrange the data on your Worksheet in a way that lends itself to easier analysis. For more information about the settings in the pref. In Lesson 2 you will learn how to select Items from the database with the Workbook Wizard. If you cannot save your work, stay connected to the video store database instead for the duration of this lesson. On a Worksheet, Items appear as column and row headings, and in Lesson 3 you will learn how to rearrange Items on a Worksheet.
Discoverere Plus - with all features of Discoverere Desktop minus save workbooks on local machine. G patchset or above , you will use Oracle Applications Manager to edit your context file. I am looking more n more different kind of report to work on ,so if you can provide me some example reports thru that i can practice in this with all he step details. The Session component contains all of the application logic and performs all of the Discoverer operations such as connecting to the database or opening a workbook. In the Oracle Discoverer window, enter the username, password, and connect string given by the Discoverer administrator and click Connect.
Each step in the lesson includes a to the section of the previous lesson that covered that task. When the Preferences component is brought back up, the Locator component will bind to the Preferences component again. Discoverer 10 can be implemented in two models. This triggered many companies to upgrade from Old versions of Discoverer to Discoverer 10g. If you are not prompted to download and install the Java Plug-in, skip the next step. By using Discoverer's analysis tools, you will find the answers to these and your own particular business questions.
By clicking Supervised, you are notified if there are any issues that need to be resolved. However, the information is organized differently in the two Worksheets. And you can share your Discoverer Workbook with other Discoverer users at your company. Before you create a new Workbook, you can decide how you want the data in your Workbook to look. If you are getting data from a very large database, the amount of data you get could be so large that you would have difficulty finding the answer to that question. Another way to organize your data for analysis is to duplicate your table as a crosstab. Microsoft Internet Explorer or Netscape Navigator.
The real power in using Discoverer comes from using Plus and Viewer using an Application Server and these licenses are certainly not free. When you create your own Workbooks, you can group related Worksheets together as a single Workbook in this way. Whether a product is 'free' or a 'captive cost' may depend on your Oracle product mix, versions, and maybe even on symantics. In my project, it involved Noetix upgradation also. The choices you make become the default settings for all new Workbooks. As you use Discoverer, you will find uses for it that you may not have thought of before.
They do not change the layout of Workbooks that you already created or that were created by someone else. The remaining components are installed on one or more application servers. The example changes every time you change text features. Business Folders Overview of Business Areas:- -A business area is a collection of related information in the database. However they are designed to be deployed on multiple machines for more information, refer to. Click the word Region and choose another region from the drop-down list. For example, you can choose font size, background color, and text alignment.