- Error Connecting to Planning Application from Smartview
- BI Web service security client - authentication operations for 188.8.131.52 and 184.108.40.206.x
- OBIEE 11.1.1 - Advanced Usage of nqcmd command
- BI Checks with WLST - Enable debug, login and parse logs - Part 3
- OBIEE 11.1.1 - Tuning Guide Whitepaper - update available
- BI Check with WLST - SQL Datasources part 2
- BI Check with WLST - Providers and Technical users part 1
- Essbase 11.1.2.x - Web Launched EAS Console jnlp
- OBIEE 11.1.1: Load Testing Oracle Business Intelligence Enterprise Edition (OBIEE) 11g Using Oracle Load Testing (OLT) 12.x
Wednesday Apr 23, 2014
Monday Mar 24, 2014
By user809526 on Mar 24, 2014
This wlst/python script connects to bi security web service to
authenticate a user specified in the "ObieeWebServiceClient.properties"
file. In 220.127.116.11, this calls:
getAuthenticatedUserWithLanguageAndProperties operation of the
/bisecurity/service web service.
In 18.104.22.168, this calls authenticate operation of the /bimiddleware/security/service web service.
This returns as part of the xml response the user unique identifier (guid) and other permissions/roles for the user. This is useful when debugging an issue with OBIEE security.
The script has to be run with %ORACLE_HOME%\oracle_common\common\bin\wlst.cmd (sh)
Script is available there: https://blogs.oracle.com/pa/resource/ObieeWebServiceSecurityClient.zip[Read More]
Thursday Feb 27, 2014
By Ahmed Awan on Feb 27, 2014
Following are the useful nqcmd command lines arguments:
a. In your environment set the "export SA_NQCMD_ADVANCED=yes"
b. Following is the description of the nqcmd command line arguments for BIServer (nqsserver) testing:
-d = Datasource.
-u = username.
-p = password.
-s = inputsqlsfile.
-o = outputfile. counters will be in outputfile_Counters.txt.
-td <secs> = timeduration in secs. nqcmd will run until <secs> elapses.
-qsel r = select queries random manner from inputsqlsfile.
-ds <secs> = dump statistics to outputfile_Counters.txt every <secs>.
-T = Timer is on. Otherwise you won’t get correct statistics.
-t <number> = generate users . if you give -t 50, 50 users will be there.
-q = turn off row output - mandatory flag for nqsserver load testing.
-n <number> = used for login test run for <number> iterations.
-w = thinktime (in seconds).
Monday Feb 03, 2014
By user809526 on Feb 03, 2014
Friday Jan 31, 2014
By Ahmed Awan on Jan 31, 2014
New updates have been made to the OBIEE "Best Practices Guide for
Infrastructure Tuning" whitepaper. This updated whitepaper is for 11g Release 1 (22.214.171.124, 126.96.36.199) and can be
downloaded from the My Oracle Support knowledge article: Doc ID 1333049.1
The new revised document contains the following useful new and/or updated tuning items:
- Optimized JVM switches for Oracle JRockit / Sun JVM / IBM JVM etc
- New tuning parameters settings / values for JavaHost / OPIS / OBIS components.
- Improved BIEE / platform performance monitoring techniques.
- IBM WebSphere tuning parameters.
- More WebLogic Server tuning parameters.
- Windows Server 2012 tuning parameters.
- New optimized Linux / AIX tuning parameters.
- Additional Essbase ASO tuning parameters.
- libOVD authenticator search tuning
And many more….
Tuesday Jan 28, 2014
By user809526 on Jan 28, 2014
This second post continues with the BIEE security checks using WLST and python. This time, the following information is gathered about BISQLGroupProvider:
* looking for SQLGroupProvider in the configured providers
* retrieving the SQL queries
* retrieving the JDBC source details
* testing the connection pool, for each server that uses it (make sure your BI server is up and running)
* testing the SQL queries directly against the database, with the test.user and test.group provided in the automation.properties file
Friday Jan 24, 2014
By user809526 on Jan 24, 2014
Wednesday Jan 22, 2014
By Jane Story on Jan 22, 2014
Tuesday Jan 07, 2014
OBIEE 11.1.1: Load Testing Oracle Business Intelligence Enterprise Edition (OBIEE) 11g Using Oracle Load Testing (OLT) 12.x
By Ahmed Awan on Jan 07, 2014
Published whitepaper on Load Testing Oracle Business Intelligence Enterprise Edition (OBIEE) 11g Using Oracle Load Testing (OLT) 12.x) which can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=1611188.1(Oracle Support Document 1611188.1)
Monday Dec 09, 2013
By user809526 on Dec 09, 2013
OBIEE web services provide a large set of operations on ibots, jobs, metadata, analysis, webcat...
Saturday Nov 23, 2013
By Keith Rosenthal on Nov 23, 2013
Planning allows users to enter date values in Planning. For example, a start date can be entered as 11/01/2013 if the format is MM/DD/YYYY. Although the values are entered in date format, it is possible to calculate values based on dates entered.
Thursday Oct 17, 2013
By Ahmed Awan on Oct 17, 2013
Applies To: This edition applies to only 188.8.131.52, 184.108.40.206.
One of the most challenging aspects of performance tuning is knowing where to begin. To maximize Oracle EPM System performance, all components need to be monitored, analyzed, and tuned. This guide describe the techniques used to monitor performance and the techniques for optimizing the performance of EPM components.
TOP TUNING RECOMMENDATIONS FOR EPM SYSTEM:
Performance tuning Oracle Hyperion EPM system is a complex and iterative process. To get you started, we have created a list of recommendations to help you optimize your Oracle Hyperion EPM system performance.
This chapter includes the following sections that provide a quick start for performance tuning Oracle EPM products. Note these performance tuning techniques are applicable to nearly all Oracle EPM products such as Financial PM Applications, Essbase, Reporting and Foundation services.
1. Tune Operating Systems parameters.
2. Tune Oracle WebLogic Server (WLS) parameters.
3. Tune 64bit Java Virtual Machines (JVM).
4. Tune 32bit Java Virtual Machines (JVM).
5. Tune HTTP Server parameters.
6. Tune HTTP Server Compression / Caching.
7. Tune Oracle Database Parameters.
8. Tune Reporting And Analysis Framework (RAF) Services.
9. Tune Oracle ADF parameters.
Click to Download the EPM 220.127.116.11 Infrastructure Tuning Whitepaper (Right click or option-click the link and choose "Save As..." to download this pdf file)
Tuesday Oct 15, 2013
By Ann Donahue on Oct 15, 2013
By default, Essbase will automatically backup the Essbase security file, Essbase.sec, every 300 seconds (5 minutes). Most customers find the frequency of the default backup interval overhead to be unnecessary given their security update needs. It is recommended to change the default setting before the “build” and “go-live” phases to have better Essbase.sec file backups proportionally spaced between backups and improve overhead.
Thursday Sep 26, 2013
By user809526 on Sep 26, 2013
Wednesday Sep 04, 2013
By Jane Story on Sep 04, 2013
ODL (Oracle Diagnostic Logging) information is recorded for both the Essbase agent and the Essbase application server. The level of the logging that is recorded can be amended if required.
These are the 2 ODL logs for Essbase:
- EssbaseAgentODLLogger is for the Essbase agent. This writes to the ESSBASE_ODL.log in MIDDLEWARE_HOME/user_projects/epmsystem1/diagnostics/logs/Essbase/Essbase
- DefSvrLogger is for the Essbase application server (ESSSVR). This writes to the <appname>_ODL.log in MIDDLEWARE_HOME/user_projects/epmsystem1/diagnostics/logs/Essbase/Essbase/app/<appname>
The level of logging for these Essbase ODL logs is controlled by the logging.xml file.
A blog focused on Tips & Tricks about Oracle Business Intelligence (OBI), Oracle Exalytics and Oracle Enterprise Performance Management (EPM) products.
[Blog Admin: ahmed awan]