Monday 8 July 2013

Passing presentation variable to prompts in 11g

When we are using Presentation variables, Prompt functionality is very limited. One of those is using
option 'All Column Values'.Here I'm trying to depict a Tip to make use of option 'All Column Values'.
To demonstrate the same here I'm defining a Presentation variable as '' using Page or Dashboard Prompt.



When I select 'All Column Values' we see the report with 'No Results' message as shown below since the criteria is not set properly


Use the below case statement to so that the condition matches as shown in the image
<COLUMN> LIKE (CASE WHEN '@{U}{}'='' THEN '%%' ELSE '@{U}' END)


On the Dashboard page, the prompt with option 'All Column Values' is selected and the report results are as below

Till Next Time.....

NQLogViewer in OBIEE

We can use the log viewer utility nQLogViewer to view the query log.Each entry in the query log is tagged with the user ID, session ID and request ID.The User ID will have the details of the user who issued the query, the session ID will have the details of the session in which the query was initiated, and the request ID will have the individual query.

Location of nQLogViewer:

In 11g : Oracle_BI_HOME/bifoundation/server/bin/nqlogviewer.
Note : You must run first the bi-init initialization file.

BI-INIT INITIALIZATION FILE: Before running any of the Oracle BI Server command-line utilities, you must now run bi-init.cmd (or bi-init.sh on UNIX) to launch a command prompt or shell window that is initialized to your Oracle instance.

Location of this bi-init initialization file utility:
In 11g : ORACLE_INSTANCE/bifoundation/OracleBIApplication/coreapplication/setup
In 10g : Oracle_BI/server/bin/nqlogviewer

Syntax :

To run the nQlogViewer utility, open a Command window and type nQlogViewer with any combination of its arguments.

The syntax is as follows:

nqlogviewer [-u<user_ID>] [-f<log_input_filename>]
[-o<output_result_filename>]
[-s<session_ID>] [-r<request_ID>]

Here :

user_ID :
The name of a user in the Oracle BI repository.By using this the user specified in the syntax only can use the query logging. If it is not specified ,all the users for whom query logging is enabled will be shown.

log_input_filename :
The name of an existing log file. This parameter is required.

output_result_filename :
The name of a file in which the output of the log viewer to be stored. If the file exists, results are appended to the file. If the file does not exist, a new file is created. If not specified, output is sent to the monitor screen.

session_ID :
The session ID of the user session.The Oracle BI Server assigns each session a unique ID when the session is initiated. This limits the scope of the log entries to the specified session ID. If not specified, all session IDs are shown.

request_ID :
The request ID of an individual query. The Oracle BI Server assigns each query a unique ID when the query is initiated. This limits the scope of the log entries to the specified request ID. If not specified, all request IDs are show

Wednesday 3 July 2013

11.1.1.7.1 Patch Set Released

The Business Intelligence Enterprise Edition 11.1.1.7.1 patch set has been released (currently only for 32- and 64-bit Linux and Windows), and is available to download from My Oracle Support (https://support.oracle.com/).

Per the patch readme:
This patch set is available for all customers who are using Oracle Business Intelligence Enterprise Edition 11.1.1.7.0.

The Oracle Business Intelligence 11.1.1.7.1 patch set is comprised of the following patches: 
Patch 16453010 - Patch 11.1.1.7.1 (1 of 6) Oracle Business Intelligence Installer (BIINST)
Patch 16849017 - Patch 11.1.1.7.1 (2 of 6) Oracle Business Intelligence Publisher (BIP)
Patch 16916026 - Patch 11.1.1.7.1 (3 of 6) Enterprise Performance Management Components Installed from BI Installer 11.1.1.7.0 (BIFNDNEPM))
Patch 16850553 - Patch 11.1.1.7.1 (4 of 6) Oracle Business Intelligence Server (BIS)
Patch 16842070 - Patch 11.1.1.7.1 (5 of 6) Oracle Business Intelligence Presentation Services (BIPS)
Patch 16869578 - Patch 11.1.1.7.1 (6 of 6) Oracle Business Intelligence Platform Client Installers and Map Viewer
Also you must download
Patch 16569379 - Dynamic Monitoring Service patch

Note : OBIEE 11.1.1.7.1 patch set is available as patch 16556157. Unzipping this patch will give you the six patches listed above.

Till Next Time....

Tuesday 2 July 2013

New BI Mobile Features in 11.1.1.7

14) Maximize views with double-tap gesture:

With this new feature, you can access on your iPad more data—even within dense dashboards—without the restrictions of the smaller form factor. You expand an individual view by double-tapping on it. The individual view then displays within the full screen of the iPad. This maximizing of views can be done on views accessed within a dashboard, and also when viewing an analysis independent of a dashboard. See "Working with Analyses and Dashboards."

15) New view and graph types:
The following new graph types are supported with BI Mobile: Performance tiles, Waterfall graphs, 100% stacked graph, Stacked graph

16) Fixed headers:

In analyses with fixed headers, you can use a single-finger drag gesture to scroll through data in all directions

17) Changing Orientation:

It is now possible to change between landscape and portrait orientation while viewing Oracle BI content.

18) Breadcrumbs:

You can see the navigation path you have taken while moving through the catalog as a trail of breadcrumbs (near the top of the screen by the Back arrow). In this way, you can see your current location and how you got there, then decide whether to use the Back arrow to navigate in reverse, or to use the Home icon to quickly return to the Home screen

19) Security toolkit:

The Oracle Business Intelligence Mobile Security Toolkit provides the ability to generate a signed version of the Oracle BI Mobile HD application. The toolkit includes the instructions and necessary content to build this application making use of Apple's Xcode and the IOS SDKs. The Oracle BI Mobile Security Toolkit will be updated on a regular basis in order to synchronize with the Oracle BI Mobile HD application available on the Apple App store. See "Using the Security Toolkit for Mobile Device Management."

20) Viewing of Oracle BI Publisher reports in dashboards

21) Integrated Full-Text Catalog Search:

As in the desktop version of Oracle BI EE, you can use full-text search to find catalog objects in Oracle BI Mobile based on attributes such as author and column name. This search is available after the administrator integrates Oracle BI Enterprise Edition with Oracle Endeca Server