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

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

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

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

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

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

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

       

OBIEE11g Integration with LDAP and configuration

Hi ALL,

               OBIEE 11g can work with many Authentication Providers. OBIEE 11g provides default authentication to connect with Enterprise Manager, Analytics, and Weblogic Server. Some companies struggled with the configuration using other third party providers. I worked with some customers to configure out the OBIEE 11g security with Microsoft Active Directory

Active Directory Configuration With Weblogic.

Create a user in Active Directory , here it is deva

The Below Screen Shot Shows user deva Properties

CN=deva,OU=Accounts,OU=OBIEE,OU=IN,DC=reg1,DC=uat1Hex,DC=Hex,DC=com

Required info from LDAP team:

1) LDAP server Host name and Platform(OS Type)
2) LDAP Server IP
3) LDAP Server Port no
4) User Path structure (Object )
ex.: like UAT1Hex path structure (Path : Functional user ID)
GROUP:
CN=Hex_BIUser,OU=Groups,OU=Accounts,OU=OBIEE,OU=IN,DC=reg1,DC=uat1Hex,DC=Hex,DC=com
IN/OBIEE/accounts/Hex_1Bank
SG= OU folder
sub folder
OBIEE
sub folder
Accounts
5) Group Path Structure (Object)
like e.x: (Path : Functional usergroup)
reg1.uat1Hex.Hex.com/IN/OBIEE/Accounts/Groups/Hex_BIUser.
6) Access required for our functional ID: deva
--------------------------------------------------------------------------
1) ldifd.tex files ---> permission required for our functional ID(deva)
2) Windows Active Directory access required for our functional ID(deva)
3) Access requred for functional id user (deva) to properties of the user in AD


Oracle BI EE version 11.1.1.5.0 and Microsoft Active Directory 2008 (Windows Server 2008 R2 version 64 bit type). 

 Configuring Active Directory Authenticator in Weblogic

Now click finish and then go to the default Authenticator’s setting and select sufficient

 Control Flag as sufficient.

 Reorder the MSAD as first,

 like below,

 finaly the order

Save the settings and go to the Provder specific TAB.
Enter Host, and port will be the default port and principal as

 Example of LDAP Configuration for Provider Specific:
---------------------------------------------------------------------------
Host:
10.10.10.10
Port
3268
Principal
CN=deva,OU=FNDEPT,OU=MAIL,OU=SW2,OU=NDS,DC=reg1,DC=Hex,DC=Tech,DC=com
Credential:
ldap deva functional id password
confirm Credential:
ldap deva functional id password
User Base DN:
DC=Hex,DC=Tech,DC=com
All Users Filter:
(&(memberof=CN=01UREG1GPCOBIEE,OU=GPCOBIEE,OU=APPS,DC=reg1,DC=Hex,DC=Tech,DC=com)(sAMAccountName=*)(objectclass=user))
User From Name Filter:
(&(memberof=CN=01UREG1GPCOBIEE,OU=GPCOBIEE,OU=APPS,DC=reg1,DC=Hex,DC=Tech,DC=com)(sAMAccountName=%u)(objectclass=user))
User Name Attribute:
sAMAccountName
User Object Class:
user
group base DN
OU=GPCOBIEE,OU=APPS,DC=reg1,DC=Hex,DC=Tech,DC=com
All group filters
(&(sAMAccountName=*)(objectclass=group))
Group From Name Filter:
(&(sAMAccountName=%g)(objectclass=group))
GUID Attribute:
objectguid



 after finishing above steps save it and restart all your BI Services then login weblogic console then

check it whether the MSAD is integrated or not yet.. below screen u can find Provider type as MSAD and Defaultauthenditactor like that.

Now to security realm->roles and policies->roles
Go to the global roles in that Admin role and view the conditions.
As shown in the below screenshot

Go to the below weblogic console then set global admin role to the AD user (deva)

 Select View Role Conditions and the below screen will appear

 select user then add it our AD user (deva)

Now add the condition.

Select User and click next and then In the user Argument Description type the ad username and then click add

Restart weblogic server.............

Now login to the admin console and go to the users and group “deva” is displayed in the below screen

 After you login you can see that now we have successfully logged in as AD user

In the Edit Application Role screen, scroll down to the Users section and click on the button marked “Add User”.

An Add User dialog will appear. Either type your system user username into the User Name box or for a full list of users, leave it blank.

screen and select the “Configure…” button to bring up the Identity Store Configuration screen. Click on the green + icon to add the new properties to the Identity Store and as stated above, two new properties need to be added, user.login.attr and username.attr, both set to the value of the alternate user name attribute.

                          add the AD group or AD users into the Application role

   

To regenerate user GUIDs:

1.     Update the FMW_UPDATE_ROLE_AND_USER_REF_GUIDS parameter in NQSConfig.INI:

a.      Open NQSConfig.INI for editing at:

b.               ORACLE_INSTANCE/config/OracleBIServerComponent/coreapplication_obisn

c.      Locate the FMW_UPDATE_ROLE_AND_USER_REF_GUIDS parameter and set it to YES, as follows:

d.               FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = YES;

e.      Save and close the file.

2.     Update the Catalog element in instanceconfig.xml:

a.      Open instanceconfig.xml for editing at:

b.               ORACLE_INSTANCE/config/OracleBIPresentationServicesComponent/

c.               coreapplication_obipsn

d.     Locate the Catalog element and update it as follows:

e.               <Catalog>

f.               <UpgradeAndExit>false</UpgradeAndExit>

g.               <UpdateAccountGUIDs>UpdateAndExit</UpdateAccountGUIDs>

h.               </Catalog>

i.        Save and close the file.

3.     Restart the Oracle Business Intelligence system components using opmnctl:

4.         cd ORACLE_HOME/admin/instancen/bin

5.         ./opmnctl stopall

6.         ./opmnctl startall

7.     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.

8.     Update the Catalog element in instanceconfig.xml to remove the UpdateAccount GUIDs entry.

9.     Restart the Oracle Business Intelligence system components again using opmnctl:

10.    cd ORACLE_HOME/admin/instancen/bin

11.    ./opmnctl stopall

12.    ./opmnctl startall

            Once you’ve restarted Weblogic, check that you can still log into the Weblogic Administrative Console as the Weblogic admin user you specified during install.

Next check you can log in to Oracle BI using the credentials of one of the Active Directory users.

 References:

http://bimetrics.wordpress.com/2011/08/12/integrating-ms-active-directory-with-obiee-11g-in-weblogic-server/
http://obieeblog.wordpress.com/2009/02/03/obiee-security-enforcement-%E2%80%93-ldap-authentication/
http://oraclebizint.wordpress.com/2007/10/10/oracle-bi-ee-101332-using-ldapoid-authentication/
http://obiee-blog.info/security/ldap-authentication-against-multiple-servers/
http://download.oracle.com/docs/cd/E21764_01/bi.1111/e10543/privileges.htm#BABCDCFE
http://download.oracle.com/docs/cd/E21764_01/bi.1111/e10543/legacy.htm#CHDCEFBC

fyi..https://forums.oracle.com/forums/thread.jspa?threadID=2251295
Steps to configure OBIEE 11g LDAP SSL Authentication by configuring the Authentication Provider in Weblogichttps://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=BULLETIN&id=1326641.1

Thanks

Deva