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
Monday, August 29, 2011
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>
<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
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
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.
3) Usage tracking Presentation Catalog provides prebuilt requests and a dashboard built to provide common analysis—for example, analyzing usage patterns by users, groups, and queries; daily and weekly peak usage patterns and load variance; time series comparisons to help compare current usage over previous weeks or months; and major contention points for troubleshooting, including, for example, top long-running queries.
Step1: if you have user id in your SQL schema use it other wise create new one with all permissions.
Step 2: Create the tracking table.
the Tracking table Script can be found in:
D:\bi11g\instances\instance3\bifoundation\OracleBIServerComponent\coreapplication_obis1
Step 3: Make it available for the public
GRANT SELECT ON S_NQ_ACCT TO PUBLIC;
Step 4: Setting up the additional tables
You can find the scripts in
D:\bi11g\instances\instance3\bifoundation\OracleBIServerComponent\coreapplication_obis1\sample\usagetracking\SQL_Server_Time
Run the following scripts;
SQLServer_create_nQ_Calendar
SQLServer_create_nQ_Clock
SQLServer_create_nQ_UserGroup
SQLServer_nQ_Calendar
SQLServer_nQ_Clock
And load the data.
Step 5: Make it available for the public
GRANT SELECT ON S_ETL_DAY TO PUBLIC;
GRANT SELECT ON S_ETL_TIME_DAY TO PUBLIC;
Step 5b: Create an extra view
CREATE VIEW nq_login_group AS SELECT DISTINCT user_name AS login, user_name AS resp FROM s_nq_acct;
Step 6: Merge the usage tracking RPD into your master RPD.
GRANT SELECT ON S_ETL_DAY TO PUBLIC;
GRANT SELECT ON S_ETL_TIME_DAY TO PUBLIC;
GRANT SELECT ON S_NQ_ACCT TO PUBLIC;
Open your master RPD offline.
Usage Tracking RPD file
[USAGE_TRACKING]
ENABLE = YES;
#==============================================================================
# Parameters used for writing data to a flat file (i.e. DIRECT_INSERT = YES).
#
# Note that the directory should be relative to the instance directory.
# In general, we prefer directo insert to flat files. If you are working in
# a cluster, it is strongly recommended you use direct insert. If there is
# only one Oracle BI Server instance, then you may use flat file data.
# The directory is then assumed relative to the process instance. For
# example, "UTData" is resolved to
# "$(ORACLE_INSTANCE)/bifoundation/OracleBIServerComponent/<instance_name>/UTData
STORAGE_DIRECTORY = "<directory path>";
CHECKPOINT_INTERVAL_MINUTES = 5;
FILE_ROLLOVER_INTERVAL_MINUTES = 30;
CODE_PAGE = "ANSI"; # ANSI, UTF8, 1252, etc.
#
#==============================================================================
DIRECT_INSERT = YES;
#==============================================================================
# Parameters used for inserting data into a table (i.e. DIRECT_INSERT = YES).
#
PHYSICAL_TABLE_NAME = "OBI Usage Tracking"."Catalog"."dbo"."S_NQ_ACCT";
CONNECTION_POOL = "OBI Usage Tracking"."Usage Tracking Writer Connection Pool";
BUFFER_SIZE = 250 MB;
BUFFER_TIME_LIMIT_SECONDS = 5;
NUM_INSERT_THREADS = 5;
MAX_INSERTS_PER_TRANSACTION = 1;
#
#==============================================================================
SUMMARY_STATISTICS_LOGGING = NO;
SUMMARY_ADVISOR_TABLE_NAME = "OBI Usage Tracking"."Catalog"."dbo"."S_NQ_ACCT";
File path bellow,
Edit With Notepad--
Ammend USAGE Tracking Section in NQSCONFIG.ini Like So I have shown only sections relevent to
ammendment.
[USAGE_TRACKING]
ENABLE = YES;
After merging two rpd GPC_Datamart and Usage tracking will be show like below screen short.
Ammend both Connection pools to the Schema for Usage Tracking we created earlier. Also set permissions
for Writer connection pool to read and write.
Connection Pool & Usage Tracking Writer Connection Pool
Then ammended connection pool to connect to my Usage Tracking tables schema we created earlier.
Just do an Update Row Count to make sure you can connect ok ..
I have noticed that OBIEE 11g is pretty bugged up... So just keep trying with creating connection pools..
I had to copy the connection pool over from my Pre-Merged UsageTracking.rpd and then it started
working.. Weird but hey.
Thats it the RPD is working and merged .
Then log in dashboard page and check it out.
Reference:
1)
2)
3)
4)
5)
Thanks and Regards,
Deva
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 ?
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
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 02, 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)
************************
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.
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:
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)
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:
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
Subscribe to:
Posts (Atom)