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