Administration link is missing for weblogic User(Presentation Services)

Hi,


1. Login to obiee presentation services and append the URL with Managegroups ( http://IPaddress:9704/analytics/saw.dll?Managegroups)
2. Select the "Presentation Server Administrators" group
3. Edit -> search user and add it to this group.
4. Login with the user added and check if he can "Administrator --> mange catalog and permission".

Thanks
Deva

List of bug fixed in OBIEE 11.1.1.6.2

Hi,


 The given below listing of Oracle Business Intelligence Enterprise Edition (OBIEE) bugs which have been fixed in the OBIEE 11.1.1.6.2 release


OBIEE 11.1.1.6.2 (patch 13884769)



Apply the Oracle BI EE 11.1.1.6.2 patches to the existing Oracle BI EE 11.1.1.6.0 or 11.1.1.6.1 system


Bugs Fixed By This Patch:
-------------------------------------------------------------------------------------------------------------------------------
13529697: METADATA DICTIONARY NOT PROPERLY GENERATED WITH HYPHENS IN NAMES 
13902810: CAN'T CREATE EXPRESSIONS IN RPD WITH COLUMN FROM ESSBASE - INVALID 


EXPRESSION
13705487: HIERARCHY OBJECTS ARE MISSING AFTER MERGING RPDS
9665267: COMPARE RPD AND PATCH GENERATION
12977729: HIERARCHICAL COL DRILLING ON MORE THAN ONE PAGE OF RESULTS LOSES FOCUS ON 


DRILL
13688544: 'CASE WHEN' CHANGES TO 'CASEWHEN' IN XML AND CAUSES ERROR WHEN SET XML
13523548: ERROR OUT WHEN USING MULTIPLE DOUBLE COLUMNS IN SAVED FILTERS
13098323: AN ARITHMETIC OPERATION IS BEING CARRIED OUT ON A NON-NUMERIC TYPE
13350175: ADDING FILTER TO DIFFERENT LEVELS OF A HIERARCHY GETS IGNORED IN MDX
13511930: NEW COLUMN CREATED BASED ON TWO DIFFERENT DIMENSIONS RETURNS INCORRECT 


RESUTLS
13522060: RPD SESSION VARIABLE UNABLE TO IDENTIFY THE DYNAMIC SCHEMA NAMES FOR OLAP
13542805: BAD CACHE ENTRY BEING GENERATED
13626491: CONSISTENCY CHECK UPDATE FOR FACT JOINS DIRECTLY WITH A NON LEAF TABLE
13708781: ORACLE OLAP PARENT-CHILD QUERY PERFORMANCE ISSUE - LIMIT TO 


BOTTOMDESCENDANTS
13479613: CANNOT MODIFY REPORT/DASHBOARD WHEN USER HAS READ-WRITE BUT NO DELETE PERMISSION
13529494: REPORT NOT GENERATED WHEN HTML CONTAINS INVALID ATTRIBUTES
13391941: QUERY BUILDER - COLUMNS THAT HAVE SPACES ARE NOT DISPLAYED
13840200: VERSION OF CATMAN SHOWS 11.1.1.6.0 after applying 11.1.1.6.2 opatch



Reference:
https://updates.oracle.com/Orion/Services/download?type=readme&aru=14837401
http://docs.oracle.com/cd/E23943_01/bi.1111/e16452/bi_plan.htm#BABECJJH


Thanks
Deva

Backup OBIEE (RPD, Catalog, Configuration, Roles etc) Daily Basis

Hi,


Steps  to OBIEE11g archive catalog manager on a regular basis create bat like run.bat inthat batch file just include below script


@echo offecho Backing up Repository files…
if not exist "E:\2012\OBIEE_Auto_Run_backup" mkdir "E:\2012\OBIEE_Auto_Run_backup"
copy /Y D:\Oracle\Middleware\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository\Test_BI0003.rpd E:\2012\OBIEE_Auto_Run_backup
echo Backing up web catalog.Please wait….
if not exist "E:\2012\OBIEE_Auto_Run_backup\" mkdir "E:\2012\OBIEE_Auto_Run_backup\"
xcopy /s/Y/Q D:\Oracle\Middleware\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\Test E:\2012\OBIEE_Auto_Run_backup\Test
echo Backing up Configuration files…
copy /Y D:\Oracle\Middleware\user_projects\domains\bifoundation_domain\config\config.xml E:\2012\OBIEE_Auto_Run_backup
echo Backing up User Roles Configuration files…



copy /Y D:\Oracle\Middleware\user_projects\domains\bifoundation_domain\config\fmwconfig\jps-config.xml E:\2012\OBIEE_Auto_Run_backup
copy /Y D:\Oracle\Middleware\user_projects\domains\bifoundation_domain\config\fmwconfig\system-jazn-data.xml E:\2012\OBIEE_Auto_Run_backup
echo Backing up User Configuration files…
copy /Y D:\Oracle\Middleware\instances\instance1\config\OracleBIServerComponent\coreapplication_obis1\NQSConfig.INI E:\2012\OBIEE_Auto_Run_backup
copy /Y D:\Oracle\Middleware\instances\instance1\config\OracleBIServerComponent\coreapplication_obis1\DBFeatures.INI E:\2012\OBIEE_Auto_Run_backup
copy /Y D:\Oracle\Middleware\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1
instanceconfig.xml E:\2012\OBIEE_Auto_Run_backup\web_instanceconfig.xml
copy /Y D:\Oracle\Middleware\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1\credentialstore.xml E:\2012\OBIEE_Auto_Run_backup
copy /Y D:\Oracle\Middleware\instances\instance1\config\OracleBISchedulerComponent\coreapplication_obisch1\instanceconfig.xml E:\2012\OBIEE_Auto_Run_backup\scheduler_instanceconfig.xml
copy /Y D:\Oracle\Middleware\Oracle_BI1\clients\bipublisher\repository\Admin\Configuration\xmlp-server-config.xml E:\2012\OBIEE_Auto_Run_backup
copy /Y D:\Oracle\Middleware\Oracle_BI1\clients\bipublisher\repository\Admin\Security\principals.xml E:\2012\OBIEE_Auto_Run_backup
copy /Y D:\Oracle\Middleware\Oracle_BI1\clients\bipublisher\repository\Admin\Security\security.xml E:\2012\OBIEE_Auto_Run_backup
copy /Y D:\Oracle\Middleware\Oracle_BI1\clients\bipublisher\repository\Admin\DataSource\datasources.xml E:\2012\OBIEE_Auto_Run_backup
copy /Y D:\Oracle\Middleware\Oracle_BI1\bifoundation\web\msgdb\l_en\messages\logonmessages.xml E:\2012\OBIEE_Auto_Run_backup
copy /Y D:\Oracle\Middleware\Oracle_BI1\bifoundation\web\app\res\s_blafp\portal\portallogo.gif E:\2012\OBIEE_Auto_Run_backup
copy /Y D:\Oracle\Middleware\Oracle_BI1\bifoundation\web\app\res\s_blafp\b_mozilla_4\bg_banner.jpg E:\2012\OBIEE_Auto_Run_backup
copy /Y D:\Oracle\Middleware\Oracle_BI1\bifoundation\web\app\res\sk_blafp\answers\answerslogo.gif E:\2012\OBIEE_Auto_Run_backup
echo Backing up User COmmentary war file Please wait...
copy /Y C:\Users\gpc_1bank\Documents\WebApplication_V01\dist\WebApplication1_V01.war E:\2012\OBIEE_Auto_Run_backup
echo Backup Complete!
@pause

For OBIEE10g archive catalog manager on a regular basis create bat like run.bat inthat batch file just include below script
@echo off

echo Backing up Repository files…

if not exist “C:\OBIEE_Backup” mkdir “C:\OBIEE_Backup”

copy /Y C:\OracleBI\server\Repository\samplesales.rpd C:\OBIEE_Backup

echo Backing up Configuration files…

copy /Y C:\OracleBI\server\Config\NQSConfig.INI C:\OBIEE_Backup

copy /Y C:\OracleBI\server\Config\DBFeatures.INI C:\OBIEE_Backup

copy /Y C:\OracleBIData\web\config\instanceconfig.xml C:\OBIEE_Backup\web_instanceconfig.xml

copy /Y C:\OracleBIData\web\config\credentialstore.xml C:\OBIEE_Backup

copy /Y C:\OracleBIData\scheduler\config\instanceconfig.xml C:\OBIEE_Backup\scheduler_instanceconfig.xml

copy /Y C:\OracleBI\xmlp\XMLP\Admin\Configuration\xmlp-server-config.xml C:\OBIEE_Backup

copy /Y C:\OracleBI\xmlp\XMLP\Admin\Security\principals.xml C:\OBIEE_Backup

copy /Y C:\OracleBI\xmlp\XMLP\Admin\Security\security.xml C:\OBIEE_Backup

copy /Y C:\OracleBI\xmlp\XMLP\Admin\DataSource\datasources.xml C:\OBIEE_Backup

copy /Y C:\OracleBI\web\msgdb\l_en\messages\logonmessages.xml C:\OBIEE_Backup

copy /Y C:\OracleBI\web\app\res\s_oracle10\portal\portallogo.gif C:\OBIEE_Backup

copy /Y C:\OracleBI\web\app\res\s_oracle10\b_mozilla_4\bg_banner.jpg C:\OBIEE_Backup

copy /Y C:\OracleBI\web\app\res\sk_oracle10\answers\answerslogo.gif C:\OBIEE_Backup

echo Backing up web catalog.Please wait….

if not exist “C:\OBIEE_Backup\samplesales” mkdir “C:\OBIEE_Backup\samplesales”

xcopy /s/Y/Q C:\OracleBIData\web\catalog\samplesales C:\OBIEE_Backup\samplesales

echo Backup Complete!

@pause

2) step

by using this run.bat schedule it via SQL/Oracle/windows method based on your frequency like daily,monthly etc

Thanks
Deva