access denied for user to path /users/weblogic

Hi,

Installed Drive :\Oracle\Middleware\instances\instance2\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\YourCatalog\root\users

1. delete the <user> folder and <user>.atr
2. Restart the BI services
3. Login using the user.

fyi:
https://forums.oracle.com/forums/thread.jspa?threadID=2193737
https://forums.oracle.com/forums/thread.jspa?messageID=10019813
or try to refereshing GUID users account

http://bimetrics.wordpress.com/tag/obiee11g-11g-refresh-guid-migrating-rpd-catalog-between-environments-weblogic-error-codes-o9xnzmxb-access-denied-for-user-to-path-usersweblogic_portaldashboard-layout/


Thanks

Deva

Application role migration from DEV to UAT

Application role migration from DEV to UAT

1) To migrate security there is a WLST method called as MigrateSecurityStore which can move the roles from one system-jazn-data.xml to the other. To do that, we need to first copy the system-jazn-data.xml from Dev instance to the Prod instance (to a temporary directory). In the same way copy the system-jazn-data.xml from the Prod instance to the temporary directory.

2) Take a backup of all these files before doing the migration. Now, copy the jps-config.xml from any one of the instances (Dev or Prod) to the temporary Directory. And rename the file to jps-config-policy.xml.

3) Open up the jps-config-policy.xml. You will notice that this file contains all the details about all the stores in the environment. Now, for policy migration, we need to basically use this file to point to the locations of the Dev and Prod (source & target) system-jazn-data.xml files. Also, since we are doing only policy migration, we do not need the other store related tags within this file. Remember that we are modifying only a copy of the jps-config.xml. This copy file will be used only for migration.

You will need the following lines for migration:

<!-- JPS XML Policy Store Service Instance -->

<serviceInstance name="policystore.xml" provider="policystore.xml.provider" location="c:/temp/dev/system-jazn-data.xml">
<description>File Based Policy Store Service Instance</description>
</serviceInstance>

<serviceInstance name="policystore.xml" provider="policystore.xml.provider" location="c:/temp/prod/system-jazn-data.xml">
<description>File Based Policy Store Service Instance</description>
</serviceInstance>


4) Now that we have our jps-config file ready, navigate to the temporary directory from command prompt and initialize the WLST using the following command.

In WLST, application role migration can be done even in offline mode. So, effectively there is no need for us to connect to the weblogic admin server. In offline interactive mode, fire the following command

migrateSecurityStore(type=”appPolicies”, srcApp=”obi”, configFile=”C:/SecurityMigration/jps-config-policy.xml”, src=”sourceFileStore”, dst=”targetFileStore”, overWrite=”false”)

Thanks

Deva

Date format into Timestamp with AM/PM

Hi,

In Answres,

MM/DD/YYYY format but I want to dispaly it in MM/DD/YYYY HH:MM AM

You can try below in custom date format:

MM/dd/yyyy hh:mm tt

for more :
https://forums.oracle.com/forums/thread.jspa?threadID=2312541&tstart=0

Thanks

Deva

How to Apply Patches Using Opatch

Hi,

Step:1  Ensure you have the latest Opatch:

Make sure you have the latest supported version of OPatch downloaded.

You can download the latest Opatch and install it in the directory on your machine under:
D:\Oracle\Middleware\Oracle_BI1\OPatch

Step 2 : Download the patch to PATCH_TOP

Download the patch to PATCH_TOP directory, as instructed in the README

Step: 3
 cd to patch (for example 10042883) directory:
D:\PATCH_TOP>cd 10042883

Step 4 : Make sure Opatch is in the PATH
Add D:\OPatch to the PATH:
D:\PATCH_TOP\10042883>set PATH=%PATH%;D:\Oracle\Middleware\Oracle_BI1\OPatch
Verify that the PATH is set:
D:\PATCH_TOP\10042883> PATH <Enter>
Step 5 : Set ORACLE_HOME

Set ORACLE_HOME to your BI Home.
For example, in this case,  BI Home is set to D:\Oracle\Middleware\Oracle_BI1
D:\PATCH_TOP\10042883>set ORACLE_HOME=D:\BI11\Oracle_BI1<Enter>
Verify that the Oracle Home is set correctly:
D:\PATCH_TOP\10042883>echo %ORACLE_HOME% <Enter>

Note: You are setting ORACLE_HOME for this command-prompt session only. This is set to only facilitate patch application/rollback/inventory, etc. Do not make this a permanent environment variable as it will affect other Oracle Products running on your system which may need a permanent ORACLE_HOME environment variable.

Step 6 : Verify Opatch version

Verify you have the correct OPatch version:
D:\PATCH_TOP\10042883>opatch version <Enter>
Invoking OPatch 11.1.0.8.3
OPatch Version: 11.1.0.8.3
OPatch succeeded.
Step 7 : Apply the OBIEE patch (for example 10042883)
7.1: Shutdown all BI services:
Apply patch 10042883 -- Before applying any OBIEE patch, make sure all
BI Services are shut down.
Start->Programs->Oracle BI->Stop BI Services
7.2: Apply the patch:
D:\PATCH_TOP\10042883>opatch apply <Enter>

If you are running a 64-bit OS: Windows64bit / Linux 64bit / AIX 64bit, make sure
you use the following command:
opatch apply -jre %ORACLE_HOME%/jdk/jre <Enter>
OPatch succeeded.
Step 8 : lsinventory command
Verify that the patch was applied correctly by checking the inventory:
D:\PATCH_TOP\10042883>opatch lsinventory <Enter>
If you are running a 64-bit OS: Windows64bit / Linux 64bit / AIX 64bit, make sure
you use the following command:
opatch lsinventory -jre %ORACLE_HOME%/jdk/jre <Enter>

For more info refer below Oracle Doc:

https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=BULLETIN&id=1220799.1

Thanks

Deva

obiee-11g-auto-start-all-with-windows

OBIEE 11.1.1 - How to Install Windows Services For OBIEE 11g AdminServer And BI Managed Server?

Following Fusion Middleware 11g components are configured by default as MS Windows Services:

• Weblogic Node Manager
  (configured as a MS Windows Service if Custom Install route is chosen when installing Weblogic)
• FMW 11g Process Manager (OPMN)
  (installed as a MS Windows Service if a System Component Instance is configured)

This article shows how to install the WebLogic AdminServer and BI Managed Server as MS Windows Service for the OBIEE 11g installation.



a. For Administration Server

Note: If you install OBIEE 11g version 11.1.1.5 with the Simple Install type, then you will only have an AdminServer and not a BI Managed Server; therefore, the Managed Server section would not apply in that specific version and installation type.

1.   Configure the boot.properties to create an encrypted method to automatically pass the username and password

Create a text file in the location: 

Note: With OBIEE 11.1.1.5, if you have used the Start BI Services from the menu, then it would have automatically created a boot.properties file the first time it was invoke.

%middleware_home%\user_projects\domains\bifoundation_domain\servers\AdminServer\security\boot.properties

For example, if the middleware_home is c:\BI11g, then the boot properties needs to be here:

C:\BI11g\user_projects\domains\bifoundation_domain\servers\AdminServer\security\boot.properties

Add the following lines:

username=[the Administrator username created during install, e.g weblogic]
password=[the weblogic username password e.g welcome1]

Note: the above credentials are the same as the one provided when the AdminServer is started from Command line.

Do not use or leave the brackets [ ] in the file. They are only used to show what should be entered.
As soon as you start the Admin Server the username and password values in this file will be encrypted

2.   Create a command script called installAdmServer_Service.cmd.

Open a text file and input the following lines [edit for your install]:  

echo off

SETLOCAL

 set MW_HOME=D:\Oracle\Middleware

set OPMN_PORT=9500

set wls.host=hostmane

set wls.admin.port=7001

set wls.mgd.port=9704

set wls.mgd.name=bi_server1

set BI_URL=http://IP:9704/analytics

set JAVA_HOME=D:\Oracle\Middleware\Oracle_BI1\jdk

set PRODUCTION_MODE=true

set DOMAIN_HOME=D:\Oracle\Middleware\user_projects\domains\bifoundation_domain

set WLS_HOME=%MW_HOME%\wlserver_10.3

set INSTANCE_HOME=D:\Oracle\Middleware\instances\instance1

set ORACLE_BI_HOME=D:\Oracle\Middleware\Oracle_BI1

set ANT_HOME=%MW_HOME%\modules\org.apache.ant_1.7.1

set DOMAIN_NAME=bifoundation_domain

set USERDOMAIN_HOME=D:\Oracle\Middleware\user_projects\domains\bifoundation_domain

set SERVER_NAME=AdminServer

call "D:\Oracle\Middleware\user_projects\domains\bifoundation_domain\bin\setDomainEnv.cmd"

call "D:\Oracle\Middleware\wlserver_10.3\server\bin\installSvc.cmd"

ENDLOCAL

      Please note that the middleware home values need to be specific to your install

3.   For troubleshooting / debugging purposes it is helpful to redirect standard out and error to a text file.

      Although most information is captured in the AdminServer server log files, you will not see all standard out and error when the server is started via a MS Windows Service (unlike when you start an AdminServer in console modefrom the command prompt using startWebLogic.cmd). To redirect standard out to a text file, backup and edit installSvc.cmd file and change the line at the bottom of the file so it includes the -log parameter. For example:

rem *** Install the service

"%WL_HOME%\server\bin\beasvc" -install

-svcname:"beasvc %DOMAIN_NAME%_%SERVER_NAME%"

-javahome:"%JAVA_HOME%"

-execdir:"%USERDOMAIN_HOME%"

-maxconnectretries:"%MAX_CONNECT_RETRIES%"

-host:"%HOST%"

-port:"%PORT%"

-extrapath:"%EXTRAPATH%" -password:"%WLS_PW%"

-cmdline:%CMDLINE%

-log:"D:\Oracle\Middleware\user_projects\domains\bifoundation_domain\AdminServer-stdout.txt"

4.     Next,  run "installAdmServer_Service.cmd" and the service should be installed, it will have a name like "beasvc %DOMAIN_NAME%_%SERVER_NAME%" (e.g. beasvc bifoundation_domain_AdminServer)  

The Service "Startup Type" will be 'Automatic'. Just like any other MS Windows Service you can change the 'Startup Type' to 'Manual'.

Start the Service. The Service will come back fairly quickly to say it is started. The actual time taken for AdminServer to start and reach a state of 'RUNNING' will be longer - perhaps two or three minutes. The state of the server can be monitored by reviewing the stdout txt file.

Notes: An alternative to the boot.properties approach to specifying the Admin Server weblogic username / password is to add the following environment variables to your wrapper cmd script - installAdmServer_Service.cmd
set WLS_USER=[user]
set WLS_PW=[password] 

Note: Do not use or leave the brackets [ ] in the file. They are only used to show what should be entered.  

To quote the documentation, "The beasvc utility encrypts the login credentials and stores them in the Windows registry."
This is one of two possible methods for avoiding the username/password prompt when a server instance starts. The disadvantage to this method is that changing the username or password for the server instance requires you to delete the Windows service and set up a new one with the new username and password. Instead of this method, you can use a boot identity file. With a boot identity file, you can change the login credentials without needing to modify the Windows service.

b. For Managed Server bi_server1  

1. Configure the boot.properties to create an encrypted method to automatically pass the username and password

Create a text file in the location:

%middleware_home%\user_projects\domains\bifoundation_domain\servers\bi_server1\security\boot.properties

For example:

C:\BI11g\user_projects\domains\bifoundation_domain\servers\bi_server1

where the BI11g is your middleware home.

Add the following lines:

username=[the Administrator username created during install, e.g weblogic]
password=[the weblogic username password e.g welcome1]
Note: the above credentials are the same as the one provided when the AdminServer is started from Command line.
As soon as you start the BI Managed Server the username and password values in this file will be encrypted.
The alternative approach - like for AdminServer - is to specify WLS_USER and WLS_PW in the wrapper cmd script. See next point

2.     Create a command script called installManagedSrvr_Service.cmd which has lines like:

SETLOCAL

set DOMAIN_NAME=bifoundation_domain

set USERDOMAIN_HOME=D:\Oracle\Middleware\user_projects\domains\bifoundation_domain

set SERVER_NAME=bi_server1

set PRODUCTION_MODE=true

set ADMIN_URL=http://IP:7001

set JAVA_HOME=D:\Oracle\Middleware\Oracle_BI1\jdk

set PRODUCTION_MODE=true

set DOMAIN_HOME=D:\Oracle\Middleware\user_projects\domains\bifoundation_domain

set WLS_HOME=%MW_HOME%\wlserver_10.3

set INSTANCE_HOME=D:\Oracle\Middleware\instances\instance1

set ORACLE_BI_HOME=D:\Oracle\Middleware\Oracle_BI1

set ANT_HOME=%MW_HOME%\modules\org.apache.ant_1.7.1

set DOMAIN_NAME=bifoundation_domain

call "D:\Oracle\Middleware\user_projects\domains\bifoundation_domain\bin\setDomainEnv.cmd"

call "D:\Oracle\Middleware\wlserver_10.3\server\bin\installSvc.cmd"

ENDLOCAL

Notes:

o    Before running, change the -log parameter in the installSvc.cmd file to the new location. Fore example:

-log:"[middleware_home]\user_projects\domains\bifoundation_domain\servers\bi_server1\bi_server1-stdout.txt"

o    The ADMIN_URL value should reference the AdminServer hostname and listen port

o    The SERVER_NAME value is case sensitive. For example, if you are creating a MS Windows service for a different managed server such as 'wls_ods1' then the value needs to match the case of the server name otherwise the startup of the server via the MS Windows service will fail.

o    Be careful that there are no trailing spaces after each line in the command file - trailing spaces will cause the managed server to fail at startup. For example a trailing space in the ADMIN_URL value will result in the error

<19-Jan-2010 11:37:58 o'clock GMT> <Error> <EmbeddedLDAP> <BEA-171524> <Cannot determine the Listen address for the Admin server

3.   Now run "installManagedSrvr_Service.cmd". The Service should be installed, it will have a name like "beasvc %DOMAIN_NAME%_%SERVER_NAME%" (e.g. - beasvc bifoundation_domain_bi_server1)

The Service "Startup Type" will be 'Automatic'. Just like any other MS Windows Service you can change the 'Startup Type' to 'Manual'.

Start the Service. The Service will come back fairly quickly to say it is started. The actual time taken for the managed server to start and reach a state of 'RUNNING' will be longer - perhaps two or three minutes. The state of the server can be monitored by reviewing the stdout txt file.
4.   Ensure you make the managed Server to a manual startup so this service can be started after the AdminServer is started.
5.  You may choose to start the managed server from the AdminServer instead of from creating the MS Windows service which is the recommended practice.
6.  First start the Node Manager, Admin Server and the Managed Server in this Order.
You can start the BI Server components either from FMW Control or from the OPMN Command line.

Note: If you start the servers as a service, then any parameters, such as JVM parameters need to be modified in the registry at:
If you want to view these parameters, open up the MS Windows Registry Editor (regedit) and navigate to:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\beasvc <your domain>_<managed server name>\Parameters

Be sure and double-check the parameter settings such as the the path for the JVM, the hostname and the port; otherwise the service may not start properly

Otherwise, the parameters can be modified in the command shell scripts

See the WebLogic documentation for installing the NodeManager as a service. 

For more Reference:

1) http://blogs.oracle.com/pa/entry/obiee_11_1_1_how3

2) How to Install MS Windows Services For FMW 11g WebLogic Domain Admin and Managed Servers? [ID 1060058.1]
3) How to Install Windows Services For OBIEE 11g AdminServer And Managed Server [ID 1214693.1]

4) http://blogs.oracle.com/pa/entry/obiee_11_1_1_how3


5) http://deliverbi.blogspot.com/2010/10/obiee-11g-auto-start-all-with-windows.html

6) http://download.oracle.com/docs/cd/E14571_01/web.1111/e13708/winservice.htm#i1186180

7) How to Install MS Windows Services For FMW 11g WebLogic Domain Admin and Managed Servers? [ID 1060058.1]

8) http://gerardnico.com/wiki/dat/obiee/windows_service_11g

9) http://shumonkhan.blogspot.com/2010/08/how-to-install-ms-windows-services-for.html

Thanks
Deva

OBIEE11g Changing unchangeable cells -Pivot table

Hi,

   [br/]<script type="text/javascript">
var tds = document.getElementsByTagName('td');
var lCSS = new Array();
for(var td=0;td<tds.length;td++){
if( tds[td].className != 'PTCC'){
continue;
}
tds[td].style.backgroundColor="#F1E87D";
// Info on property naming: http://codepunk.hardwar.org.uk/css2js.htm
lCSS.push(tds[td].innerHTML);
}
for(var len =0; len < lCSS.length; len++){
//document.write("Bingo " + "<BR>");
//debug only
}
</script>

fyi..see the screen short:

https://forums.oracle.com/forums/thread.jspa?threadID=2306222&tstart=0

For more: refer Joe post..in obiee10g version
http://obiee101.blogspot.com/2010/02/obiee-changing-unchangeable-cells.html
 

List of Bug Fixes Included In OBIEE 11.1.1.5.0

Hi,

Admin Tool
•7538753 SAP BW IMPORT DOES NOT RETRIEVE UNIQUE NAME FOR MEASURE COLUMNS
•10012297 ADMIN TOOL CRASH ON VERY LARGE EXPRESSIONS – OVERFLOW AT APPROX 3200 CHARACTERS
•10032385 TABLE MISSING IN SQL “FROM” CLAUSE – FWD PORT 8308443 TO 11G
•10045212 EQUALITY EXPRESSION IN LTS “WHERE” CAUSES INTERNAL SQORRQLIST ERROR ON QUERY



•10264475 ADMINISTRATION’S “SHUTDOWN SERVER” MENU SHOULD BE REMOVED
•10265121 ADMIN TOOL EXPRESSION BUILDER CRASHES ON DOUBLE-BYTE LOGICAL COLUMN NAME
•10394725 ON-LINE MODE CHECK-IN OF DYNAMIC INIT BLOCK CAUSES [43058] REFRESH LOCK FAILURE
Answers
•6521146 ERROR: “NO FILTER” WHEN USING “COMBINE WITH SIMILAR REQUEST” – UNION
•7534635 INACTIVATING DRILLDOWN ON COLUMN VALUE ALSO INACTIVATES COLUMN HEADER LINK
•9026854 CLARIFICATION REGARDING DATA FORMAT WHEN COMBINING REQUESTS
•9107277 KEEP THE NUMBER PRECISION IN DATABASE WHEN “DOWNLOADING TO EXCEL”
•9524080 PIVOT TOTAL DIFFERENT TO TABLE TOTAL WHEN REPORTAGGREGATEENABLED TRUE
•9697529 JAPANESE CHARACTER SET NOT PASSED CORRECTLY TO DRILL REPORT IN FIREFOX BROWSER
•9871470 SORTING ON A NULL VALUED COLUMNS GIVES ASSERTION ERRORS
•9886904 CORRECT DOC FOR ADDING CUSTOM DATE FORMAT STRING
•9918283 CORRECT DASHBOARD FORMATTING PROBLEMS WITH SCROLLING
•9928318 ROW HEADER MISSING AT PIVOT TABLE VIEW FOR MIGRATED REPORTS IN 11G
•9968574 SOME UPGRADED 10G CHARTS SHOW UP JAVA EXCEPTION
•10023165 MAPS DO NOT WORK IN MAP VIEWS WHEN JOIN COLUMN CONTAINS A “&” CHARACTER
•10065166 GAUGE RANGE IS NOT UPDATED WHEN IT CHANGES THE FIELD VALUE
•10078041 ACTION LINK DOES NOT WORK WHEN COMPOUND LAYOUT ONLY HAS A MAP VIEW
•10091354 “SCALE MARKERS” OPTION IS MISSING IN VERTICAL AXIS 2
•10147762 CANNOT SET GAUGE FOOTER (TITLE), KEEPS SHOWING “UNDEFINEDUNDEFINEDUNDEFINED”
•10182955 BUBBLE CHART IS NOT BEHAVING AS EXPECTED
•10213761 CONDITIONAL DASHBOARD SECTIONS (GUIDED NAVIGATION) ALWAYS RUNS REPORTS
•10229397 CANNOT SAVE REQUEST USING STANDARD DATE FORMATS.
•10282140 CELL IMAGE AT BLANK CELL OF PIVOT TABLE IS NOT DISPLAYED WHEN USING COND FORMAT
•10296730 UNABLE TO USE PRESENTATION VARIABLE IN SCALE MARKERS
•10312496 CHARTS. MEASURE LABEL IN GRAPH PROMPTS DOES NOT CHANGE CONTENT OF THE CHART
•10312795 ACTION LINK ON COLUMN HEADING NAVIGATION DOES NOT CONSIDER PROMPT VALUES
•10329343 CLICKING A LINE GRAPH BETWEEN TWO DATA POINTS DRILLS TO LAST VALUE IN HORIZONTAL
•10337649 PIVOT TABLE SHOWS BUTTONS FOR SORTING ON CALCULATED ITEMS.
•10402102 INCORRECT RESULT WHEN USING [NEW CALCULATED ITEM] PROP IN PIVOT TABLE
•10414887 DRILL DOWNS NOT WORKING IN CHART PIVOTED TABLE SELECTED FROM VIEW SELECTOR
•10418875 CHART SIZE IS CHANGING AFTER WEBCAT UPGRADE FROM 10G
•10634175 GRAPH ENGINE IS NOT RESPONDING
•10639913 COMPLETE TEXT IS NOT SAVED IN DB IF CURSOR IS MOVED AWAY DURING INSERT
•11711658 FILTER NEEDS TO SUPPORT UNTYPE LITERAL FOR RANK OPERATOR AS 10G DOES
•11805468 CUSTOMIZED GAUGE VIEW IS NOT CONSISTENT WHEN EXPORTED AS PDF,HTML AND XLS
•11817696 INCORRECT FILTER IS BUILT IF FILTER IS CONTRUCTED BEFORE SELECTING REQ. COLUMNS
•11845286 PIVOT TABLE WITH PERCENTAGES, GRAPHED PERCENTAGE VALUES DISPLAYED ARE INCORRECT
•11894921 GRAPH LABEL OPTIONS NOT AVAILABLE IN 11G
•11895279 INCORRECT FILTER VALUE WHEN USING ACTION LINK WITH GRAPH
•12412666 ALL PAGES LOSES CONDITIONAL FORMATTING
•12561361 PSE FOR BASE BUG 10295403 ON TOP OF 11.1.1.5.0 FOR GENERIC OS
CHARTING

•8990756 MISLEADING INFORMATION IN DOC REGARDING PIVOT TABLE SETTINGS
DASHBOARDS
•7459700 ABILITY TO SPECIFY FIXED COLUMN WIDTH TO A DASHBOARD PROMPT
•10177865 OBIEE 11G : DEFAULT VALUES CANNOT BE DE-SELECTED FROM MULTI SELECT PROMPT
•10279722 DASHBOARD SLIDER PROMPT SHOWS THUMB VALUES WITH TWO DECIMAL PLACES FOR INTEGERS
•10279829 DASHBOARD SLIDER PROMPT SHOWS WRONG VALUES FOR “ALL COLUMN VALUES” OR “SPECIFIC
•10310511 “REQUIRE USER INPUT” MESSAGE APPEARS THE FIRST TIME ONLY FOR THE REQUIRED PROMPT
•10389799 DASHBOARD NAVIGATION MAY CAUSE GETELEMENTBYTAGNAME ERROR IN IE
•10411545 PROMPT WITH BETWEEN OPERATOR AND SQL DEFAULT VALUES ARE NOT UPGRADED PROPERLY
•11056057 ERROR WHILE UPGRADING THE DASHBOARD WITH CERTAIN FILTER FUNCTIONS
•11076452 ABILITY TO CONSTRAIN PROMPTS AGAINST A SLIDER PROMPT
•11717024 ERROR 500 OCCURS WHEN SETTING ACCESSIBILITY MODE TO ON
•12620143 PSE FOR BASE BUG 12561330 ON TOP OF 11.1.1.5.0 FOR LINUX X86 [46] (PSE #602152)
INSTALL
•9459177 PREREQUISITES FOR DEPLOYMENT ON SEPARATE MACHINES
•9540009 UNIXCHK.SH ENCOUNTERS HOST NOT FOUND ERROR WHEN DNS IS NOT AVAILABLE.
•10071302 ENTERPRISE INSTALL: CONFIGURE PORTS : FORMAT OF INI FILE
•10126542 OBIEE 11G INSTALATION FAILS AT AS INSTANCE CREATION DUE TO PERM SIZE ERROR
•10287335 CANNOT START BISERVER1 . SWITCH TO JSSE FRAMEWORK REQUIRED
•10302421 OBIEE 11G WINDOWS PROMPTS FOR USERNAME / PASSWORD AFTER ENCRYPTING CREDENTIALS
•11849674 SAG: DISCREPANCY IN DOCUMENTED ORACLE DATABASE REQUIRED FOR MAPVIEWER
MIGRATION
•7432799 ORACLE EUL CONVERTER CRASHED WHILE GENERATING A REPOSITORY
REL_NOTES
•12604761 TWO STEPS OF THE UPGRADE TO 11.1.1.5.0 ARE NOT CLEARLY DOCUMENTED
SCHEDULER
•10036466 “RE-RUN INSTANCE(S) NOW” MENU IS NOT AVAILABLE FOR COMPLETED JOB INSTANCES
SECURITY
•8996295 PROVIDE DETAIL INFORMATION TO SETUP WNA(KERBEROS) FOR OBIEE AUTHENTIFICATION
•9216995 PROVIDE LATEST DETAIL INFORMATION ABOUT HOW TO SETUP LDAP SSL FOR OBIEE
•10194154 TECHNOTES- PROVIDE DETAIL INFORMATION TO SETUP WNA(KERBEROS) FOR OBIEE AUTHENT
•10198837 BIEEHOME LOGIN PAGE IS NOT DISABLED EVEN AFTER ENABLING THE SSO
•10218031 USING EXTERNAL DB TABLE TO SET ROLES SESSION VARIABLE DOESN’T ACCEPT LONG NAMES
•10373788 IF OBJECTGUID PUBLISHED AND SAMACCOUNTNAME CHANGED USER CANNOT CONNECT ANYMORE
•11731080 QA:SECURITY GUIDE NEEDS UPDATE FOR DEFINING A USER SESSION VARIABLE
SERVER
•6510747 NETWORK FAILURE DURING PHYSICAL QUERY HANGS END USER WITHOUT ERROR MESSAGE
•6836444 OBIEE SERVER SYSTEM DATE IS WRONG AND DOES NOT MATCH MACHINE SYSTEM DATE
•8371912 BI SERVER CRASHES ON NAVIGATION SPACE MAP RACE – SR 3-887711721
•9433198 DOCUMENT SYSLOG ENTRIES IN SYSTEM ADMINISTRATOR’S GUIDE
•9696424 DOC INSTANCECONFIG PARMS ALLOWEDLANGUAGES & ALLOWEDLOCALES IN SYSADMIN GUIDE
•9954411 PSR:MOD_SUPPORTED NOT ENABLED FOR TERADATA AND CAUSES CAMPAIGN SLOW PERFORMANCE
•10258683 REQUEST WITH COMPLEX FILTER IS CONSUMING ALMOST ALL CPU & NO SESSION IS CREATED
•10258755 EXCEL FAILS TO CONNECT TO 11G BI SERVER USING ODBC DSN
•10335924 REPORT-BASED TOTALS FAIL ON MEASURES CONTAINING AGGREGATION EXPRS SUCH AS FILTER
•10374571 NEED FLEXIBILITY TO OVERRIDE HOSTNAMES WHEN CUSTOMER DNS IS INCORRECT OR BROKEN
•10650122 PIVOT VIEW WITH UNION OF NON – COMPATABLE TYPE ERROR IN OBIEE 11G AFTER UPGRADE
•11804596 NQQUERY LOG LEVEL 2 IS TOO VERBOSE – BACKPORT 10308263 TO 11.1.1.5
•11809295 NQUDMLGEN NOT GENERATING UDML FILE IN UTF FORMAT
UPGRADE
•9886765 ERRORS ENCOUNTERED WHEN UPGRADING WEB CATALOG USING UA.BAT
•10121344 ERROR IN LOG USING UA TO UPGRADE BI SCHEDULER SCHEMA ON SQL SERVER DATABASE
•11069928 UPGRADE SHOULD HANDLE PROMPT WITH INCONSISTENT VALUES AS 10G DOES
WEB_ADMIN
•8564456 SHARED FOLDER ACCESS PERMISSION ISSUE
•9381764 CATALOG MANAGER COPY FUNCTION NOT WORKING AS EXPECTED
•9739865 EXITING MANAGE SESSION RESULTS IN HTTP ERROR
•10016252 LACKING INFORMATION ON FORCEABSOLUTECOMMANDURL FOR ABSOLUTECOMMANDURLPREFIX
•10144989 WEB CATALOG DOES NOT UPGRADE TO 11.1.1.3.0
•10218524 VALIDATION ERROR AFTER THE UPGRADE OF WEBCATALOG TO OBIEE 11G
•11723425 INCORRECT DEFAULT VALUE OF DEFAULTROWSDISPLAYED IN THE INSTANCECONFIG.XML
•11827202 OPMN NOT STARTING AFTER SETTING UP THE REPLICATION AGENT
WEB_GNRL
•10191078 FILTER VALUES ARE RESET IN GO URL WHEN COLUMNS ARE SORTED OR RE-ARRANGED
•10360461 NEED ABILITY TO CONTROL NEW, DASHBOARD AND OTHER HEADER LINKS
•11780508 10G COLUMN FILTER PROMPT WITH PROMPTCAPTION ATTR NOT UPGRADING
•12416695 TOOLTIP EMPTY IN MAPVIEWER
WEB_INTGRT
•10294759 FMAP-REFERENCED IMAGES IN ANALYSIS HEADERS DON’T APPEAR IN DOWNLOADS TO EXCEL
WEB_MKTG
•8692820 DIRECT DATABASE CAMPAIGN LOAD FORMAT COMBINED LISTS FAILS
•9908019 SAW SERVER CRASH WHEN LOADING A PARTICULAR CAMPAIGN
•9935859 UNGROUP OF SEGMENT BLOCKS CORRUPTS SEGMENT DEFINTION AND BAD COUNTS
•10331355 MOVING CRITERIA WITHIN A SEGMENT’S GROUP CORRUPTS THE INCLUSION OPTIONS
http://itnewscast.net/database/list-bug-fixes-included-obiee-111150

Thanks

Deva

Refreshing GUID in obiee11g

Hi,

To regenerate user GUIDs:

This task requires that you manually edit the configuration files to instruct Oracle BI Server and Oracle BI Presentation Server to regenerate the GUIDs on restart. Once completed, you edit these files to remove the modification. For information about where to locate Oracle Business Intelligence configuration files, see "Where Configuration Files are Located" in Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.
1.Update the FMW_UPDATE_ROLE_AND_USER_REF_GUIDS parameter in NQSConfig.INI:
a.Open NQSConfig.INI for editing at:
ORACLE_INSTANCE/config/OracleBIServerComponent/coreapplication_obisn
b.Locate the FMW_UPDATE_ROLE_AND_USER_REF_GUIDS parameter and set it to YES, as follows:
FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = YES;
c.Save and close the file.
2.Update the Catalog element in instanceconfig.xml:
a.Open instanceconfig.xml for editing at:
ORACLE_INSTANCE/config/OracleBIPresentationServicesComponent/
coreapplication_obipsn
b.Locate the Catalog element and update it as follows:
<Catalog>
<UpgradeAndExit>false</UpgradeAndExit>
<UpdateAccountGUIDs>UpdateAndExit</UpdateAccountGUIDs>
</Catalog>
c.Save and close the file.
3.Restart the Oracle Business Intelligence system components using opmnctl:
cd ORACLE_HOME/admin/instancen/bin
./opmnctl stopall
./opmnctl startall
4.Set the FMW_UPDATE_ROLE_AND_USER_REF_GUIDS parameter in NQSConfig.INI back to NO.
Important: You must perform this step to ensure that your system is secure.
5.Update the Catalog element in instanceconfig.xml to remove the UpdateAccount GUIDs entry.
6.Restart the Oracle Business Intelligence system components again using opmnctl:
cd ORACLE_HOME/admin/instancen/bin
./opmnctl stopall
./opmnctl startall
   

For More:
 Refreshing in obiee11g
good one
http://obiee11gqna.blogspot.com/2011/10/obiee11g-updating-guids.html

http://varanasisaichand.blogspot.com/2011/08/refresh-user-guids-obiee-11g.html
http://gerardnico.com/wiki/dat/obiee/migration


Reading the Oracle Documentation I see that the refresh of GUIDs need to be done for Presentation services as well. http://download.oracle.com/docs/cd/E14571_01/bi.1111/e10543/privileges.htm#CHDHGAAH

Thanks

Deva

ODBC driver returned an error(SQLExecDirectW).NQSError:46118 out of disk space

Hi,
   
   Error:
   ODBC driver returned an error(SQLExecDirectW).NQSError:46118 out of disk space

Solution : Need to keep minimum 10MB for obiee-disk memory space...after cleaning the drive that issue was resolved.

Thanks
Deva

OBIEE11g Features

Hi,

OBIEE11g Features

1) Multiple Subject Areas

Did you know that Answers reports (Analyses) can now be sourced from multiple Subject Areas?    This is significant as it means you no longer have to cram lots of content into a single Subject Area!

2) Conditional Data Formatting
When you apply Conditional Formatting via "Column Properties" in Answers, there is an additional tab to allow you to conditonally change the "Data Format" as well as the "Style".

3) Case-Insensitive Searching
When using the "search" facility to choose your filter values within Answers, there is now a "Match Case" option that enables you to perform a case-insensitive search.

NOTE: There is also a "Match Case" option when performing member selection

4) Conditional Formatting

Conditional formatting is now possible on Pivot Tables (even on Hierarchical Columns).   

5) Dashboard Prompts

There is a new style of dashboard prompt called a "Variable Prompt" which allows you to specify your own custom list of values for the dashboard prompt (instead of always having to source the values from a Subject Area)

6) Importing RPD Metadata

Within the Physical layer of the RPD, when you right-mouse click on a Connection Pool there is a new "Import Metadata" option.    When adding further tables, this new option is much better than the "File > Import" menu option because all the new metadata will get imported directly into the existing Physical Database (so you won'tyou get another Physical Database created).

To make it even better, this new "Import Metadata" option will perform an incremental update of your existing tables and their columns.   So if you create new columns on your database, the tables in the RPD will be incrementally updated.   


7) Time Series Calculations

There are now 3 types of Time Series calculation available (AGO, TODATE and PERIODROLLING).    Another great enhancement is that it is now possible for report developers to build their own Time Series calculations in Answers, so you no longer have to rely on them being created in the RPD.   


8) Building Subject Areas

In the BI Administration tool, you can right-mouse click on a Business Model and choose the option "Build Subject Areas for Logical Stars and Snowflakes".    This option will automatically create a Subject Area dedicated to each logical fact in your Business Model.    Each Subject Area will one logical fact together with all its related logical dimensions.

9) Archiving/Unarchiving
You can now archive/unarchive BI Presentation Catalog content directly within the dashboard front-end, you no longer need to use the BI Catalog Manager utility.

10) Presentation Variables
It is now possible to assign multiple values to a Presentation Variable.

11) Rename Wizard
In the BI Administration Tool, you can now right-mouse click on an object and choose the "Rename Wizard" option.   This is a short-cut which will invoke the Rename Wizard directly for all the objects you selected.    In OBIEE 10g, you could only invoke the Rename Wizard via the "Tool" menu and it meant you would always have a few extra steps to do the renaming you wanted to.

There is also new new formatting option with the Rename Wizard:  Change all occurences of "_" into a space

12) LDAP Authorization
With the new OBIEE 11g security model, it is now possible for OBIEE to find out the "groups" belonging to a user directly from an LDAP store.    In OBIEE 10g, you could only do this indirectly via a PL/SQL package.

13) BI Publisher - Local Excel Files
It is now possible with BI Publisher 11g to upload your own local MS Excel files and use them as a data source for your BI Publisher reports.

14) RPD File Compression
To reduce storage needs, repositories are now stored in a compressed format. Because of this, you may notice that the size of an RPD file opened and saved in this release is significantly smaller than the size of RPD files from previous releases.

15) Oracle OLAP Integration
OBIEE 11g can now supports Oracle OLAP as a data source.    This means Oracle OLAP is now a definite option for OBIEE if you need to optimise the underlying Data Warehouse.


16) Master-Detail Linking
In addition to "drill-down" and "navigation", there is a new "Master-Detail Linking" capability which allows users to click on one table/graph/map to automatically apply filters to other views within the same Analysis (it can even apply filters to other Analyses on the same Dashboard Page).


17) View Selectors

It is now possible to include Compound Layouts in view selectors.

fyi..refer more:

http://www.peakindicators.com/index.php/knowledge-base/99-obiee-11g-features-the-ones-you-didnt-know

Thanks

Deva

OBIEE Licence supporting components

Hi,
If you are using for practice its available in oracle site for download,else if its for commercial purpose you need to
buy
OBIEE Licence supporting components:
1) Oracle BI Server
2) Oracle BI Answers
3) Oracle BI Interactive Dashboards
4) Oracle BI Delivers
5) Oracle BI Disconnected Analytics:
6) Oracle BI Publisher (formely known as XML Publisher)
7) Oracle BI Briefing Books
8) Hyperion Interactive Reporting
9) Hyperion SQR Production Reporting
10) Hyperion Financial Reporting
11)Hyperion Web Analysis
http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/overview/index.html
for purchase
https://shop.oracle.com/pls/ostore/product?p1=businessintelligencetechnology
FYI...
http://www.oracle.com/technetwork/licenses/standard-license-152015.html

This is the latest Oracle Technology Global Price List; http://www.oracle.com/us/corporate/pricing/technology-price-list-070617.pdf

OBIEE11g Certification Matrix:
http://www.oracle.com/technetwork/middleware/bi/oracle-obia-111151-cert-matrix-525376.xls

http://oraclebi.blogspot.com/2010/09/obiee-11g-certification-matrix-updated.html

Thanks
Deva

Windows 7 Home Premium edition is not supported for installation of OBIEE Server 11.1.1.5

HI,

Windows 7 Home Premium edition is not supported for installation of OBIEE Server 11.1.1.5.

Issue: 1
while installing obiee11.1.1.5.0 (software only install ) on win7 64 bit SP1 version i am getting Executing:opmnctl start coreapplication_obisch1 error at the last step

Issue 2:
OBIEE 11g Install On Windows 7 Hangs At Creating Domain Step (Doc ID 1209259.1)
Refer:http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/bi-11gr1certmatrix-166168.xls

Solution:
Please kindly refer to the Certification matrix available from :
http://www.oracle.com/technetwork/middleware/bi/oracle-obia-111151-cert-matrix-525376.xls

http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/bi-11gr1certmatrix-166168.xls

Windows 7 Home Premium edition is not supported for installation of OBIEE Server 11.1.1.5.

Install OBIEE 11.1.1.5 only on certified platform
ie. Windows 2003 with SP2/R2+
or Windows Server 2008 with SP1+
Window 7 is only certified as an OBIEE client.

For more Refe:SR 3-4684846891: Executing:opmnctl start coreapplication_obisch1 while installing obiee11g (11.1.1.5.0) win64bit

Thanks

Deva

OBIEE 11g Installation and Configuration Steps

Oracle Business Intelligence11g System Requirement

This section contains important information for the system on which you are installing Oracle Business Intelligence11g and the database (MS SQL Server) containing the schemas.requirements: requirements:

Hardware

Disk Space: 20GB or more

Physical Memory: 4GB or more

Available Memory: 1GB or more

Temp Space: 950MB or more

Swap Space: 3GB or more

CPU & Processor: dual-core Intel 32/64 Bit, 2.10GHz or greater

Monitor Display : requires 1024 x 768 minimum resolution
Software Operating System: Windows Xp/Vista/Server 2003/ above with SP2 or higher version
Microsoft Internet Explorer 8.0 above
Microsoft .Net Framework 4.5 SP2 or above version
Static IP Address Required (i.e.: DHCP to access network install Look Back Adopter)
JDK 1.6 or above version
MS SQL Server 2005/2008 Enterprise Edition 32/64 bit
OBIEE 11g (11.1.1.3.0) Version
RCU 11.1.1.3.0 (Repository Creation Utility ) database schema creation

Note By default, TCP/IP properties are configured to use DHCP.

　
　OBIEE 11g Download Link:
http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bus-intelligence-11g-165436.html

http://www.oracle.com/technetwork/middleware/bi/oracle-obia-111151-cert-matrix-525376.xls


Note: Make sure database repository must be created before installation of the components with the Repository Creation Utility (RCU) tool

Database Requirement

Below are the recommended disk space requirements for the database containing the Oracle Business Intelligence Scheduler database tables

500MB Microsoft SQL Server databases for standalone and Business Intelligence applications and deployments

OBIEE 11g and Weblogic Disk Space Requirement

The following list identifies memory requirements for various components.

Use the list as a guideline for determining the memory requirements specific to your

deployment:

WebLogic Administration Server: 750 MB

WebLogic Managed Server running Oracle Directory Integration Platform and

Oracle Directory Services Manager: 720 MB

WebLogic Managed Server running Oracle Identity Federation: 650 MB

Oracle Internet Directory: 75 MB

Oracle Virtual Directory: 105 MB

Oracle Enterprise Manager (EM) Agent: 25 MB

Oracle Process Manager and Notification Server (OPMN): 5 MB

Oracle Identity Management requires 2,200 MB of disk space if you are only installing the software (you select the Install Software - Do Not Configure installation type). If you configure the software, an additional 150 MB of space are required if all components are selected for configuration.

RCU Supported Platforms:

RCU is available only on 32-bit x86 Linux and 32-bit Microsoft Windows operating system platforms. You can run RCU from these machines to connect to any certified versions of Oracle, IBM DB2, or Microsoft SQL Server database in order to create the schemas required by Fusion Middleware components. The database server can be running on any platform that is supported by its respective database.

RCU Schema Creation through MSSQL Server Script :

Note: don’t create short cut database/table creation because you can’t able to succeeded on Metadata configuration in your RCU DB Schema

USE [master]CREATE DATABASE [OracleBI] ON PRIMARY (NAME = N’OracleBI’, FILENAME = N’C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\OracleBI.mdf’ , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )LOG ON ( NAME = N’OracleBI_log’, FILENAME = N’C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\OracleBI_log.ldf’ , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)COLLATE
GO SQL_Latin1_General_CP1_CI_ASEXEC
GO dbo.sp_dbcmptlevel @dbname=N’OracleBI’, @new_cmptlevel=90IF (1 = FULLTEXTSERVICEPROPERTY(‘IsFullTextInstalled’))begin
EXEC [OracleBI].[dbo].[sp_fulltext_database] @action = ‘disable’endGOALTER
GO DATABASE [OracleBI] SET ANSI_NULL_DEFAULT OFF ALTER
GO DATABASE [OracleBI] SET ANSI_NULLS OFF ALTER
GO DATABASE [OracleBI] SET ANSI_PADDING OFF ALTER
GO DATABASE [OracleBI] SET ANSI_WARNINGS OFF ALTER
GO DATABASE [OracleBI] SET ARITHABORT OFF ALTER
GO DATABASE [OracleBI] SET AUTO_CLOSE OFF ALTER
GO DATABASE [OracleBI] SET AUTO_CREATE_STATISTICS ON ALTER
GO DATABASE [OracleBI] SET AUTO_SHRINK OFF ALTER
GO
ALTER
GO DATABASE [OracleBI] SET CURSOR_CLOSE_ON_COMMIT OFF ALTER
GO DATABASE [OracleBI] SET CURSOR_DEFAULT GLOBAL ALTER
GO DATABASE [OracleBI] SET CONCAT_NULL_YIELDS_NULL OFF ALTER
GO DATABASE [OracleBI] SET NUMERIC_ROUNDABORT OFF ALTER
GO DATABASE [OracleBI] SET QUOTED_IDENTIFIER OFF ALTER
GO DATABASE [OracleBI] SET RECURSIVE_TRIGGERS OFF ALTER
GO DATABASE [OracleBI] SET DISABLE_BROKER ALTER
GO DATABASE [OracleBI] SET AUTO_UPDATE_STATISTICS_ASYNC OFF ALTER
GO DATABASE [OracleBI] SET DATE_CORRELATION_OPTIMIZATION OFF ALTER
GO DATABASE [OracleBI] SET TRUSTWORTHY OFF ALTER
GO DATABASE [OracleBI] SET ALLOW_SNAPSHOT_ISOLATION OFF ALTER
GO DATABASE [OracleBI] SET PARAMETERIZATION SIMPLE ALTER
GO DATABASE [OracleBI] SET READ_WRITE ALTER
GO DATABASE [OracleBI] SET RECOVERY FULL ALTER
GO DATABASE [OracleBI] SET MULTI_USER ALTER
GO DATABASE [OracleBI] SET PAGE_VERIFY CHECKSUM ALTER
GO DATABASE [OracleBI] SET DB_CHAINING OFF ALTER

GO
DECLARE
SELECT @collate sysname @collate = convert(sysname, serverproperty(‘COLLATION’))IF ( charindex(N’_CI’, @collate) > 0 )BEGIN
select @collate = replace(@collate, N’_CI’, N’_CS’)exec (‘ALTER database OracleBI COLLATE ‘ + @collate)ENDGO

Go to path like this C:\Deva\ofm_rcu_win32_11.1.1.3.3_disk1_1of1\rcuHome\BIN

\RCU.MS-DOS Batch File type

II) Unzip the RCU zip file into some directory and run the rcu.bat under BIN directory. Make sure your database is up before running the RCU; this will install the BI and Metadata schema. database [OracleBI] SET READ_COMMITTED_SNAPSHOT ON DATABASE [OracleBI] SET AUTO_UPDATE_STATISTICS ON
GO