obieefans.com

Feed Rss

Author: Paul McGarrick
Go to Source

I came across an interesting error when trying to run a customized Informatica Workflow. It failed and this message appeared in the log file:

“The Repository Service marked the session or session instance as impacted, and the Integration Service is not configured to run impacted sessions”

It seems that the Session called by the Workflow had not been refreshed since its parameters were last updated. The fix was simple: Check out the Session within Workflow Manager, right-click it within the Task Developer and choose Refresh Mapping. Finally validate the session and check it back in.

 

 

Very Resourceful Presentation on BI Publisher from Oracle Website

BI Publisher Best Practices

Old topic but still documenting it for my friends who are new to OBIEE.

These are the steps to implement multiple RPD and multiple presentation services on Single BI Server.

1. Change the NQSConfig.ini file as follows:

#################################################################################### [ REPOSITORY ]

RPD1 = samplesales.rpd, DEFAULT;

RPD2 = paint.rpd; ####################################################################################

2. There has to be two System DSN pointing to two different rpd.

AnalyticsWeb which is the default one. Change the default repository to RPD1 as shown in the below screenshot.

 

AnalyticsWeb_Test should be the new one. You can give any name.

Change the default repository to RPD2 as shown below.

 

So, the two DSN should be present in System DSN as follows.

 

3. Make sure two Catalogs samplesales and paint are present in C:\OracleBIData\web\catalog folder.

4. There has to be two instanceconfig file pointing to two different catalog and DSN.

Make a copy of instanceconfig.ini and name it as instanceconfig_test.ini

In the instanceconfig_test.ini file, add the listener port,change the system dsn and point it to paint catalog. Assuming the 1st config file points to samplesales catalog.

5. Deploy a new presentation server instance

Login to Enterprise Manager.

Username: oc4jadmin

Password: Password you gave while installing OBIEE.

Go to Application tab and click on Deploy.

Select the analytics.ear file from the following location and click next.

Give the application name as follows and click next:

In the next screen, click deploy. And you will get a successful confirmation page.

6. In the web.xml file of analytics_test application present under C:\OracleBI\oc4j_bi\j2ee\home\applications\analytics_test\analytics\WEB-INF folder,

modify the port as follows:

<param-name>oracle.bi.presentation.sawserver.Port</param-name> <param-value>9712</param-value>

7. Create a new presentation service from the command prompt.

Go to Registry Editor > HKEY_LOCAL_MACHINE>SYSTEM> CurrentControlSet>Services>sawsvc2 and update the image path as follows

“C:\OracleBI\web\bin\sawserver.exe” /service /c c:\OracleBIData\web\config\instanceconfig_Test.xml

A new Presentation Services “Oracle BI Presentation Server 2″ will be listed in the windows services as follows:

Restart all the services and OC4J.

That’s all and you can use these URLs for your two presentation services.

http://localhost:9704/analytics/saw.dll?Dashboard

http://localhost:9704/analytics_test/saw.dll?Dashboard

Thank you. Please let me know if you find any difficulty.


Go to Source

Below is the list of Default ports for OBIEE 11g. If you already have 10g on your box and you wish to install 11g on the same box( Oracle does not recommend this) you can edit below port during your installation in such a way that both 10g and 11g uses different ports.

You can find the same file located at below location.

bishiphome/Disk1/stage/Response/staticports

[WEBLOGIC]

 

#The Domain port no. This is the listen port of Weblogic Adminserver for the domain.

#Domain Port No = 7001

 

#The “content” port for the BIEE apps. This is the Weblogic Managed Server port on which BIEE applications are deployed.

#Oracle WLS BIEE Managed Server Port No = 9704

 

#The SSL port for the Weblogic Managed Server

#Oracle WLS BIEE Managed Server SSL Port No = 9804

 

[OPMN]

 

#Process Manager Local port no

#Oracle Process Manager Local Port No = 6700

 

#Process Manager Remote port no

#Oracle Process Manager Remote Port No = 6701

 

#Process Manager Request port no

#Oracle Process Manager Request Port No = 6702

 

[BIFOUNDATION]

 

#The listen port for OracleBIServer component

#Oracle BI Server Port No = 9703

#The monitor port for OracleBIServer component

#Oracle BI Server Monitor Port No = 9701

 

#The listen port for OracleBIPresentationServices component

#Oracle BI Presentation Services Port No = 9710

 

#The listen port for OracleBIScheduler component

#Oracle BI Scheduler Port No = 9705

 

#The monitor port for OracleBIScheduler component

#Oracle BI Scheduler Monitor Port No = 9708

 

#The script RPC port for OracleBIScheduler component

#Oracle BI Scheduler Script RPC Port No = 9707

 

#The listen port for OracleBIClusterController component

#Oracle BI ClusterController Port No = 9706

 

#The monitor port for OracleBIClusterController component

#Oracle BI ClusterController Monitor Port No = 9700

 

#The listen port for OracleBIJavaHost component

#Oracle BI JavaHost Port No = 9810

 

[ESSBASE]

 

#The listen port for Essbase Agent

#Essbase Agent Port No = 1423

Question:

 

We have a requirement to trigger a mail to all the above employees with the employee specific data. 

We can not use Organization based data level security as everyone belongs to the same org. We cannot use position based data level security as everyone has the same position.

How would you do that?

Solution:

Create the above report and save it.

Create an iBot with the following features.

Data visibility : Not personalized. Run as Administrator

Conditional Request: Browse and Select the above report

Schedule: Your choice

Recipients: Select Determine recipients from the conditional request. Select Column containing Recipients as Emp Login. You can select it from the dropdown list.

And select Show Relevant rows only. For this option to work, the delivery content must be set to the conditional request’s result. i.e. Same report as conditional request report. 

Save the ibot. That’s it..

If you have your SA System Subject Area implemented, then it will take the delivery profile of each employee from SA System and deliver the report accordingly.

So Akash Jain would receive only the following content in the mail.

Similary the other two employee would receive their own data.

This is actually called report bursting. So the interviewer would expect you to use this term.

This can also be done with BIP Report bursting feature.