Obiee11g writeback

Hi,

OBIEE11g Writeback Configuration
https://docs.google.com/file/d/0BwMedcpXjz5bUS1EQ09lb3lwcDQ/edit

Thanks
Deva

Images in Narrative View

Hi,

I came accros OTN forum questions like placing images on Narrative view in OBIEE10g/11g. the solution refer the below steps,

Step1:
In your narrative view add any column and add narrative view then use below syntax on your narrative

<image src = "/images/oracle_logo.png">
or
<image src = "res/sk_blafp/login/oracle_logo.png">

OBIEE11g Image Path: you can keep your custom image any one below path

(keep it your custom image under below path and make sure same size of oracle_log.png)




C:\Oracle\Middleware\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\_WL_user\FMW Welcome Page Application_11.1.0.0.0\upd42q\war\images\oracle_logo.png

C:\Oracle\Middleware\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\sk_blafp\login\oracle_logo.png

C:\Oracle\Middleware\Oracle_BI1\bifoundation\web\app\res\sk_blafp\login\oracle_logo.png

C:\Oracle\Middleware\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\sk_blafp\login\oracle_logo.png




OBIEE10g image path:
syntax on narrative view,
<image src = "res/s_Siebel77/Images/report_account_appl.jpg">
place your images in this folder C:\OracleBI\web\app\res\s_Siebel77\Images\

Steps 2: if your using custom image, after placing custom image on above any of one place you have to strart bi presentation services (retart using opmnctl command)

Step 3:create new analysis add any column in criteria and add narrative view on result view then edit narratvie view and put it  <image src = "/images/oracle_logo.png">  in narrative box then row to display as 1 then test it look at below screen
O/P Screen Short looks like below,

Refer my OTN Post:
https://forums.oracle.com/forums/thread.jspa?threadID=2432626&tstart=0

Thanks
Deva

OBIEE11.1.1.6.2 BP1 fixed bugs

Hi,


Bugs Fixed by this patch:
-------------------------
14349315 : INCONSISTENT BEHAVIOUR IN SLIDER PROMPTS INTRODUCED IN 11.1.1.6.2
13372432 - FONT OPTIONS DO NOT WORK CORRECTLY FOR GAUGE VIEWS.
14227363 - OBIEE EXCEL REPORTS DELIVERED THOUGH AN AGENT ARE UNREADABLE
14301220 - NAVIGATE TO A PROMPTED REPORT DOESN'T SHOW PROMPT, BUT DISPLAYS RESULTS DIRECTLY
14159610 - ADDING REPORT TO BRIEFING BOOK WITH COLUMN SELECTOR RESULTS IN SAWSERVER CRASH 
14228975 - ERROR CODES: RECURSION LIMIT EXCEEDED WHEN USING SAVED FILTERS
13972011 - AFTER WEBCAT UPGRADE:DEVICE (DASHBOARD) IS NOT SET IN (USER) DELIVERY PROFILE

Reference:My Oracle Support(OBIEE11.1.1.6.2 BP1) 

Thanks
Deva

OBIEE 11.1.1.6.2 BP1 - Sample Application (V207)

Hi,


OBIEE 11.1.1.6.2 BP1 - Sample Application (V207):

http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html

The above link only have SampleApp V207 VirtualBox Image (turnkey virtual environment with full SampleApp preconfigured). there is no manual install files. recently i just raised SR with Oracle support team and got the manual files are below,

SampleApp V107 Install Files (Manual install files - not Virtual Image)

OBIEE 11.1.1.6.2 BP1 - Sample Application (V207)



SampleAppWebcat.zip
https://docs.google.com/open?id=0BwMedcpXjz5bOWl1d3piSFFwcnc

SA_20723_BI0141.rpd
https://docs.google.com/open?id=0BwMedcpXjz5balcya1hWWHhjTmM

Sampleapp_Airlines_BI0009.rpd
https://docs.google.com/open?id=0BwMedcpXjz5bRm4xbjhvWURSWEk

SampleApp_V207_Reduced Install Notes_V1.pdf
https://docs.google.com/open?id=0BwMedcpXjz5bR2NobER6UXA0ZWs

analyticsRes.zip
https://docs.google.com/open?id=0BwMedcpXjz5bNGdPbDN1Ti1ESlE

Reference:

SR 3-6010825991 : OBIEE 11.1.1.6.2 BP1 - Sample Application (V207)Install Files (Manual install files) required

Thanks

Deva

obiee11g installation steps on windows 7

Hi,

Download the complete document for obiee11.1.1.6.0 software only installation on windows 7

https://docs.google.com/open?id=0BwMedcpXjz5bbXc2bEdJRzAtVnc

Thanks
Deva

OBIEE11g SSL Setup and Configuration

Hi,

I just implemented SSL with below system configuration:
Windows Server 2008 R2 , IE8 Browser

Download the Document (obiee11g with Custom SSL)


https://docs.google.com/open?id=0BxBUO3DvOkSPVlRPRjRMVHBhQW8

Thanks
Deva

Changing user password in OBIEE 11G

Hi,


Just use the below java code (Changepwd.java) and compile and run using java tool(JDEV,Netbeans etc)  and get the jar/war file and deploy the war file via Weblogic console then call the link (jmx bean url) in your analysis by using Action link method.
-------------------------------------------------------------------------------
package obiee.chngpwd;


import java.io.IOException;
import java.util.Set;


import javax.management.InstanceNotFoundException;
import javax.management.IntrospectionException;
import javax.management.MBeanException;
import javax.management.MBeanInfo;
import javax.management.MBeanOperationInfo;
import javax.management.MBeanParameterInfo;
import javax.management.MBeanServerConnection;
import javax.management.MalformedObjectNameException;
import javax.management.ObjectName;
import javax.management.ReflectionException;
import javax.management.remote.JMXConnector;
import javax.management.remote.JMXConnectorFactory;
import javax.management.remote.JMXServiceURL;


public class Changepwd {
private JMXConnector jmxConnector = null;
private MBeanServerConnection mBeanServerConnection = null;


public Changepwd() throws IOException, MalformedObjectNameException, NullPointerException, InstanceNotFoundException, IntrospectionException, ReflectionException {
JMXServiceURL serviceURL = new JMXServiceURL("service:jmx:rmi://IP/jndi/rmi://IPaddress:1090/jmxconnector");
System.out.println("Connecting to: " + serviceURL);


jmxConnector = JMXConnectorFactory.connect(serviceURL);
mBeanServerConnection = jmxConnector.getMBeanServerConnection();
Set<ObjectName> mbeans = mBeanServerConnection.queryNames(null, null);
for (ObjectName mbeanName : mbeans) {
System.out.println(mbeanName);
System.out.println("Service:" + mbeanName.getKeyPropertyListString() + "Domain:" + mbeanName.getDomain());

}
//ObjectName securityMBeanName = new ObjectName("jboss:service=JNDIView");
//ObjectName securityMBeanName = new ObjectName("jboss:service=JNDIView");
ObjectName securityMBeanName = new ObjectName("Security:Name:myrealmDefaultAuthenticator");
MBeanInfo mbeanInfo = mBeanServerConnection.getMBeanInfo(securityMBeanName);
MBeanOperationInfo[] opInfo = mbeanInfo.getOperations();
        System.out.println("Security Operations: ");
        for(int o = 0; o < opInfo.length; o ++) {
            MBeanOperationInfo op = opInfo[o];


            String returnType = op.getReturnType();
            String opName     = op.getName();
            System.out.print(" + " + returnType + " " + opName + "(");


            MBeanParameterInfo[] params = op.getSignature();
            for(int p = 0; p < params.length; p++)  {
                MBeanParameterInfo paramInfo = params[p];


                String pname = paramInfo.getName();
                String type  = paramInfo.getType();


                if (pname.equals(type)) {
                    System.out.print(type);
                } else {
                    System.out.print(type + " " + securityMBeanName);
                }


                if (p < params.length-1) {
                    System.out.print(','); 
                }
            }
            System.out.println(")");
        }
Object objUser[] = new Object[]{("userId"), ("oldPassword"), ("newPassword") };
//Object objUser[] = new Object[]{("destroy")};
String objStr[] = new String[]{("java.lang.String"), ("java.lang.String"), ("java.lang.String") };
//String objStr[] = new String[]{("java.lang.String")};


try {
//mBeanServerConnection.addNotificationListener(securityMBeanName, new PasswordListener(), null, null);
//Object responseObj = mBeanServerConnection.invoke(securityMBeanName, "jbossInternalLifecycle", objUser, objStr);
Object responseObj = mBeanServerConnection.invoke(securityMBeanName, "changeUserPassword", objUser, objStr);
System.out.println("Response:" + responseObj);




} catch (InstanceNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (MBeanException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ReflectionException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
/**
* @param args
* @throws IOException 
* @throws NullPointerException 
* @throws MalformedObjectNameException 
* @throws ReflectionException 
* @throws IntrospectionException 
* @throws InstanceNotFoundException 
*/
public static void main(String[] args) throws MalformedObjectNameException, NullPointerException, IOException, InstanceNotFoundException, IntrospectionException, ReflectionException {
// TODO Auto-generated method stub
new Changepwd();


}


}


For More about change password info:
http://www.rittmanmead.com/2011/10/changing-your-password-in-obiee-11g/

https://forums.oracle.com/forums/thread.jspa?messageID=9486826&#9486826

Till Next Time

Manually Configuring Settings for Data in Narrative Views

Hi,

Let say i have table with 1000 rows data, when i try to use narrative view in analysis got below error narrative view it's not how so "many rows data in narrative view and MaxRecords limit exceeded error".this is know issues only by changing/adding instanceconfig.xml --> narrative view content then you can able to resolve it.

1) take a backup of your instanceconfig.xml file

C:\Oracle\Middleware\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1\instanceconfig.xml

2) Narrative view you need to add below elements are,

just include <Views> b/w </Views>

<Narrative>

<MaxRecords>40000</MaxRecords>

<DefaultRowsDisplayed>1000</DefaultRowsDisplayed>

</Narrative>

3)Save your changes and close the file.

4) Restart Oracle Business Intelligence "Bi_Presentation_Services"

For More : instanceconfig.xml (increasing no of columns/rows)

http://docs.oracle.com/cd/E23943_01/bi.1111/e10541/answersconfigset.htm#CIHHBHAI

(note: refer section, 18.3.1.2 Manually Configuring Settings for Data in Views)

Row_id in obiee analysis report

Hi,


Open your report--> add one column --> click fx--> Rcount(1) then save it it will returns the row I'd sequence


Thanks

Trailing zero's in obiee11g

Hi,

If you have 15 digit's Account number on your dashboard prompt with varchar data type its loosing the trailing zero's.

to resolve this issues, to the below

can you try below on your column prompt --> edit formula --> try below

cast(cast( Column as int) as char)

Thanks

Are you sure you want to navigate away from this page?

Hi,

In OBIEE 11.1.1.5.0 when you use Microsfot Internet Explorer as the browser, every time that try to add Totals After for Columns and Measures in the Edit Table View, you get the following message:

"Windows Internet Explorer
Are you sure you want to navigate away from this page?
The changes that you made to this object have not been saved. Click Cancel to return to the editor where you can save the object.
Press OK to continue, or Cancel to stay on the current page."

If i click ok and revert, then you can save the report without message appearing, but the report does not have the total added.

Download and install patch 13969710.

ReferencesBUG:13969710 - QUERY REFRESH DOES NOT SHOW COLUMN DRAGGED FROM EXCLUDED SECTION AFTER BP2 PATCH

Till next Time...

Invalid JSON string: 0 {t:4}" Logging into OBIEE 11.1.1.6.0 after Upgrade

Hi,

The error message "Invalid JSON string: 0{t:4}" javascript error obiee11.1.1.6.0

1)Resolve this issues can you please Clear the browser cache and re-load the page or log in to OBIEE.
2)if its not working then try to Re-deploy the Analytics Application, using the file $Middleware_Home\Oracle_BI1\bifoundation\jee\analytics.ear
know Bug Ref:

This is a known bug in OBIEE 11g
BUG:13845528 - UPGRADING TO 11.1.1.6, ANALYTICS DOES NOT WORK IN FIREFOX 10.0.2 ON WINDOWS 7 PC

Please refer the below doc
OBIEE 11g: Error: "Invalid JSON string: 0 {t:4}" Logging into OBIEE 11.1.1.6.0 after Upgrade [ID 1439063.1]

Thanks
Deva

Action link Open in a New Window not working in OBIEE 11.1.1.6.0

Hi,

Action link Open in a new Window noot working in OBIEE 11.1.1.6.0:

In obiee11.1.1.6.0 Action Link method "Open in a new window " functionality is not working. Just created a report and applied the action link in one of teh column value. in that properties and setted the Action link open as in a new window. But when i click on the values of that column ---> Action link is not responding But if i set action link set it to open in the same window,it working fine.
After checking with My Oracle Support Team and Confirmed this as known bug in obiee11.1.1.6.0 version and then this bug has been fixed by applying the patch 14003822

Reference :
Bug 14165667 - LINKED REPORT OPEN IN NEW WINDOW DOES NOT WORK AFTER A CHANGE PROMPT

Thanks
Deva

Netscape.ldap.LDAPException: error result (4); Sizelimit exceeded

Hi,

LDAP configuration in BIEE 11 g via Microsoft Active Directory some times its throws below kind of error.

The error is "LDAPException: return code:netscape.ldap.LDAPException: error result (4); Sizelimit exceeded".

Note: the error message say's that you have exceeded the limit the server has been configured to return, (i.e: your request exceeded).by default values is 1000.

Solution:

we need to increase the LDAP user sizelimit -->Go to the LDAP client install drive, then search it ldp.exe file and run as admin then connect it by using ldap domain user id and password, refer the below methods,

1).  the sizelimit can be set the
LDAPConnection.setOption(LDAPv2.SIZELIMIT, new Integer(0)); for example

by Changing maximum results option using ldapconn.setOption(LDAPv2.SIZELIMIT,25000)

i.e: by Changing Look Through Limit to around 25000 in ldap server.

2.) and if you are using the netscape jar to search, do the following:

LDAPConnection ldapCon = new LDAPConnection();
LDAPSearchConstraints cons = ldapCon.getSearchConstraints();
cons.setMaxResults(-1);
ldapCon.search(ldapURL, cons);

For more:

https://kr.forums.oracle.com/forums/thread.jspa?threadID=1155618

Thanks

Deva 

Hiding dashboard prompt on dashboard page for Particular Users/Application Roles

Hi,

Steps to Hiding dashboard prompt on obiee11g dashboard page:

Just keep it u r dashboard prompt alone in a section and 

there this a section properties -->having permission settup so u that u can give a permission denied for particular user or all users/roles can.

Hope this help you :)

Thanks

Deva

OBIEE 11g Error: 500 Internal Server Error

Hi,

I have installed obiee11.1.1.6.0 with weblogic server 10.3.5.0 and when ever i try to start the BI services. I am getting the error following error 

Error 500--Internal Server Error 
From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:
10.5.1 500 Internal Server Error
The server encountered an unexpected condition which prevented it from fulfilling the request.

I thought still some of bi services are trying to starting like that so that's why its taking time and all after searching oracle note i just found actual reason is 

FMW_SECURITY_SERVICES_URL in NQSConfig.ini has wrong IP. checking log file its noticed that this parameter has invalid IP which caused the problem.so after updating with correct IP address its got working fine so this is permanent solution.

FYI, the screen short just find the FMW_SECURITY_SERVICES_URL in NQSConfig.ini file.

 Try to update your static IP address like below screen,

Then try to re - start your bi services then Error: 500 Internal Server Error won't come again.

Regards,

Deva...

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

Upgrade obiee11.1.1.5.0 to obiee11.1.1.6.0

Hi,


Find the upgrade here:

http://docs.oracle.com/cd/E23943_01/bi.1111/e16452/bi_plan.htm#BABECJJH


Thanks

Deva