How to “Return to previous screen From Target Page

Hello All,

Today will discuss a simple thing which so many reporting people don’t know how to “Return to previous screen from target page”

Check the below screen, if I will click on “Return to previous screen” It should go to “Home page of OBIEE”

You can set any thing as ‘’Return to previous screen” for example Report, Dashboard, Agent, KPL or any browser link. Here I have taken home page of OBIEE as “Return to previous screen”.

Steps:

1: Go to Target page - Dashboard and click on edit dashboard

2: Drag the Text object from dashboard object.

3: Go to Text object properties and check the “Contain HTML Markup”

4: Put the below HTML code and in href give it your OBIEE home page path. Save the dashboard

            <div>

<a href=http://obi.rakeshpatil.net/analytics/saw.dll?bieehome>

Returns to Previous Screen

</a>

</div>

5: Save the dashboard and click on “Return to Pervious screen”. Once you click on “Return on Pervious Screen” Home page of OIBEE came from target page.

If you have any question, Please don’t hesitate to contact me.

-Rakesh Patil

-rakeshpatil002@gmail.com

Master-Detail linking - OBIEE 11g

Master-Detail linking new features included in OBIEE 11g. It was not in 10g.

Master-detail linking of views allows you to establish a relationship between two or more views such that one view, called the master view, will drive data changes in one or more other views, called detail views

Assume that we have three views; one view which shows “Contact Num count –Rakesh Patil” by Quarterly lines while the other two graph view that shows “Contact Num count –Rakesh” by months with prompt quarter. Link these three views so that when you click on particular quarter, month in the graph changes to as per selected quarter 

Create the simple report.

Click on “Contac Num Cout –Rakesh Pati”.Go to Column Properties and click on interaction and Go to ‘Interaction Tab –>Primary Interaction –> Send Master Detail Events àEnter the channel name , I have given “RA01”

Click on results and create a Graph view à.Edit the Graph view ,click on Graph properties –> Enter the Channel name that we specified in Master Report –i.e. “RA01”

Save the report and click on quarter. Once you click on quarter you will see the both graph will show the month as per the selected graph.

I hope you will understand..:)

Regards 

Rakesh Patil 

Creating Physical table / Opaque View in Physical Layer

Do you know how to create the physical table in OBIEE which does not exist in DB and if in case you have created the table then how you will deploy into DB?

Suppose you want to use the Channel class for report only whose Channel class is 'Direct'. Remaining Channel class details are not at all needed for any reporting purpose. To solve such kind of problem you can create Opaque View / Physical table.

Below is the process to create view and deploy created view into DB. I have created the Channel_View physical table

1: Click on ‘ORCLRAKE’. Go to 'Features' tab and from available option select  'CREATE_VIEW_SUPPORTED' is checked or not. If it is not checked then check the option.

  

2: Right click on the SH schema -> Select New physical Table.

3: Created Physical Table - Channel_View

In General tab - Select Table Type as “Select” and Type the SQL code. Make sure that “*” Should not be in Select Statement

4: Created  Channel_Class Column  

Click on “+”, Specified the column name and datatype for column. Make sure the that column name should be same otherwise you get error.

5:Save the RPD.  Now you can see the Channel_view with different icon symbol in the physical layer.

6: Right click on Channel_view. Select update Row count and View Data.

7: Right clicking on the table 'Deploy View(s)' will be enabled. Click on 'Deploy view(s)' option. The following screen will appear. That will confirm what are all the table going the deployed. Just click with the below screen. Make sure that View Name and New table name should not be the same.

8: View is deployed successfully with the below screen.

.

Testing The View in DB :

-Rakesh Patil

-rakeshpatil002@gmail.com

Difference between in OBIEE 10g / OBIEE 11g

Hello All,

If you’re in OBIEE you should know the difference between in OBIEE 10g and 11g.

As per my knowledge below are the difference I have seen. I hope you will understand the point

OBIEE - 11g

1.    64-Bit

2.    Server Name – Weblogic  Server or you can call Oracle Enterprise Manager Fusion Middleware

3.    Repository and Configuration in EM - Oracle Enterprise Manager Fusion Middleware

4.    User, Group Created in Fusion middleware console and Role Created in EM

5.    You can integrate with any application for example Salesforce, SAP or all CRM tool. Because 11g have separate console where you can do deployment, Integration.

6.    Time series function - Ago, Today and period rolling. Added new TSF i.e. PERIODROLLING

7.    Dimension Hierarchies - Level-Based Hierarchy and Parent-Child Hierarchy, introduces new DH i.e. Parent-Child Hierarchy

8.    Repository password protection. Need RPD password.

9.    The RPD now has a password. This security is partially to protect the RPD access,

10.  KPI and Scorecard was introduces in OBIEE 11g

11.  REQUESTS have been renamed to ANALYSIS

12.  IBOTS have been renamed to AGENT

13.  CHARTS have been renamed to GRAPHS

14.  Presentation columns have been renamed to attribute columns

15.  11g supports Ragged & Skip Level Hierarchy

16.  Column selector in 11g can be defined on multiple columns

17.  The ability to create custom print layouts for dashboard page

18.  You can now change the repository password from the command line using the obieerpdpwdchg utility

19.  Breadcrumbs -It allows users to keep track of their locations within programs or documents

20.  New Graphs  Waterfall graph, Stacked graph and 100% Stacked graph in n 11.1.1.7

21.  Map view is a new view type that presents data in spatial form

22.  11g allows us to work with multiple subject areas in same report.

23.  New Menu Options for Exporting Views and Results I.E - Excel 2007+ and PowerPoint 2007+

24.  SQL Results prompt option -If you are working with double columns, you can now write the SQL statement so that filtering is done on code values rather than display values

25.  New View type i.e. - performance tile in 11.1.1.7

26.  To install OBIEE 11g, You Must have to install database and RCU.

27.  Recommended Visualizations Feature for Creating Views

OBIEE - 10g

1.    32 Bit

2.    Server Name - OC4J - Oracle Containers for J2EE

3.    Repository and configuration Upload is done in NQSConfig.ini

4.    User, Group and Application role are created in Repository

5.    Integration with other application like SAP or other CRM tool it was not easy. Easy integration with only Siebel CRM

6.    Two Time Series function - Ago and Todate.

7.    Dimension Hierarchies - only you can do Level-Based Hierarchy

8.    No Repository password protection

9.    RPD has a no password. There was no protection for RPD

10.  KPI and Scorecard was not introduces in OBIEE 10

11.  REQUESTS have been renamed to ANALYSIS in 11g

12.  IBOTS have been renamed to AGENT in 11g

13.  CHARTS have been renamed to GRAPHS in 11g

14.  Presentation columns have been renamed to attribute columns in 11g

15.  10g does not support Ragged & Skip Level Hierarchy

16.  Column selector in 10g can be defined just one column

17.  No Option to create custom print layout for dashboard page.

18.  No Breadcrumbs option

Regards

Rakesh Patil 

Users Name not showing in RPD

Hello All,

After installing OBIEE 11.1.1.5 you will get below error.

Issue:

If I open the RPD in online mode and go to Manage / Identity, I should see the list of users defined on the WebLogic side. Unfortunately, I do not see ANY users. 

Solution:

1.       Go to Manage -> Identity -> Select BI Repository

2.       Click on Action and select online user filter

3.        You can apply any filter to username and fetch the users. The field is empty by default (because of that you did not see any users), if you enter * it will fetch all users.

4.    Result : 

- Thanks 

-Rakesh Patil

OBIEE 11g - Pivot table indent background color change

Hello All,

I hope all are fine. Yesterday night i got the mail from my manager and he is asked me change the pivot table indent background color.

This is very simple but so many new folks don't know. Please follow below steps.

Solution

1: Open you report. Here i have taken sample test report

2: Add Static Test View and Apply below code and check-mark HTML option in the static view

3: Result

I hope you understand....

-RAKESH PATIL

Prompt User operator on a Dashboard prompt:

Hello All,

Previously the type of "operator" used on a dashboard prompt was fixed by the report developer e.g. "Is equal to / is in".etc. , so an end user could not able change to select the operator as per you his requirement.

To select the operator as per user requirement you can use Prompt User operator.

1: Go to dashboard prompt editor

For example :  I have Taken " Manager Name" as  prompt 

2: Edit the Manager Name Prompt and set the "Operator" to "* Prompt User":

3: You will see flexibility by allowing the end user choose which type of operator should be used to filter on the values.

- Thank you 

- Rakesh Patil 

OBIEE 11g Log - Files

Hello All,

So many people don't know the log file name and their path. This will be helpful for them.

1 . Log on to EM - Enterprise Manager Console
2 . Go to Business Intelligence –> coreapplications –> Diagnostics –> Log Messages
3 . Below is the Available log file Name.

• Presentation Services Log
• Server Log
• Scheduler Log
• JavaHost Log
• Cluster Controller Log
• Action Services Log
• Security Services Log
• Administrator Services Log

You can open manually log file from directory

Log File Name	Path
NQQuery	C:\OBIEE11g\instances\instance1\diagnostics\logs\OracleBIServerComponent\coreapplication_obis1
NQServer	C:\OBIEE11g\instances\instance1\diagnostics\logs\OracleBIServerComponent\coreapplication_obis1
NQSAdminTool	C:\OBIEE11g\instances\instance1\diagnostics\logs\OracleBIServerComponent\coreapplication_obis1
NQSUDMLexce	C:\OBIEE11g\instances\instance1\diagnostics\logs\OracleBIServerComponent\coreapplication_obis1
SAW log	C:\OBIEE11g\instances\instance1\diagnostics\logs\OracleBIPresentationServicesComponent\coreapplication_obips1
JavaHost	C:\OBIEE11g\instances\instance1\diagnostics\logs\OracleBIJavaHostComponent\coreapplication_obijh1
NQScheduler	C:\OBIEE11g\instances\instance1\diagnostics\logs\OracleBISchedulerComponent\coreapplication_obisch1
NQCluster	C:\OBIEE11g\instances\instance1\diagnostics\logs\OracleBIClusterControllerComponent\coreapplication_obiccs1
ODBC	All Log Regardaing OPMN will found in C:\OBIEE11g\instances\instancke1\diagnostics\logs\OPMN\opmn

-Thanks
-Rakesh Patil

OBIEE 11.1.1.7 New Version

Hello Friend,

In OBIEE 11.1.1.7, they have added so many better feature for example "Recommended Visualizations"

I have not done any practical work on 11.1.1.7 so I have taken few screen shot and notes from oracle document.

OBIEE - 11.1.1.7

Changes in the OBIEE 11.1.17

End Users:

Ø  Recommended visualizations

Ø  Breadcrumbs

Ø  Auto-generate BI Publisher reports for high-fidelity dashboard printing

Ø  Freeze columns

Ø  New graphs: waterfall, area stack, 100% stacked

Ø  New "Performance Tile" view

Ø  Null supression

Ø  Endeca-powered full text search

Ø  Smart View for MS Office

Mobile:

Ø  New Oracle BI HD app for iPad

Developer (Admin Tool):

Ø  Change BI repository password from command line

Ø  Apache Hadoop as a data source

Ø  Multi-source session variables

Administrator:

Ø  Installation on IBM WebSphere

Ø  Multitenancy

Ø  New Privileges

Ø  Asynchronous calls to BI Server metadata web service

Ø   

BI Publisher:

Ø  Direct connection to BI Server subject areas (sans data model)

Ø  Enhancements to Excel Template Builder, Layout Editor, Report Wizard, PDF to PCL

Ø  Endeca as a data source

Ø  Support for (E-Business Suite) flexfields

Ø  MDX Query Builder

Ø  Local XML and CSV files as data sources

-Rakesh Patil

-rakeshpatil002@gmail.com