OBIEE11g: How to Navigate to Criteria tab on clicking Edit link from Dashboard

Scenario:

 Lets say we have a report placed on the dashboard page and we have the Edit and Export report links on the bottom of the report. If we click on Edit link it will navigate to Analysis pane but by default we would be navigating to Results tab where the report start running and if the filter conditions are set to "Is Prompted" then the reports tried to fetch all the data which may take long time to avoid this we need to manually click on "Criteria" tab every time when you click on "Edit". We can make a setting to avoid this and it points to Criteria tab automatically when ever you click on Edit. We can enable this setting as follows...

1) After logging to Presentation Services(Analytics), you can see the user name in the extreme right corner of the page. Click on the user then you can see two options (these options may change depends on the application role the user been assigned to). Click on "My Account"

2) Now you can see one new window getting opened where you can personalize the user preferences like the display language, Start page,Time Zone etc...

3) Select the option "Start on Criteria tab when editing Analysis" from Analysis Editor drop down.

4) Click on Ok and go to the dashboard and click on edit link of any report you can see navigating to Criteria tab instead of Results tab.

Hope this saves your time......

Thanks,
Nagarjuna

OBIEE 11g: Cannot Copy Data from Reports and Paste to the Windows Clipboard

Scenario:

The users are trying to copy some cells or particular portion of data from Obiee report manually and paste it on Excel,MS Word, Notepad etc. but this is not allowed in the OBIEE 11g version where as the same in possible in 10g. We have created an SR with the same issue and got the reply from Oracle support. I am blogging the same workaround whatever is proposed by oracle here.

Solution:

This feature not available in OBIEE 11g. The only way is exporting the view to another file and then copy/paste.

There is an Enhancement Request for this functionality to be included in a future 11g version:

Bug 10406798- unable to copy data from 11g table or pivot table like in 10g
Currently slated to be addressed in 11.1.1.8 or 11.1.1.9.

The only possible workaround that you may try is described in the following note:

OBIEE 11g: Cannot Copy Data from Reports and Paste to the Windows Clipboard [Doc ID 1287265.1]

As per above note:
Until the enhancement requests are implemented, there is the following work-around:

1) Place the mouse cursor outside the view and click.
2) Drag the mouse across the view to highlight the data you want to copy.
3) Use control+C or copy from the edit menu or right mouse menu to copy the text to the clipboard.

Please note this workaround only works with Internet Explorer. It does not work with Firefox or Chrome.

This issue existing in 11.1.1.7.1 also

How to call a PL SQL function in OBIEE

Hello Everyone,

Recently we raised an S R with Oracle regarding PL Sql Functions in OBIEE. We got the following answer. This could be helpful for  you also...

In general, the only ways you can execute stored procedures from OBIEE is:

- change stored procedure into an Oracle function and then use EVALUATE function in the SQL query in Analytics.
- set scripts for its execution in the connection pool used to execute the report.

I have added the recent update from Oracle Support here for reference

Applies To:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.150120 and later
Information in this document applies to any platform.

Solution

It is possible to use the EVALUATE function in OBIEE to call the function created in the Oracle DB.

Create a function in Oracle DB and use it in an EVALUATE function as shown below:

EVAULATE(‘dbfunction_name(%1,%2)’, parameter list)

In the above expression %1 and %2 are number of parameters to be passed to the DB function.  Parameters can be more than or less than 2 depending on the requirement.  These can also be constant values.

e.g., EVALUATE(‘func1(%1)’,’TRADE_ID’)

So, the above expression will pass the TRADE_ID parameter to the DB function(func1) and hence give the result based on the output of the DB function.

NOTE:  It is not possible to call a stored procedure using the EVALUATE function.  EVALUATE function is used for most of the DB functions and it finds a vast usage in OBIEE.


Thanks,
Nagarjuna

OBIEE 11g: Conditional Formatting on a Column based on other column is not working in OBIEE11g

This issue is with 11.1.1.5.0 and later versions including the latest version 11.1.1.7.1

Scenario:

In OBIEE 11g, conditional formatting on a column based on another column does not work as it did in OBIEE 10g. For example, in an analysis, you set the conditional format of a column to turn background color to red, based on the value of another column. This works in OBIEE 10g, but not in OBIEE 11g.

Solution:

1. For the column for which you want to apply the conditional format , open the Column properties dialogue box. 
2. Click on the Column Format tab.
3. Set the value suppression to "Repeat" then the conditional format will work as per your requirement.

How to change the Languages And Locales In The OBIEE Login Screen

Hi,

I found this in Oracle support, It is interesting so thought to share with you. If you have oracle support account then you can access this directly from oracle support (Doc ID 1267934.1)

Goal

How to modify the list of available languages and locales in the Oracle Business Intelligence (OBIEE) login screen, for versions 10g (10.1.3.x.x) and 11g (currently 11.1.1.3.0).

Solution

In OBIEE 10g it is possible to change the list of available languages and locales in the log in screen. This is done by editing instanceconfig.xml file under the directory

<OracleBIData>/web/config

and adding/removing the languages from the corresponding tags.

For example, to display only Germand and English languages, you can set it as follow:

<AllowedLanguages>de,en</AllowedLanguages>
<AllowedLocales>de-at,de-ch,de-de,en-us</AllowedLocales>

Then, you need to restart Presentation Server.

**************************************************************
In OBIEE 11g the settings have changed. In the instanceconfig file now you need to modify within the <Localization> tag.

The instanceconfig.xml file is located under
<BI_HOME>/instances/instance3/config/OracleBIPresentationServicesComponent/coreapplication_obips1

for example
C:\OBIEE_11g\instances\instance3\config\OracleBIPresentationServicesComponent\coreapplication_obips1

This is how you need to modify the instanceconfig.xml file:

<Localization>
<AllowedLanguages>de,en</AllowedLanguages>
<AllowedLocales>de-at,de-ch,de-de,en-us</AllowedLocales>

</Authentication>
<Localization>
<AllowedLanguages>de,en</AllowedLanguages>
<AllowedLocales>de-at,de-ch,de-de,en-us</AllowedLocales>
</Localization>

</ServerInstance>
</WebConfig>
</Localization>







Thanks,

Nagarjuna

Oracle Certification Matrix for OBIEE 11.1.1.7

Please click on the below link....

Oracle Certification Matrix for OBIEE 11.1.1.7

OBIEE11g: How to insert or Display or Show a Dashboard inside another Dashboard

Hi...

Recently i got an interesting question from my colleague regarding inserting or displaying a dashboard inside another dashboards. Its sounds good and i started thinking on it. The easy way to do it is using the dashboard object "Embedded Content". In this post i am going to show you how i achieved this requirement.

From the properties of the Embedded content we all know that it is useful for displaying any web content in the obiee environment (dashboards). The general scenarios are displaying the clients website or displaying the client email login pages etc.... The new point is we can use the same to display one dashboard inside the another dashboard. If we understand the functionality of the dashboard we can say a dashboard is also a webpage which will have some url so simply by adding this dashboard URL to the embedded content we can achieve this. Follow the screenshots to understand better....

Requirement: In my case i have two dashboards "Demo Dashboard" and "Sales Analytics". I want to display Sales Analytics inside the Demo dashboard.

Step 1:

Open the Sales Analytics Dashboard (click on the dashboards and select the sales analytics)

Step 2: Copy the URL of that page

Step 3: Now go to the Demo Dashboards

 Step 4: Click on the Edit Dashboard

Step 5: Add the Embedded content object (drag and drop embedded content from left window to right)

Step 6: Click on the edit properties of the embedded content

Step 7: Now paste the URL of the Sales Analytics dashboard in the URL section

If you want you can adjust the width and hight. I have changed them as per my requirement.

Step 8: Now save the dashboard and run the same, You can see Sales Analytics dashboard is displayed inside the Demo dashboard

 Thanks,
Nagarjuna