The direct database request ddr allows you to perform sql statement directly on database. Obiee clear server cache from direct database request. Dec 06, 20 step by step installation of obiee 11g version 11. Before installing obiee 11g, you must have to install two schemas biplatform and mds in your database. Purging cache in the answers using direct database request. Altering the banner description text and image in obiee 11g 4 years ago. I am assuming that you are asking grand total in table view for direct request. Direct database request configuration obiee 11g obiee by.
Obiee clear server cache from direct database request you can clear the obiee server cache by running a direct database request from analysis on the front end. As per our business requirement please suggest us how to create a prompt through a sql statement in obiee. So that when you login to answers you can see the link for creating a direct database request. Date as presentation variable, how to give provide default value in date variable, obiee how to use the presentation variable in direct database request, obiee presentation variable. I have created a database named rcu to store the obiee repository tables. Since the contexts of the posts was his oow14 presentation on self service bi, he didnt cover my favorite part of obiee s direct database request the ability to use presentation. Execute direct sql direct database request feature in obiee. Specify the appropriate options on the criteria tab. In the global header, select new, then analysis, then create direct database request. The property, allow direct database requests by default, lets all users execute physical queries. This section attempts to demonstrate oracle data mining integration with obiee which uses the direct database request feature of obiee 10g 11g. Open the rpd, create a new database and select allow direct database requests by defaultname.
It is available on linux, windows, solaris, hpux and aix platforms as well as the oracle cloud. Oct 22, 2014 since the contexts of the posts was his oow14 presentation on self service bi, he didnt cover my favorite part of obiee s direct database request the ability to use presentation variables in the select statement, and as a result natural integration of the result in a dashboard. Oracle business intelligence 11g silent installation on oracle linux 7 ol7 this article demonstrates how to perform a silent installation of oracle business intelligence 11g on oracle linux 6 and 7 ol6 and ol7 using oracle database 12c release 1 12. Combine analysis criteria across multiple subject areas and execute direct database queries. Online obiee training is a business intelligence tool of oracle. Direct database request configuration obiee 11g obiee by pavan.
Since the contexts of the posts was his oow14 presentation on self service bi, he didnt cover my favorite part of obiee s direct database request the ability to use presentation variables in the select statement, and as a result natural integration of the result in a dashboard. Usually we never this option and in fact we dont need it for day to day reporting needs. Unfortunatelly the parameter emplidselected value isnt passing true the other analyse where there is also a column emplid. In obiee 11g direct database requests has a limitation that, it cannot be used for the prompts. Edit direct database requests and execute direct database requests finally the problem was fixed by making a change in rpd. Sql with prediction verbs oracle data mining supports verbs via sql such as predict, detect, cluster, classify, regress, profile, identify factors and associate. Oracle database 19c, is the long term support release of the oracle database 12c and 18c family of products, offering customers premier and extended support through to march 2023 and march 2026 respectively.
Is there any way to define or set the value of a presentation or request variable inside my filter query. I am creating a new request using direct database request. Obiee 10g 11g filter based on direct database request. Oracle business intelligence enterprise edition obiee 11g r1 11. In part 1 of my story on obiee s direct database request ddr, i walked through the basic process of how to use ddr for directly querying a database mapped ino the rpd. Java script to hide edit dashboard and other options. Physical sql statement is always executed does not utilize obiee 11g. Hello, we ran into the same issue a few months back and after extensive testing of prompts that set variables, we found that, depending on the settings of the prompt and what the user chooses in the prompt, the variable may end up containing any of the following. I am unable to use a direct database request ddr as a filter query.
A query contains the underlying sql statements that are issued to the oracle bi server. In the physical layer, click on database for which you need to enable direct database. When user click on report to see the output, bi was taking unusually long time just to show the clock to indicate query is working. The issue is that i want to link two reports created using direct database request. August 2010 obiee oracle business intelligence blog. Variables in direct database requests in answers we have possibility to write sql directly to the database. Spatial query within obiee dashboard, not tied to obiee model example. It has very good market value and many of the customers are implementing this solution as oracle is investing lot. From there, you can either select a subject area or select a direct database request. Lets create a direct database request and see the use of presentation variables. Firstly, youre right that custom sql known as direct database query is not a good idea in principle, though it is useful on occasion. Tuning the obi queries generated is an obi rpd task, for the obi developer.
Direct database request in obiee part 1 we all of us must have seen the option direct database request on the very first page of the obiee answers. Direct database request allows one to run sql statements directly on to a data source. How to create a prompt through a sql statement in obiee. Obiee 11g direct database request with db link oracle. Variables in direct database requests obiee oracle.
Slow performance on database and inactive database sessions this is one of the important issues which i have faced at most of the implementations i have been part of. Users with the appropriate permissions can create and issue a direct database request directly to a physical back end database. With the direct database request all you need is the connection pool information still not positive on how this is formatted and your sql statement. You can clear the obiee server cache by running a direct database request from analysis on the front end. Through this set of interview questions you will learn how to create interactive dashboards, executing direct sql in obiee, different types of variables, how to create hierarchy, different layers of obiee repository and more.
Im trying to set up obiee 10g usage tracking feature and dashboard reports, with direct insert equals to no i. Aug 28, 2014 create direct database request is a littleused option within obiee. Obiee 10g 11g filter based on direct database request doc id 1991117. Using the direct database request feature in obiee youtube. Usually used a last resort, the direct database request has many limitations including. Jan, 2009 im still not sure but the answer probably lies in the answer section. You can do this by simply selecting the request that is a direct database and it is present underneath the area involving the subject.
This example uses a direct database request with presentation variables. Oracle business intelligence enterprise edition obiee 11g. The returned results set can be rendered in oracle bi presentation services, and then charted, rendered in a dashboard and treated as an oracle bi request. Top obiee interview questions and answers for 2020 intellipaat. Creating a direct database request and using variables within a direct database request.
We can disable execute direct sql by the path below. In the physical layer, click on database for which you need to enable direct database query for nonadmin users thats the green cylinder icon. Download and unzip both files to the same directory. Dec 26, 2012 you can clear the obiee server cache by running a direct database request from analysis on the front end. The basic premise of the ddr feature is that you give users access to the name of a connection pool in the rpd and they are able to issue physical sql to that connection pool as if they were the bi server itself, thus bypassing the metadata layer, while still maintaining most of the functionality that an analysis provides. Export bi catalog captions from command line in obiee 11g. Delay in bi reports showing up obiee oracle business. In previous versions of obiee we could access the data sources by issuing a create direct database request. The ability to execute sql statements directly against the data warehouse, also known as direct database requests is not new to obiee 11g.
Obiee 11g how to get the create direct database request link to show doc id 2069153. For example, you have data for multiple clients and you structured the database so that data for each client was in a separate catalog. Playing with direct database request and the dashboard prompt. The requirement is to filter postal codes in my main subject areabased query using a ddrbased query which performs a regexp function, explained below. By clicking direct database request below the subject area in we can execute direct sql in obiee. Obiee 10g11g direct database request gerardnico the data. Create direct database request is a littleused option within obiee. From the criteria pane of the report created from first subject area come to the bottom of the page and click combine request. Direct database request ddr obiee10g\11g what is direct database request in obiee. When to allow direct database requests by default oracle docs. Sep 01, 2010 how to create a direct database request with obiee 11g. To request access to these releases, follow the instructions in oracle support document 1071023.
Oracle database 11g release 2 for microsoft windows x64. Oracle ace director kevin mcginleys tech tip focuses on using the direct database request feature in oracle business intelligence enterprise. Dec 19, 20 this video describes about executing direct database requests. Physical sql statement is always executed does not utilize obiee 11gs bi server engine for maximum query optimization increased. The returned results set can be rendered in oracle bi presentation services, and then charted, rendered in a dashboard, and treated as an oracle bi request. I have deployedmerged usage rpd and catalog with my existing rpdc. Take note of connection pool name from rpd obiee administrator. Building mapbased dashboards oracle software downloads. Yes, it is possible to execute a direct sql for obiee. You can do this by simply selecting the request that is a direct database. How to create prompts or presentation variables when using direct database request scenario. It basicly gives you an option to do an union all, intersect or minus.
I have put a interaction link on this column that bring me to another analyse. In order to purge cache using direct request create a new database in repository as follows. We need to create a report using the direct database request and also have to create a prompt to dynamically enter the values by the users. Adding database hints to your reports to improve obiee. Obiee how and where can i set a request variable set variable. According to me, we cant get grant total in table view for direct request, but we can get this in pivot view of obiee. Apr 18, 2012 edit direct database requests and execute direct database requests finally the problem was fixed by making a change in rpd. Obiee 10g11g direct database request gerardnico the. In this obiee interview questions you will get the knowledge to help you clear the obiee job interview.
Use the direct database request option in answers use an opaque view in the rpd spatial data visualization usecases. Nov 21, 2010 oracle business intelligence enterprise edition, obiee, oracle bi, obi ee, bi, best practices, examples and technical solutions from data modelling to reports and dashboard. Business intelligence server enterprise edition version 10. Define the query using the create direct database request feature in obiee, and include references to variables set by dashboard prompts. Obiee direct database request and presentation variables.
Oct 10, 2014 since the contexts of the posts was his oow14 presentation on self service bi, he didnt cover my favorite part of obiee s direct database request the ability to use presentation variables in the select statement, and as a result natural integration of the result in a dashboard. Download the obiee 11g versionfrom here or from oracle edelivery site and extract all the four disk into a single folder and click setup. The direct database request permits you to perform sql statement directly to a data source. The basic premise of the ddr feature is that you give users access to the name of a connection pool in. Oracle ace director kevin mcginleys tech tip focuses on using the direct database request feature in oracle business intelligence enterprise edition to empower superusers to. Jul 06, 2016 obiee multi select and all column values from prompt to direct database request report on the dashboard july 6, 2016 july 19, 2016 what is direct database request in obiee. Aug 05, 2010 obiee combine with similar request calculations obiee has a very powerful option called combine with similar request.
Connect to an oracle database power bi microsoft docs. You would initialize a session variable named client, for. By clicking direct database request below the subject area in answers. The oracle bi server sends unprocessed, userentered, physical sql directly to an underlying database. How to create a direct database request with obiee 11g. The issue that we are facing is that we can access the presentation variables in report a, but are unable to pass them to report b.
Review the certification matrix for this product here. Request variable in obiee request variable is used to overwrite the value of session variable and it happens only during request initiation to the database from column prompt. The direct database request permit you to perform sql statement directly to a. To achieve obiee 11g certified profession status, looks like there are two levels of obiee 11g. I have deployedmerged usage rpd and catalog with my existing. Jun 21, 2015 the ability to execute sql statements directly against the data warehouse, also known as direct database requests is not new to obiee 11g. The drawback of this solution is that any user that needs to run the request will need to be granted the execute direct database requests privilege in the obi presentation server catalog administration manage privileges answers. Direct database request in obiee part 2 example no 2. How will you create report from two subject areas from the criteria pane of the report created from first subject area.
To issue the request and see the results, if any, click the results tab. Open the rpd, create a new database and select allow direct database requests by default. Before installing oracle business intelligence, use rcu to create the metadata services mds and business intelligence platform biplatform schemas in the database. Installation guides and general oracle database 11g documentation are here. Executing direct database requests obiee tutorial21 youtube. Obiee where can i use a bi server variable session. Criteria tab is displayed with options for creating a database request. Obiee 11g direct database request with db link gbenga ajakaye feb 7, 2017 3. Oracle business intelligence 11g silent installation on. The direct database request permit you to perform sql statement directly to a datasource. Select all stores within user defined distance of an address approach. Q8 is it possible to execute a direct sql in case of obiee.
Hi guys, i have one report on direct database request. Delay in bi reports showing up we had a direct database request in bi answers. I have seen many places where lots of analytics database sessions are inactive or in cancelled stages and affecting overall performance of the obiee 11g. If you want to import data by using a native database query, put your. Ill show how to use repository, session and presentation variables in direct database request and whether this is possible or not and compare this with normal answers request. How obiee developer can create report from two subject areas. And the download link works perfectly and gives you the filtered data tested. My problem is, am not able to perform aggregation as sum on columns, i. Steps and downloads necessary to connect oracle to power bi desktop. Display both locations and the distance between them.
1238 1061 1469 1322 421 1049 218 581 1523 1165 266 1456 1511 627 382 582 1562 216 1466 1429 1029 542 1292 811 843 72 410 1376 490 1377 857 692 613 1472 980 1531 1057 142 1029 411 1362 1013 1480