You don’t have JavaScript enabled. Expose key fields in the business layer. Click Connect to Data. To do this, follow these steps:. Close Are you sure you want to delete this document?

Uploader: Tagar
Date Added: 13 July 2013
File Size: 12.61 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 58614
Price: Free* [*Free Regsitration Required]

This chapter includes the following topics: Windows Registry Editor Version 5. Instead, you can create one regular connection that sends requests to the Presentation layer, and one connection that sends requests to the Physical layer.

The oracle bi server odbc credentials allow privileged users to connect to the underlying databases at the level of authority granted to those users in the databases. A good point to start. For Presentation Services clients, each Presentation Services instance can only access a single repository. Locale The second folder you need is localeit is located near bin.

Click Connect to Data. I oracle bi server odbc not describe in full details the process of the investigation as it is not too challenging. What Is Going On!

I’m sure you’ve recognised the most favourite data analysis tool of all times – Excel. You won’t win the smallest ODBC client contest but will save a odbf minutes of your time.

You may want to refine it, maybe remove some columns, or change aliases, or add a clause or two from the evil part’s oracle bi server odbc, but for the first step just take it and use it. Full and the only possible actually client OBIEE installation is more than 2 gigabytes and consists of more than 31 thousand files.

Bookshelf v Configuring Oracle BI Server Client

You don’t have JavaScript enabled. And a bit of educated guess helped to find bk more folder called locale which stores all language files. And not obvious but pleasant bonus is that I can give it any name I like. When this option is enabled, data in Date, Time, or DateTime format is displayed using Windows regional settings, rather than the default format for the Oracle Oracle bi server odbc Server.

OBIEE 10G/11G – How to create an Analytics ODBC Data Source (System DSN ODBC connexion)

To change the default catalog, select the option Change the default catalog to, and then type oracle bi server odbc name of the catalog in the field below the check box. If the test is not successful, correct any error b in the message and test the connection again.

I deleted some keys in order to make this screenshots more clear and readable. Note that you cannot have a single ODBC connection that sends queries to both the Presentation layer, and the Physical layer. You must select the subject area that you want oracle bi server odbc connect to in each ODBC connection oracle bi server odbc create.

Meet the most beloved by end users all around the world tool – Excel. Install Presentation Services on one computer for each repository instance. Where have you got that SQL? Expose key fields in the presentation layer. Create a few registry keys; 3.

OBIEE installer doesn’t copy a single byte to the Windows folder and it’s a good news I odacle but it creates a few registry keys what was expected. In the screenshot below, the appropriate key fields have been added to the Sample Sales Lite subject area. To configure SSL for this data source, supply the following additional parameters as appropriate sefver your SSL deployment: To change the password, you must have entered your logon information and selected the option Connect to Oracle BI in the previous screen.

Physical Layer right pane —The layer where the connection to each data source is made and the raw tables are exposed. And the second aim was avoiding a full installation with cutting out redundant pieces. INI file to which you want to connect in the field below the check box.

The Presentation layer lets oracle bi server odbc configure the presentation of a business model to be consistent with the rules and conventions of your tools oracld take hi of the analytical engine and data abstraction of the Oracle bi server odbc BI Server.

Type a oracle bi server odbc for the data source in the Name field.