Wednesday, September 12, 2012

OBIEE to BIP trick

I am back to working with BI-Publisher after a hiatus of a few years and I am loving 11g: it is such a big jump from 10g!  Today I needed to “remember” how to navigate from an “Answers” (or “Analysis” if you like the new terminology better) request to a BIP report while preserving the context: basically how to pass parameters. Following is how I went about it, hopefully it will be useful to some of you.
- First create a BIP report with a parameter, let’s call it P_DEPT. For illustration purposes we’ll use the HR schema to build a simple data model.
pic1
pic2
pic3
- Create a simple template to show a table with DEPARTMENT_NAME and DEPARTMENT_ID
- Navigate to the BIP report properties and enable the radio button “Allow Sharing Report Link”
- Run the report and get the Report Link by navigating to the “Shared Report Link”
pic6

- We’ve got an OBIEE Answers request with 2 fields: DEPARTMENT_NAME and DEPARTMENT_ID, clicking on a particular DEPARTMENT_ID should take us to the BIP report above filtered for the selected department.
pic8
7) Now the trick: create an Action Link (Navigate to a Web Page)  for the Department ID column value:
pic9
- Create a parameter P_DEPT (similar to the BIP report parameter name)
                         Name: P_DEPT
                         Value: “Column Value” then select “DEPARTMENT_ID”
                         Hidden field: checked
- Modify the BIP “Shared Report Link” to pass in the P_DEPT parameter: The text "_paramsP_DEPT":"*" is changed to "_paramsP_DEPT":@{P_DEPT}
pic12

- Clicking on Department ID 70 takes us to the BIP report with the filter Department ID =70 applied.
pic13


Fiston
a+

Tuesday, May 29, 2012

OBIEE reports to Webcenter Content (UCM)


I was asked by a customer to work on a POC to show how an end-user can run an OBIEE 11g analysis and check it in automatically into Webcenter Content (UCM), this solution doesn't involve BPEL processes. In case you’re not familiar, Webcenter content (WCC) is an enterprise grade content management solution from Oracle. It is also extensible by using the many Java APIs that are available out of the box.
With the introduction of the action framework in OBIEE 11g there are endless possibilities to integrate OBIEE with other applications. For this POC we leveraged the action framework to call a WCC API called CHECKIN_UNIVERSAL via the RDIC (Remote IntraDoc Client) a light weight communication protocol for the Content server. I took the opportunity of the long Memorial Day week end to put something together. 
A report can be checked into the content management solution either directy by calling the action or at the completion of an iBot/agent. Following are few screenshots to illustrate the functionality. When I get a chance I will document the step by step approach for the implementation. 

  • log into OBIEE and select the action "UCM"







  • Enter the parameters: Title, Document Type, The report to be checked into UCM 

Here are the parameters for the action


Once the success message is displayed, the report is available in WCC. Log into WCC and do a search 


and voila, our report is checked in!

The action can also be invoked from an agent which is pretty cool


a+
Fiston




Monday, May 14, 2012

OBIEE 11.1.1.6.2 (patch 13884769)

Patch 13884769 was released yesterday. 

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

Additional patches are also needed: 
* 13932572
* 13887566
* 13926409
* 13892934
* 13916045
* 13916045
* 13884769
* 13794002
Following is a compilation of the bugs that I cam across for the related patches for reference, an 
"official" list will be published soon from Support.
--------------------------------------------------------------------------
Patch 13932572:        Patch 11.1.1.6.2 Oracle Business Intelligence Installer
---------------------------------------------------------------------------
13560245:       BIDOMAIN/CONFIG/JDBC NOT FOUND.
13504454:       BLK - BIINSTANCE COPYCONFIG FAILURE ESSBASE MAXL LOGIN IS FAILING 
13510938:       NEED OFFICIAL WAY TO INVOKE _CONFIGURERPD
13628293:       EMPTY PROCUREMENT DASHBOARD IN RC4
13565722:       BLK:        BI T2P PASTECONFIG ERRORED OUT WITH UNABLE TO PARSE JMS_WEBLOGIC_JNDI_URL
13589944:       BI T2P - PASTECONFIG INSTANCE IS FAILING WITH JAVA.LANG.UNSATISFIEDLINKERROR
13619973:       INCLUDE ESSSERVER HOST NAME IN THE MOVEPLAN
13683204:       STRESS:       FA:       CRM ERROR RESPONSE[NQSERROR:        43082] ILLEGAL OPERATION ATTEMPTED CLOSED
13724975:       RUP2 AIX HCM STARTERDB POSTCONFIGURE FAILED
13779029:       BI T2P BI RPD PLUGIN OPERATION ERROR WHILE LOADING SHARED LIBRARIES LIBARICU23
13687239:       RUP2_RC4 BI DOMAIN - BI ANALYTICS DATASOURCE TEST FAILS 
13780076:       USE BIPROV PROPERTIES FROM 13694505 
13404296:       BI PROVISIONING FACADE MUST TRIM RPD IN INSTANCE FOR SELECTED FA OFFERINGS 
13485655:       T2P ERROR MSG EXECUTING WLST SCRIPT APPEARS DURING BIINSTANCE PASTECONFIG
13896014:       RPDTRIM INCORRECT PROPERTY BIPROV.BI-HOME.DIR IN BI-CONTENT.XML FILE 
13896152:       TRIMRPD NOT ABLE TO CREATE BIPROJECTS.TXT BASED ON FAOFFERING LIST BAD XPATH ERR
13896209:       TRIMRPD RELATIVE BI ORACLE HOME LOCATION PASSED TO SCRIPTS DURING RPDTRIM
13898786:       TRIMRPD PLEASE MASK THE RPD PASSWORD WHICH IS LOGGED DURING _TRIMRPDTARGET EXEC
13910554:       MISSING CONNECTION PROPERTIES IN OBIEE RPD
13926479:       TRIMRPD FOR WINDOWS THE PROPS FILE SHOULD INCLUDE FORWARD SLASH IN DIR PATHS
---------------------------------------------------------------------------------
Patch 13887566:         Patch 11.1.1.6.2 Oracle Real Time Decisions
----------------------------------------------------------------------------------
13703826:       RTD Causes Bi_Server1 To Start Takes Long Right After Upgrade To 11.1.1.6.0
13240778:       Qa- Access- Ere- Rgrn- Error Accessing Lov Via Key; Can't Select Via Key 
9157691:        Server Need To Respond When The Timeout Expires, Not Wait Till End Of Request
13360752:       Unable To Load All Extension Columns For Customer In Rtd Studio 
13567294:       Removed 1St Value In Rule Becomes Nan 
13472560:       Qa-Access-High Contrast Setting Appears Cluttered, Some Items Not Visible 
13723256:       Rup2- Error While Accessing Oracle Rtd After Rup2 Patching
13537093:       Internal Server Error Shows When Click Print At Choice Group>Analysis>Quality
13779138:       Rule Editor Does Not Display Date In Operand
13539353:       Internal Error(Npe) For Entity Statistic
13780656:       New Studio Help Files For 11.1.1.6.2
13795529:       RTD Rule Editor Error-Cannot Move Focus To The Control
13408870:       Qa-Sdconfig 3X Values Copied To 11G But Not Used There
13409526:       Qa-Update Doc Copyrtddata_Readme.Txt For Stop Start 11G
13506987:       Copyright Information Needs To Be Extended To 2012
13347251:       Qa-Unable To See Ere In Dynamic Page In Safari Chrome
13805360:       Attribute Translations Not Seen In Adf Rules Editor
13816544:       Re Error When Selecting Double Without Decimal
-------------------------------------------------------------------------------------
Patch 13926409:         Patch 11.1.1.6.2 Oracle Business Intelligence Publisher
---------------------------------------------------------------------------------
11906714: QA:TIMEZONE NOT IN SYNC IN JOB MANAGER - JOB HIISTORY 
12312461: NLS:       MB DATA GARBLED IN JOB HISTORY USING SQL SERVER 
12645567: NLS:       WRONG WEEK OF YEAR FOR ORACLE DATE FORMAT CONTAINING WW 
12825409: INTERACTIVE VIEWER CONDITIONAL FORMATTING REPORT FAILS IN INTERACTIVE VIEWER 
13028918: CPU Bug 
13341249: BACKGROUND ON SCHEDULED REPORT DOES NOT PRINT 
13371841: QA:       ACTIONS DROPDOWN NOT SHOW CORRECT OPTION (NON ADMIN USERS) 
13445281: NLSHOT:       PREVIOUS 11G VERSION XLF FOR RTF TEMPLATE CAN'T WORK WELL ON 11.1.1.6 
13449368: DTE FARM MAIN NIGHTLY:        WEBPAGE ERROR WHEN EDIT DATA MODEL IN BIP 
13473493: XMLP TRANSLATION ISSUE OF MILLION (ENG) TO MILLIONES (SPANISH) 

---------------------------------------------------------------------------------
Patch 13884769:        Patch 11.1.1.6.2 Oracle Business Intelligence
---------------------------------------------------------------------------------
10167311: ADD TEST CASES FOR MDSXUDML GENERATOR AND PARSER
10199188: CHARTS X AXIS LABEL IS BLURRED AT 45/60 ANGLE
10391144: WEIRD BEHAVIOUR OF FILE OPEN DIALOG ON WINDOWS 7 COMPUTER
10647655: COLUMN DATA FORMAT IS IGNORED ON WRITEBACK
11810127: ADMINTOOL TESTS FAIL:        EXTERNALIZATION
12411977: TERADATA RANK() IS NOT ALLOWED IN THE SUBQUERY
12426993: CHECKIN CONSISTENCY CHECK IS DIFFERENT FROM ADMINTOOL CONSISTENCY CHECK
12543094: EXPOSE THE SERVER ONLY CONSISTENCY CHECK IN THE ADMINTOOL UI
12612904: TOTAL PICKS VALUE IN FIRST ROW AND GIVES NOT A NUMBER WHEN AVERAGING NULL
12658173: SUMMARY ADVISOR STATS CACHE FILE NEEDS TO BE MORE ROBUST
------------------------------------------------------------------------------------------------------
Patch 13892934:        Patch 11.1.1.6.2 Oracle Business Intelligence ADF Components
-------------------------------------------------------------------------------------------------------
13365954: ERROR WHILE OVERWRITING AN ANALYSIS VIA BI COMPOSER
13597290: 11.1.1.7.0 ESSBASE DATA CONTROL CODE IS PRINTING UNWANTED DEBUG MESSAGES
13733098: REPORTS AND ANALYTICS, CANNOT  SAVE NEWLY CREATED REPORT
13858848: BIADFCOMPS - ANALYSIS CREATED USING COMBINE UNION IS NOT EDITABLE IN BI COMPOSER
--------------------------------------------------------------------------------------------------------
Patch 13916045:        Patch 11.1.1.6.2 Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x
-----------------------------------------------------------------------------------------------------
13552700:       ORACLE.ESSBASE.EPM.JAPI_TEMPLATE SHOULD SET REQRD EPM PROPS IN SETDOMAINENV.SH
13631427:       DTE:       ESSBASE CANNOT CONNECT TO BI - BIFNDNEPM TXN
13614676:       CONFIGURE ESSBASE JAVAMAXOUTLINES FOR BI PLATFORM
13785544:       INCORRECT ALIASES ARE DISPLAYED IN THE FINANCIAL REPORTING MEMBER SELECTOR IN THE FINANCIAL REPORTING STUDIO AND IN WORKSPACE.
13785522:       FINANCIAL REPORTING REPORTS WITH ADVANCED MEMBER SELECTION DO NOT COMPLETE.
13769394:       FINANCIAL REPORTING REPORT FAILS WITH UNKNOWN MEMBER USED IN QUERY ERROR.
13741981:       SELECTING THE EXCEL ICON FOR FINANCIAL REPORTING REPORTS, THE PREVIEW USER POINT OF VIEW DIALOG IS NOT DISPLAYED IN FIREFOX.
13512669:       XMLSTREAMREADEREXCEPTION DISPLAYED IN BI STARTUP LOGS.
13427006:       THE FINANCIAL REPORTING BATCH NAME AND DUPLICATE EDIT PROPERTIES SHOULD BE IN VALID FORMAT.
13089241:       FINANCIAL REPORTING MAKES MULTIPLE API CALLS TO WEBCAT WHEN SAVING AN OBJECT.
11652873:       FINANCIAL REPORTING ANNOTATION VIEW PANE HAS PERMISSION ISSUES FOR ANNOTATION ON TEXT OBJECT.
9211682:        FAILED TO REGISTER THE FINANCIAL REPORTING WEB SERVICE CONFIG MBEANS.
13475602:       OFFSET MEMBER WILL NOT SHOW ON THE RIGHT HAND SIDE OF MEMBER SELECTOR 
13710417:       NLS:        MEDIUM DATE FORMAT FOR FR-CA SHOULD BE YYYY-MM-DD
13710429:       NLS:        MEDIUM DATE FORMAT FOR FR-CA SHOULD BE YYYY-MM-DD AT FLTER DIALOG 
13712484:       NLS:       NEED TO SUPPORT FRENCH_CANADA IN RUP4 
13509268:       FUSIONGL:       CHANGE THE DEFAULTS IN THE ALLCOAITON WIZARD TEMPLATE
13771676:       ALLOCATION MEMBERS SELECTOR IS NOT EXAPNDING FOR DIMENSIONS WITH BIG NUMBER OF MEMBERS
12530876:       PERFORMANCE OF FINANCIAL REPORTING REPORTS QUERYING ESSBASE APPLICATIONS WITH A LARGE NUMBER OF DYNAMIC CALCULATIONS MAY BE SLOWER.
12404364:       ESSBASE READ ONLY ACCESS INSUFFICIENT PRIVILEGE WITH PROMPT
13250047:       REMOTE ADM CAN'T GET ALL MEMBERS IN LARGE GRAINED INTERFACE
13686023:       IN FINANCIAL REPORTING REPORTS,  CHILD MEMBERS BECOME INVISIBLE IF THE SECURITY FILTER IS SET TO META READ ON PARENT MEMBER.
12765822:       DMS LOGS LOTS OF ERRORS WHEN ESSBASESERVER1 IS DOWN
13806230:       NULLPTR EXCEPTION WITH REGISTRYUPDATELISTENER (BIFNDNEPM PREFLIGHT)
13802437:       TRACKING BUG FOR 11.1.2.2.001 PUSH TO BI 11.1.1.6.2
13801537:       TRACKING BUG FOR 11.1.2.2.001 PUSH TO BI 11.1.1.6.2
13801547:       TRACKING BUG FOR 11.1.2.2.001 PUSH TO BI 11.1.1.6.2
13684571:       INCREASE THE DEFAULT FOR JAVAMAXOUTLINES
10623654:        THE DATE AND TIME IS NOT LOCALIZED IN FINANCIAL REPORTING SCHEDULED BATCHES DETAIL INFORMATION.
13861897:       DURING THE LOGIN TIME THE ROLE OF THE GROUP BICONSUMERS IS NOT RETURNED BACK
13857776:       ESSOTLDELETEOBJECT CRASHED DURING SMARTLIST TEST ON LINUX64 AND WINDOWS32
11735177:       REHOSTING TOOL IS NOT TRANSFERRING PROPER USERNAME IN PARTITION DEFINITION
13826968:       SMBUARDESS2.SH AND SMBUARDMXL2.SH CAUSED .XCP FILE INTERMITTENTLY ON HPUX64
13874086:       Fix for backward compatabillity of getdatabaseinfo
13968116:       RUP3 ST5 CDRM:        ESS FAILS TO CONNECT TO ESSBASE
13967992:       RUP3 ST3/ST5 CDRM:       CANNOT CONNECT TO ESSBASE SERVER USING REGISTRY
13964528:       RUP3ST5CDRM / PROJECTS:         OLAP.SERVER.NETCONNECTRETRY ISSUE
13963796:       RUP3 ST3C:       ESS BASE SERVER IS DOWN LS BOUNCE
------------------------------------------------------------------------------------------------------
Patch 13794002:        Patch 11.1.1.6.2 Oracle Business Intelligence Platform Client Installer
-----------------------------------------------------------------------------------------------
13794002  BISHIPHOME 11.1.1.6.2 CUMULATIVE PATCH 1


Monday, April 30, 2012

Change Password (cont.)

I just noticed an interesting screen in BI-Publisher 11g (11.1.1.6) while looking at the screenshots in

Getting Started with Oracle BI Publisher 11.1.1.6.0

Using the "My Account" link, OBIEE 11g end-users can change their passwords without having to go through the not-so elegant approach documented in my previous blog entries.I might have missed this feature in 11.1.1.5, I remember seeing a screenshot in the help link, but the "Password" tab was missing in the app. 
- Log into BIP : http://HOST:PORT/xmlpserver/
- Select My Account

a+
Fiston

Friday, April 6, 2012

Change Password (cont.)

We’ve already compiled our application, we need now to expose the Change Password method via web services.
Right Click on your main class and select “Create Web Service”
p4
Select the default
p5
Click Next
p6
Click Next twice and make sure that the changePassword is selectable and select Finish.
p7
Let’s now deploy the web service to the Weblogic server.
Right Click on the project and click deploy –>Application Server
p8
Click + to add a connection to the Weblogic server
p9
p10
p11
p12
p13
Log into Weblogic em and make sure that your web service was deployed successfully (you can also look at the JDEV log)
p14
Login to the OBIEE portal and create a new action “Invoke Web Service”
p16
And plug in the WSDL
p17
and click open
p18
This opens up a new dialog box, enter the following values for the prompts:
· Username
· Old Password
· New Password
-Confirm Password
For the Username prompt value, select under the drop down “Session Variable”, type in USER and mark it as hidden.
p19
Select the “Options” tab and personalize the messages
p20
Click on the “Action Results” tab and enter the parameters
p22
Save the action.
p23
You can test it by running the action
p24
p25
p26

a+
Fiston

Monday, April 2, 2012

Calling bip runReport from job manager

Here is a quick experiment with Oracle job scheduler manager. As Venkat blogged about long time ago, Oracle Job Manager can be used to call custom Java code. One customer of ours asked about using Job manager to run/schedule BI-Publisher reports? Why would you do that I asked? The final solution we ended up chosing used ADF pages and taskflows.
Privately, I decided to take the challenge and see how to go about implementing the requested functionality. I am taking the WS route and luckily bip comes with several awesome web services, one of them is runReport.
Create a new Jdeveloper generic application:
Application Name: jobManager
Package prefix: bip
Click Next and name your project
Project Name: bip


Next, we’ll add a proxy web service for the BIP server
Add a java class: callBIP


We need to add the 3 jars to the project in order to be able to run custom Java jobs.
    - schedulerrpccalls.jar
    - xdocore.jar
- versioninfor.jar
The code below will call the bip web services, pass in the report xdo absolute path to be run and save the output to the local drive .


package bip;
import com.oracle.xmlns.oxp.service.v2.AccessDeniedException_Exception;
import com.oracle.xmlns.oxp.service.v2.InvalidParametersException_Exception;
import com.oracle.xmlns.oxp.service.v2.OperationFailedException_Exception;
import com.oracle.xmlns.oxp.service.v2.ReportRequest;
import com.oracle.xmlns.oxp.service.v2.ReportResponse;
import com.oracle.xmlns.oxp.service.v2.ReportService;
import com.oracle.xmlns.oxp.service.v2.ReportService_Service;
import com.siebel.analytics.scheduler.javahostrpccalls.SchedulerJavaExtension;
import com.siebel.analytics.scheduler.javahostrpccalls.SchedulerJobException;
import com.siebel.analytics.scheduler.javahostrpccalls.SchedulerJobInfo;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;

public class callBIP implements SchedulerJavaExtension {
public static String userID = "weblogic";
public static String password = "welcome1";
private static ReportService_Service reportService_Service;
        public void cancel() {
        }
    public void run(SchedulerJobInfo jobInfo) throws SchedulerJobException {
        reportService_Service = new ReportService_Service();
        ReportService reportService = reportService_Service.getV2ReportService();
        try {
//Take the first paramater as the report xdo file and call the bip web service
            ReportResponse reportOutput =
                callBIP.runBipReport(reportService, jobInfo.parameter(0));
//Save output to local drive
       String strFilePath = "C://temp//report.pdf";
       FileOutputStream out = new FileOutputStream(strFilePath);
            out.write(reportOutput.getReportBytes());
            out.close();           
        } catch (IOException e) {
            jobInfo.setMessage(e.getMessage());
            jobInfo.setStatus(2);
        } catch (InvalidParametersException_Exception e) {
           jobInfo.setMessage(e.getMessage());
            jobInfo.setStatus(2);
        } catch (AccessDeniedException_Exception e) {
           jobInfo.setMessage(e.getMessage());
            jobInfo.setStatus(2);
        } catch (OperationFailedException_Exception e) {
           jobInfo.setMessage(e.getMessage());
            jobInfo.setStatus(2);
        }
    }
    public static ReportResponse runBipReport(ReportService reportService,
                                           String reportName) throws InvalidParametersException_Exception,
                                                                            AccessDeniedException_Exception,
                                                                            OperationFailedException_Exception,
                                                                            FileNotFoundException,
                                                                            IOException {
        ReportRequest req = new ReportRequest();
        req.setAttributeLocale("en-US");
        req.setAttributeFormat("pdf");
        req.setReportAbsolutePath(reportName);
        ReportResponse reportOutput = reportService.runReport(req, userID, password);
        return reportOutput;
    }

    }
}

Compile the code and deploy the JAR file to the javahost lib directory.
Change the javahost config.xml flag to enable custom java code processing by javahost.

Start Job Manager and enter the class name bip.callBIP, the class Path jar file: bipFile.jar. The report full xdo path is passed as a parameter in the parameters section



Execute the job et voila
Of course reports can be scheduled as well using this approach.

a+
Fiston




Monday, February 27, 2012

Playing with the Summary Advisor


The goal for this posting is to do a quick experiment with the new OBIEE 11.1.1.6 feature "Summary Advisor" based on what I had a chance to learn about it and to document the steps:  For this I'll be using an "Exalyticless" setup with the following components
11.1.1.6
TimesTen 
Oracle db
First there are few required steps that have to be done in TimesTen, the OBIEE RPD and the Weblogic enterprise manager.
TimesTen:
Download 
Installation Guide
Once TimesTen is installed, create a new connection in SQL*Plus or SQL Developer. Once connected,  create a new user that will be used by the Admin Tool to connect to TimesTen.  

create user bi11g identified by Admin123;
grant create table to bi11g;
grant select on SYS.OBJ$ to bi11g;
grant create session to bi11g;

Create a new connection to SQL Developer for bi11g and a table BI_TABLE. BI_TABLE will be used to test the connection pool for the Summary Advisor 
Name: BI_TABLE1
Column Name: COLUMN1 (VARCHAR2(4000))

Add one row of data just for testing

OBIEE Admin Tool
Log into the Admin Tool and create a connection pool to the TimesTen instance, this will be used by Summary Advisor as a target data store.



Enable the COMPRESS_COLUMNS to cause the Summary Advisor to create aggregates in TimesTen using the Compressed Columns capability.

WL Enterprise Manager
  • Need to make sure that the Usage Tracking parameters and the Summary Advisor settings are set correctly. 
  • Log into WL enterprise manager and navigate to the “System MBean Browser”

  • Navigate to the BIDomain.BIInstance.ServerConfiguration 

We need to make sure that the values are in sync with the repository settings.
Now that we’re done with the settings, we can test our system without the Summary Advisor feature implemented; this will serve as a reference that will be used for comparison once the Summary Advisor is implemented. This will be the topic of a future posting.

a+
Fiston