OBIEE11g

Obiee11g writeback

2012-08-31T15:21:00.001+08:00

Hi,

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

Thanks
Deva

Images in Narrative View

2012-08-28T22:15:00.003+08:00

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

2012-08-13T22:46:00.003+08:00

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)

2012-08-13T21:37:00.002+08:00

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

2012-08-13T21:09:00.004+08:00

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

2012-08-13T11:59:00.004+08:00

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

2012-07-03T14:17:00.002+08:00

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

2012-07-03T12:21:00.002+08:00

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

2012-07-03T11:04:00.001+08:00

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

2012-07-03T08:42:00.000+08:00

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?

2012-07-03T02:38:00.003+08:00

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

2012-07-03T02:37:00.004+08:00

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

2012-07-03T02:37:00.001+08:00

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

2012-07-02T19:10:00.001+08:00

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

2012-06-22T01:08:00.000+08:00

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

2012-06-16T17:27:00.000+08:00

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)

2012-05-19T01:07:00.000+08:00

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

2012-05-17T02:02:00.000+08:00

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

2012-05-10T03:18:00.000+08:00

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

2012-03-16T07:26:00.000+08:00

Hi,

Find the upgrade here:

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

Thanks

Deva

obiee11.1.1.6 Simple Install type does not install a Managed Server(bi_server1)

2012-03-16T02:05:00.000+08:00

Hi,

My Exp in obiee11116 with simple install type

I have successfully completed the Simple of OBIEE 11.1.1.6. So the folder structure under bifoundation_domain is for Admin server only showing but its not showing and bi_server1 folder.
how come the same type of installation i did in obiee11.1.1.5 version its working fine and bi_server1 folder presented under
D:\OBIEE11g\Middleware\user_projects\domains\bifoundation_domain\servers
But when I login to the console, under the servers environment I am able to see only Admin server and not the bi_server1

Solution

This is a limitation when you choose Simple install
The following considerations and limitations apply to the Simple Install type:
*The Simple Install type is intended for installing standalone instances of Oracle Business Intelligence.
You cannot scale out, add components to, or use the Configuration Assistant on instances of Oracle Business Intelligence that were installed with the Simple Install type.
* Unlike the Enterprise Install type, the Simple Install type does not install a Managed Server.
Furthermore, with Simple Install type, components that typically exist in the Managed Server (logically speaking) are provided in the Administration Server instead.

This is documented under Section 4.5.1.1 Considerations and Limitations for the Simple Install Type
Oracle® Fusion Middleware Installation Guide for Oracle Business Intelligence
http://docs.oracle.com/cd/E23943_01/bi.1111/e10539/c4_installing.htm#BABIIBHC

Thanks
Deva

obiee11.1.1.6.0 new features

2012-03-16T01:55:00.000+08:00

Hi,

1)Ability to Limit and Offset Rows Returned (export all row into Excel)
2) Identify Query Candidates with Oracle BI Summary Advisor
3) Integrate the Administration Tool with a Third-Party Source Control Management System (Version Control system)
4) Streamlined MUD Merge Process
5) Automated Repository Patching Process
6) Support for Aggregate Persistence in a Cluster
7) FIRST_PERIOD and LAST_PERIOD Time Series Functions
8) Ability to Print the Physical and Business Model Diagrams

Ref:
http://docs.oracle.com/cd/E23943_01/bi.1111/e10540/whatsnew.htm#sthref8
Thanks

Deva

OBIEE 11.1.1.6.0 installation on windows 7 64bit

2012-03-16T01:00:00.000+08:00

Hi,

OBIEE 11.1.1.6.0 is now available OTN. Download from the following link.

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

Steps to Install obiee11.1.1.6.0 on windows 7 SP1 64bit

obiee11116.rar
http://www.filefactory.com/file/c4e7aac/n/obiee11116.rar

Thanks

Deva

Resetting OBIEE 11g weblogic admin password

2012-02-15T15:24:00.000+08:00

Hi All,

Steps to Resetting weblogic User Password:
1)
Login into WLS (Web logic Server)Administration Console as Administrator privileges
http://ServerIP(or)localhost:7001/console/login/LoginForm.jsp
in the Domain Structure -> click the Security Realms -> myrealm -> User and Groups
-> Select weblogic user (Double click the user which you want to change the password) -> Password
Enter the new and confirm password.
2)
Stop all the bi services and change (before take a backup of Current RPD, Catlog, boot.properies and change it that password) it password and save it.
3)
Go to weblogic Enterprise Manager and deploy RPD (just new changed password RPD file) here you must put it u r new changed RPD password then click apply and restart services.
4)

Down all the bi services then find it boot.properites files then set it your new password and restart all bi services. Then it will work with new password (RPD, Presentation services, weblogic Console/EM and Catalog).
Some more refernce method:

http://linora64.blogspot.com/2011/07/reset-obiee-11g-weblogic-admin-password.html

Thanks

Deva

How to create a new Catalog in OBIEE11g

2012-02-11T12:48:00.000+08:00

Hi
1). Go to localDrive:C:\OBIEE11G\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1
2). Open your instanceconfig.xml file
3). Find <CatalogPath> and </CatalogPath> tags
4). Write the new catalong name that you want to create (suppose sh_new) then your tag should look like this
<CatalogPath>C:\OBIEE11G\instances\instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog/obirep</CatalogPath>
5). Save the file and start/re-start the BI presentation service
6). It automatically creates the obirep catalog, once we start our presentation service and you need not to create anything manually..

Note:
Catalog Manager is useful in managing your reports and give permissions to the users and folders..
As per the name implies you can understand that it's used to manage the catalog that you have...
The list of things that we can do with catalog manager are: (as per my knowledge)
1). Rename the report names, dashboard names, and other stuff
2). Used to give permissions for particular folders or particular objects for particular users..
3). copy and move the reports to other folders
4). copy and move the reports to other machine's catalog which are in network and accessible.
5). Can modify the XML for reports and prompts presents in this catalog if you know the XML

Via Em and Catalog manger careting new catalog is very strange.some times it works and some times not working its throwing like this error while crating in Catalog manager

file:///?\C:\OBIEE11G\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\obirep\root.atr could not be accessed.
file:///?\C:\OBIEE11G\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\obirep\root.atr could not be accessed.
also EM unable to create new catalog issues. so better to above suggested methods its works fine.

Thanks
Deva