OBIEE Online Training

Saturday, May 19, 2012

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

Thursday, May 17, 2012

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

Thursday, May 10, 2012

Auto Backup OBIEE (RPD,Catalog, Config. etc)

Hi,

Create batch file (bi_auto_backup.bat) and save this file schedule it via windows scheduler/SQL etc (this script will take copy of your rpd (full root folder , catalog, all bi required config files) then save it system date wise separate folder.

@ECHO OFF
REM ****************************************************************
REM File name  : BI_Backup_Daily.bat
REM Author  : Rasavelu Devarasu
REM Created on  : 14 Mar 2013
REM Last Modified on : 14 Mar 2013
REM Description  : Autobackup Daily basis for OBIEE Application into the local computer.
REM Change History : Update autofetech date command
REM Modified By  : Devarasu Rasavelu
REM Modified on  : 14 Mar 2013
REM Change History : Amended the path as in Production.
REM ****************************************************************
@echo offecho Backing up Repository files…
set curr_date=%DATE:~10,4%-%DATE:~4,2%-%DATE:~7,2%
echo %curr_date%"
echo offecho Backing up Repository files…
if not exist "%USERPROFILE%\My Documents\backup\%curr_date%_backup\repository" mkdir "%USERPROFILE%\My Documents\backup\%curr_date%_backup\repository"
xcopy /s/Y/Q E:\Oracle\Middleware\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository "%USERPROFILE%\My Documents\backup\%curr_date%_backup\repository"
echo Backing up web catalog.Please wait….
if not exist "%USERPROFILE%\My Documents\backup\%curr_date%_backup\GPC" mkdir "%USERPROFILE%\My Documents\backup\%curr_date%_backup\GPC"
xcopy /s/Y/Q E:\Oracle\Middleware\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\GPC "%USERPROFILE%\My Documents\backup\%curr_date%_backup\GPC"
echo Backing up Configuration files…
copy /Y E:\Oracle\Middleware\user_projects\domains\bifoundation_domain\config\config.xml "%USERPROFILE%\My Documents\backup\%curr_date%_backup\
echo Backing up User Roles Configuration files…
copy /Y E:\Oracle\Middleware\user_projects\domains\bifoundation_domain\config\fmwconfig\jps-config.xml "%USERPROFILE%\My Documents\backup\%curr_date%_backup\
copy /Y E:\Oracle\Middleware\user_projects\domains\bifoundation_domain\config\fmwconfig\system-jazn-data.xml "%USERPROFILE%\My Documents\backup\%curr_date%_backup\
echo Backing up User Configuration files…
copy /Y E:\Oracle\Middleware\instances\instance1\config\OracleBIServerComponent\coreapplication_obis1\NQSConfig.INI "%USERPROFILE%\My Documents\backup\%curr_date%_backup\
copy /Y E:\Oracle\Middleware\instances\instance1\config\OracleBIServerComponent\coreapplication_obis1\DBFeatures.INI "%USERPROFILE%\My Documents\backup\%curr_date%_backup\
copy /Y E:\Oracle\Middleware\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1\instanceconfig.xml "%USERPROFILE%\My Documents\backup\%curr_date%_backup\web_instanceconfig.xml
copy /Y E:\Oracle\Middleware\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1\credentialstore.xml "%USERPROFILE%\My Documents\backup\%curr_date%_backup\
copy /Y E:\Oracle\Middleware\instances\instance1\config\OracleBISchedulerComponent\coreapplication_obisch1\instanceconfig.xml "%USERPROFILE%\My Documents\backup\%curr_date%_backup\scheduler_instanceconfig.xml
copy /Y E:\Oracle\Middleware\Oracle_BI1\clients\bipublisher\repository\Admin\Configuration\xmlp-server-config.xml "%USERPROFILE%\My Documents\backup\%curr_date%_backup\
copy /Y E:\Oracle\Middleware\Oracle_BI1\clients\bipublisher\repository\Admin\Security\principals.xml "%USERPROFILE%\My Documents\backup\%curr_date%_backup\
copy /Y E:\Oracle\Middleware\Oracle_BI1\clients\bipublisher\repository\Admin\Security\security.xml "%USERPROFILE%\My Documents\backup\%curr_date%_backup\
copy /Y E:\Oracle\Middleware\Oracle_BI1\clients\bipublisher\repository\Admin\DataSource\datasources.xml "%USERPROFILE%\My Documents\backup\%curr_date%_backup\
copy /Y E:\Oracle\Middleware\Oracle_BI1\bifoundation\web\msgdb\l_en\messages\logonmessages.xml "%USERPROFILE%\My Documents\backup\%curr_date%_backup\
copy /Y E:\Oracle\Middleware\Oracle_BI1\bifoundation\web\app\res\s_blafp\portal\portallogo.gif "%USERPROFILE%\My Documents\backup\%curr_date%_backup\
copy /Y E:\Oracle\Middleware\Oracle_BI1\bifoundation\web\app\res\s_blafp\b_mozilla_4\bg_banner.jpg "%USERPROFILE%\My Documents\backup\%curr_date%_backup\
copy /Y E:\Oracle\Middleware\Oracle_BI1\bifoundation\web\app\res\sk_blafp\answers\answerslogo.gif "%USERPROFILE%\My Documents\backup\%curr_date%_backup\
echo Backup Complete!
@pause


Similarly 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