OBIEE Online Training

Monday, August 29, 2011

OBIEE11g - While installing RCU Error: failed to connect DB - invalid server name/port no

Hi,

SQL Configuration Manager make sure the TCP/IP enabled.

http://blog.ropardo.ro/2011/03/04/the-repository-creation-utility-rcu/



Thanks and Regards,
Deva

Hide the Go button in OBIEE


Hi,

If you need to hide the go button for a dashboard prompt in OBIEE insert a static text object on to the dashboard, select the “Contains HTML Markup” option and enter the following text into it:
<style type=”text/css”>
.XUIPromptEntry{display:none}
</style>


Regards,

Deva

Tuesday, August 23, 2011

Enable “Change Password” for OBIEE 10g &11g Dashboard - my Account Page for end users purpose

Enable “Change Password” for OBIEE end users

Here I will details the steps on How to enable OBIEE 10g users changing their password without having Administrator privilege.

I have tested this on OBIEE 10.1.3.4.1 running on a Windows server and it works fine.

All it requires is a simple change to controlmessages.xml file which can be located under $:\web\msgdb\messages directory.
Changes show below -
Replace the line
<WebMessage name=”kmsgChangePasswordLink”><!–<HTML><a insert=”1″><sawm:messageRef name=”kmsgUIChangePassword”/></a></HTML>–></WebMessage>
with
<WebMessage name=”kmsgChangePasswordLink”><HTML><a insert=”1″><sawm:messageRef name=”kmsgUIChangePassword”/></a></HTML></WebMessage>
This requires restarting the BI server, After restarting the BI server successfully, users should be able to see the “Change Password” link on their OBIEE My Account page.



But it wont work in obiee11g kindly refer the below reason:

The ability to change password is not possible in OBIEE11g. With 11g, OBIEE essentially uses the 10g notion of external authentication. By default, this is the WLS (Weblogic)LDAP identity store, but may be any defined Authenticator either within WLS, or in the OBIS metadata (i.e. Custom Authenticator or LDAP). As such, OBIEE proper no longer has any control over user passwords - this is why the steps referenced in Doc ID 1102353.1do not apply to 11g OBIEE

See Change Passsword Link In Answers/Dashboard Obiee 11g (Doc ID 1302091.1)

OBIEE 11g : (Workaround Method from Venkat Blog)

http://www.rittmanmead.com/2011/10/changing-your-password-in-obiee-11g/

Thanks

Deva

Monday, August 22, 2011

Acessing Shored folder/Share Point(Web Link) from OBIEE11g

Hi,
You can able to acess Share point/Shared network folder from your OBIEE11g Dashboard page.

You just add dashboard objects--> images and folder --> then put your shared network folder path --> then save it and run it.

also you can give it your share your Share point web documentory web link.

Thanks and Regards,

Deva

Thursday, August 18, 2011

OBIEE11g Setting up Usage Tracking

Setting Up Usage Tracking in Oracle BI EE

This Document will used to Set up usage tracking and create usage reports to monitor queries.

1) It is used to monitor system and ad hoc query performance and to provide input on usage details

2) Usage tracking is particularly useful in determining user queries that are creating performance, based on query frequency and response time. When usage tracking is enabled, the Oracle BI Server collects usage tracking data for each query and writes statistics to a usage tracking log file or inserts them directly to a database table.

Wednesday, August 17, 2011

How to find current quarter without using time series function OBIEE

How to find current quarter without using time series function OBIEE ?

It can be resolved in multiple ways like - either using variable or without variable
Last qtr of every year is fixed that is 4th for that calendar year so either 4 or QTR4 or something like this which can be hardcoded in your expr here:
Method 1:
Using with variable...I have a curr_year dynamic repository variable here...and a date column in my report:
CASE WHEN YEAR(datecolumn) = VALUEOF("curr_year") THEN QUARTER_OF_YEAR(datecolumn) ELSE 4 END
method 2:
Using without variable....and a date column in my report:
CASE WHEN YEAR(datecolumn) = YEAR(CURRENT_DATE) THEN QUARTER_OF_YEAR(datecolumn) ELSE 4 END

Hope this solves your problem..


Regards,

Deva

 


 

Tuesday, August 2, 2011

OPatch failed with error code = 255 and 14

Hi,

       If any one try to apply opath in your obiee server mchine please make which option choosed while installing obiee11g in your mechine.please make sure if have installed OBIEE11g ,windows server 2008 server 64 bit mechine , enterprice or software only installation option. don't install simple installation ...Opatch won't work.

Ex:
The Opatch error like below one,
************************
java.lang.UnsatisfiedLinkError: Can't load library: E:/OBIEE11G/Oracle_BI1/oui/lib/win32/oraInstaller.dll
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1657)
at java.lang.Runtime.load0(Runtime.java:770)
at java.lang.System.load(System.java:1004)
at oracle.sysman.oii.oiip.osd.win32.OiipwWin32NativeCalls.loadNativeLib(OiipwWin32NativeCalls.java:1509)
at oracle.sysman.oii.oiip.osd.win32.OiipwWin32NativeCalls.<clinit>(OiipwWin32NativeCalls.java:50)
at oracle.sysman.oii.oiip.oiipg.OiipgEnvironment.getEnv(OiipgEnvironment.java:211)
at oracle.sysman.oii.oiix.OiixEnvironmentOps.getEnv(OiixEnvironmentOps.java:53)
at oracle.opatch.OUIReplacer.getEnv(OUIReplacer.java:374)
at oracle.opatch.CmdLineParser.parse(CmdLineParser.java:995)
at oracle.opatch.OPatchSession.main(OPatchSession.java:1240)
at oracle.opatch.OPatch.main(OPatch.java:630)
Solution Satement:
===========
The error appears while running the OPATCH utility because, you have performed SIMPLE install on your 64 bit Windows server 2008 OS.
When a simple install is used a 32 bit JDK is used during install even though the win64 installer is used. This is because the WLS is installed by default with 32 bit JDK.
The only workaround to get rid of this issue is to download a JDK for 64 bit and use it to run opatch. Once done,
run opatch with -jdk option:
>opatch lsinventory -jdk <64 bit jdk location>
and OPATCH should work fine.
Please apply the patch using the OPATCH utility as mentioned in the patch readme.

For your Reference :
===============


- When searched the knowledge base found that the above error shows up when,
Customer uses SIMPLE install on their 64 bit Windows server 2008 OS.
When a simple install is used a 32 bit JDK is used during install even though the win64 installer is used.
This is because the WLS is installed by default with 32 bit JDK.
Please refer to,
Oracle note: Doc ID 1265807.1 (Error: "java.lang.UnsatisfiedLinkError: Can't Load Library: E:/OBIEE11G/Oracle_BI1/oui/lib/win32/oraInstaller.dll" Installing OBIEE 11g on 64-Bit Windows)
- When checked with the customer, got to know that they have also performed a SIMPLE install on their 64 bit Windows server 2008 platform.
- The only workaround here is to download a JDK for 64 bit and use it to run opatch. Once done,
run opatch with -jdk option:
>opatch lsinventory -jdk <64 bit jdk location>
and OPATCH should work fine.
Please apply the patch using the OPATCH utility as mentioned in the patch readme.
Thanks and Regards,

Deva