OBIEE 11G BI PUBLISHER Logging in to Oracle BI Publisher

Obiee 11g Bi Publisher Logging In To Oracle Bi Publisher-Free PDF

  • Date:27 Jun 2020
  • Views:4
  • Downloads:0
  • Pages:80
  • Size:2.41 MB

Share Pdf : Obiee 11g Bi Publisher Logging In To Oracle Bi Publisher

Download and Preview : Obiee 11g Bi Publisher Logging In To Oracle Bi Publisher


Report CopyRight/DMCA Form For : Obiee 11g Bi Publisher Logging In To Oracle Bi Publisher


Transcription:

3 The Home page is a task oriented centralized workspace combined with a global header. allowing access to Oracle BI Publisher objects their respective editors and help documentation. Observe the various sections of the Home page greatly enhanced in 11g release to enable the. users get started quickly with BI Publisher,For example you can see. A Create section on the left that has options to help you create reports data models and. other objects, A Browse Manage section on the left to help you browse and manage the catalog jobs. and job history, A Get Started section on the left to help you get started with BI Publisher with links to. various BI Publisher tools Online Help and Oracle Technology Network. A Recent section on the right personalized to each user so that the users can open view. the reports that have been accessed recently when you login initially you may not see. any objects listed in the Recent section, Also try the enhanced Search capability that enables you to search for objects by type. 4 On the upper right side you can see the links for the Home page Catalog drop down lists New. Note All these features make the navigation within BI Publisher easy for report developers and. Browsing the Catalog and Viewing the Reports, 1 Follow the steps listed here to browse the catalog and open a sample report predefined.
Click the Catalog link in the Browse Manage section or Click the Catalog link found on the. right side of the Home page, 2 The Catalog page is displayed as a tree structure on the left side of the page with the details on. See that the objects such as reports data models are organized into folders. Note The Samples folder found in Shared Folders contains a set of predefined sample reports. You will open one of these reports, 3 Also see the tool bar with New drop down menu that enables you to create new reports. scheduled jobs data models and so on, Note that the tool bar also has other options such as copy cut paste and other options that can. be used when creating or managing the catalog objects such as data models and reports. 4 Navigate to the Human Resources folder in Samples This displays all the objects in the Human. Resources folder, You can also search for a report or other objects using some key word and view it For. example in the Catalog page select the Reports check box from the Search drop down list and. enter a key word in the Text field beside it In the example below the search results in a list of. reports that have Sales in name,5 Click Open link below the Salary Report.
6 The Salary Report is opened in view mode The report data is displayed using the Default layout. All the predefined layouts for the report are displayed as different tabs. You can also view the report using any of the supported formats Click View icon displayed on. the top of the report viewer towards the right Highlighted in the screen below. 7 Also note the parameters defined in the report Department and Employee that display drop. down lists for department names and the employees working in the corresponding departments. For example when you select Finance as the Department and the Employee list shows the. employees working in Finance department, 8 You can click Financial Style and Pivot Table tabs to view the data in report using these. predefined layouts, The following screens shows data for the Finance department using Financial Style layout. The followings screen displays data for the Sales department using Pivot Table layout. Setting Preferences, 1 To set the Preferences Click on the link Signed in as and select My Account from the drop. 2 This displays the Preferences screen with the General My Group tabs links as shown in the. screen below, You can set the Report Locale UI Language Time Zone and Accessibility Mode in the. General Preferences section, Report Locale A locale is a language and territory combination for example English.
United States or French Canada BI Publisher uses the report locale selection to. determine the template translation to apply the number formatting and date formatting. to apply to the report data, UI Language The UI language is the language that your user interface displays in The. language that you selected at login will be selected as the default However you can. choose from the languages that are available for your installation through this option. Time Zone Select the time zone to apply to your reports Reports run by you this user. will display the time according to the time zone preference selected here. Accessibility Mode Setting this to On will display the report catalog in a tree structure. that is accessible via keyboard strokes, Note If running BI Publisher integrated with a Security Model other than BI Publisher these. preferences may be inherited from the other security model and you will not be able to change. these values, 3 Click the My Groups tab to view a list of the application roles to which you are assigned You. cannot modify this list, To change your password click the Password tab of the My Account dialog. Note Password tab is visible only when you use BI Publisher Security. Configuring the Data Sources,Types of Supported Data Sources.
Oracle BI Publisher supports various types of Data Sources such as JDBC data sources. Oracle Database and other Databases XML Files BI EE Reports Answers JNDI data. sources OLAP data sources Fusion Application Data sources Web Services HTTP data. sources and Discoverer, Before you create a data model based on these data sources you need to configure a. connection to these data sources first In this topic you will learn how to configure a JDBC. connection to an Oracle Database and also you learn how to define a File data source. This topic has the following subtopics,Defining a JDBC Connection. Configuring File Data Location,Defining a JNDI Connection. Defining a JDBC Connection, 1 To define a JDBC connection click the Administration link found on the right side of the BI Publisher. This displays the BI Publisher Administration page as shown below Observe the Data Sources section in. the screen below, 2 Click the JDBC Connection link found under the Data Sources section in the Administration page.
3 This displays the Data Sources page In the JDBC section click Add Data Source to create a JDBC. connection to your database, 4 In the Add Data Source page that is displayed enter the details as given below. Data Source Name OE, Driver Type Select a driver type to suit your Database for example you can select Oracle 10g or. Oracle 11g to suit your Database, Database Driver Class oracle jdbc driver OracleDriver Define a driver class to suit your. Connection String Provide the database connection details For example hostname port sid. User name OE Database user name,Password OE Database user password. Do not click Apply or Cancel after defining the above details Click Test Connection. Note To continue with this tutorial exercises the sample schemas OE and HR should be installed in your. Oracle Database as mentioned in the Prerequisites Else you will not be able to define this JDBC. connection, 5 If the connection to the database is established a confirmation message is displayed indicating the success.
As shown in the screen below,Then click Apply, 6 You can see this newly defined connection OE in the list of JDBC Data Sources. Note You can also set up the the default connection demo to point to OE schema in your database as the. samples use this connection Then the demo connection can be used as the default data source for this. tutorial too,Configuring File Data Location, 1 BI Publisher ships with a repository of various sample files and reports These are available in BI Publisher home. To define a File data source click the File tab in the BI Publisher Administration page. Click the demo files link to update the file location. If you want to create a File data source with a different name you can click Add Data Source. 2 Define the top level directory which has all the sample files repository. Using this demo files data source users can access all the files in the top level directory and also it s subdirector. Defining a JNDI Java Naming and Directory Interface Connection. BI Publisher supports connecting to a JDBC data source via a connection pool Using a. connection pool increases efficiency by maintaining a cache of physical connections that can. be reused When a client closes a connection the connection gets placed back into the pool so. that another client can use it, Note JNDI Connection concept is briefly introduced here as you need to first set up the. connection pool in your application server and access it via Java Naming and Directory. Interface JNDI Then you can define the JNDI connection in BI Publisher by entering the. required fields in the JNDI connection definition page so that BI Publisher can utilize the. pool to establish connections,Creating a Data Model. In release 11g Oracle BI Publisher introduces the Data Model Editor a graphical user. interface for building data models within the BI Publisher interface It enables you to perform. the following tasks, Create Data Sets Access data from a wide range of sources RDBMS OLAP.
WebServices BI Analyses XML files Excel and others. Query data Build SQL or MDX queries to extract data from relational or. multidimensional OLAP data sources, Structure data Define master detail relationships between data sets to group data at. multiple levels to optimize document generation, Aggregate data Create group level totals and subtotals. Customize data Modify data field names to conform to business terms and reporting. requirements, Create calculations Compute data values that are not stored in the underlying data. sources that are required for reporting, Advanced tasks Define parameters and lists of values LOV triggers and other. advanced elements as required by reports and report users. In this topic you are guided to create Data Model based on SQL query using the JDBC. connection you defined in the previous topic Also you will learn how to add parameters and. LOVs to the data model,Defining Default Data Source and Output Options.
1 Note Before starting the creation of Data Model you will first create a folder to save all your. objects such as reports data models and so on, In the Home page click Catalog link under the Browse Manage section. In the Catalog page that is displayed select the My Folders node click the New icon on the tool. Select Folder from the drop down menu to create a new folder. Enter Learn as the name of the folder optionally enter a description and click Create. You can see that the folder gets listed in My Folders. 2 Now you can invoke the Data Model editor in one of the following ways. From the Home page Create section select Data Model. From the Catalog page click New icon and select Data Model from the drop down menu. OBIEE TRAINING OBIEE 11G BI PUBLISHER Logging in to Oracle BI Publisher and Navigating the Home Page 1 Enter the URL for BI Publisher in the browser window which is of the format

Related Books