Thursday, 20 September 2012

RPD Deployment in OBIEE 11g

Goto the weblogic EM console:
using http://obiee_server_name:7001/em

Expand 'Business Intelligence' node on the left and choose Coreapplication.
Now click on the Deployment tab on the right. Next, go to the Repository tab.
Click on 'Lock and Edit Configuration' to enable you to change the default settings.
Select the RPD you want to use:
Enter ther RPD passwords and press update:
Press Apply:
You might see a name change:
Click on Activate Changes:
Click on top of the page on link „Restart to apply recent changes‟. This only takes you to the page where you can restart services.
Click on blue button „Restart‟ (or green button „Start‟) under the Manage System category, middle of screen,
Click yes on dialog box to confirm the move. Wait for message that confirms successful restart.
Create the report using
c u next time

Wednesday, 19 September 2012

Graph views in OBIEE 11g

Create a simple Graph
1. Bar Graph: Create Bar Graph: Select the required columns from the subject area.
Click on the results, this will bring you the tabular (table) form of report. Select on new View and click on Graph > Bar > Vertical.
In Bar Graph, you can find vertical, horizontal, stacked vertical and stacked horizontal.
The above graph is the default Bar graph. You can find some important icons on the header of the graph, edit graph properties, show graph results, and show/hide graph layout pane.
In the Layout pane, you need to place the columns in graph prompts if you want that column to act as prompt, in section, if you want column to act as section which will display all values in different section, in measures, bars etc to create right bar graph.
There is a slider option in section. This is a new feature in OBIEE11g, if you check mark on the “Display as Slider” and set the section properties to 5 as an example, that column will work like slider in the graph.
I have placed the columns in right places. You can see below graph results.
After creating the Bar graph, click on Done and save the analysis.
You can go to the graph properties; the Bar graph properties are same as it was in 10g version with few new features.
All the options are self-explanatory, you just need to check each of these options and understand its results.
Important Properties: Zoom and Scroll: Use this option to zoom details in the graph.
2. Line Graph
Follow the above process to select the required columns in the reports before you create the Line Graph.
Go to new View and select Line Graph. There are 3 line graph style and you can use graph in 2D or 3D.
Zoom option on the graph properties to zoom the graph in particular area and zoom out as well. This is the new feature in OBIEE11g.
Make use of all graph formats available in OBIEE11g which are better compared to OBIEE10g. After creating the Line graph, click on done and save the analysis. I will not go through all the graph views at this moment and will do based on the request.

c u next time

Differnt Views in OBIEE 11g

Hi Friends ...
i will blog how to create each and every view in obiee 11g

How to Create a Simple Table View
New > Analysis > Subject Area
This will take you to the analysis criteria section. This section contains three sub sections, subject area, selected columns, and filters.

Select the required columns from the subject area and click on results. This will create the default table View in compound layout.

Important features: Schedule Agent, Table View Properties, Create Compound layout etc.
Click on the Edit Title view and provide required details, like report title, sub title, report run date, logo etc.

Click on the Edit Table View to edit table view layout.

On the table view edit section, rearrange the columns as per the report need. You can create prompt section and exclude columns from the table view.

Above is the Table View property. Paging Controls: Where you want to place the paging controls, by default it will be at bottom, you can change it onto top. Rows Per Page: By Default only 25 rows it will display, you can change it. Enable alternative row green colour etc.

c u next time...

Monday, 17 September 2012

Master-Detail Report Feature of OBIEE 11g

Working with the Master-Detail Report Feature of OBIEE 11g (pt. 1)

One of the new features included in OBIEE 11g is the Master-Detail linking feature. The Master-Detail linking allows you to establish a relationship between 2 or more views; one view is called the Master and will drive changes in 1 or more views called detail views.

You can think of a Master-Detail relationship in a similar manner that you would when navigating from 1 report to another works, but you do not lose sight of the master view.

So, how do we implement a Master-Detail link?

We start out by defining an analysis that will be used to create the master view. Here we have created a simple analysis and filtered for Year = 2008.

Now we want to configure this analysis so that we can create our master view. We will select the “Per Name Qtr” column as the data driver; so, we open the Column Properties window of this column and move to the Interaction tab.

Here we select the “Send Master-Detail Events” under the Value Primary Interaction. Once you select this option a secondary edit box labeled “Specify channel” will be made available. You can enter any unique identifier in this box. For our example, we have entered “MDS2”.

Unlike some interaction options like Action Links” which is available on both Column Heading and Value, the Master-Detail option is only available on the Value. This has to do with how a Master-Detail link functions. The value of the cell you click on is passed to the detail view(s); thus, a column heading cannot be used.

We now navigate to Results and create the view we want as our Master view. Here we are using a simple tabular view. Notice that our “Per Name Qtr” values do not show the typical hyperlink that you would expect from the time dimension column.

Now we need to create a detailed view that will listen to events from our master view. To do this, we will add an additional graphical view from the same analysis. Our graphical view will look at Revenue by Brand with our Quarter values placed into a view slider.

With our graphical view in edit mode, we need to open the properties window.

One of the properties available to us is the “Listen to Master-Detail Events” checkbox. By checking this box, we can define this view to be a detailed view for the event channel we want. In our case, we will enter the value “MDS2” as our event channel which is the same value we defined on the “Per Name Qtr” column properties which is our data driver on the master view.

We want to validate our Master-Detail report is working as expected. We will do this by placing the compound layout on to a dashboard page. I have edited the compound layout so that my views, master and detail, are side-by-side. When you click on a cell under the “Per Name Qtr”; such as, “2008 Q2” on the tabular master view, the secondary detail view (graph) accepts the Qtr value and the slider automatically moves to the selected value.

Working with the Master-Detail Report Feature of OBI 11g (pt 2)
In previous part of this series, I stepped through how to configure a Master-Detail report link when using the same analysis criteria to create the master and detail views. However, what if we want to create a totally independent detail view based on different criteria. Can we link the Master view from 1 analysis to the Detail view of another analysis?

Let’s see.

We will the Master view we created previously; so, we need to first create a new, independent Detail view and set our Event channel, the Event channel we used previously was MDS2.

Our event channel on our master view is driven by the “Per Name Qtr” so we need this column on our new detail view so that it can accept and act on the value being passed.

We will use a pie chart view for our detail view. With the view created, we can now set the Event channel through the view’s property window. We are using the slider again for the Quarter to make it easy to see the change.

With our new detail view created and configured to listen on the same channel as our master view we will add the view to our dashboard and check out if it works as we hope.

So, we have now shown that the detail view of a Master-Detail link does not need to come from the same report criteria as the master view.

I did come across an issue when using Master-Detail links and setting up a detail view to listen on the event channel, but configuring the layout of the detail view to not allow it to respond correctly. For example, I added a tabular view to my Master-Detail dashboard but placed the Qtr column in the “section” area of the layout. The report displayed all 4 quarters when I issued the event and my other detail views responded as expected. However when I tried issuing a subsequent event, none of the detail reports would respond. For the tabular view to respond correctly to an event, the column accepting the event must be placed in the “page” area of the view layout.

Here is a table containing specifics about views being used as detail views.

Working with the Master-Detail Report Feature of OBI 11g (pt 3)
The final installment of this series will look at configuring detail views to listen to multiple event channels.

My first step will be to create a new Master View analysis. I am going to create a simple tabular view as my second master view including the Qtr column I have used previously for my data event driver. I have set the Channel name to MDS3 in the same way I configure my first master view.

I have saved that analysis and now want to edit 1 of my detail views to listen on this channel as well as the MDS2 channel it is currently listening on.

Just a side note: If you have been following this series, you will notice the view names have changed as well as the view layout on the dashboard page from my previous posts. I have renamed my views and reorganized them on the dashboard to make things a little clearer. Other than the changes I have outlined here, the other views remain unchanged.

So, the detail view I decided to modify is the second one I created which has the pie chart. Opening the pie chart view in the editor window and opening the properties for it, I have added my new channel to the event channel. Notice the channels are separated by a comma. With that change made, I then save this analysis.

Adding the new Master view to my dashboard page, I am ready to test this new functionality.

Clicking on the 2008 Q2 cell from my first master view, both detail views respond with the Qtr column slider moving appropriately.

I now click on the 2008 Q3 cell on my second master view, on the detail pie chart view does respond as expected with the Qtr slider moving to the appropriate value while the other detail view remains unchanged.

Thus we can see that a detail view can listen to multiple events from different master views.

There is actually more to learn and do with Master-Detail links but that is a different discussion as it involves extending OBI with some custom code. I will leave that for a later time.

The 11g Features

There has been a lot of deserved hype about the major enhancements in OBIEE 11g such as Action Framework and Embedded Maps, but we thought it would be a good idea to start compiling a list of the more subtle enhancements you may not have heard about!    

1) Multiple Subject Areas

Did you know that Answers reports (Analyses) can now be sourced from multiple Subject Areas?    This is significant as it means you no longer have to cram lots of content into a single Subject Area!

2) Conditional Data Formatting

When you apply Conditional Formatting via "Column Properties" in Answers, there is an additional tab to allow you to conditonally change the "Data Format" as well as the "Style".

3) Case-Insensitive Searching

When using the "search" facility to choose your filter values within Answers, there is now a "Match Case" option that enables you to perform a case-insensitive search.
NOTE: There is also a "Match Case" option when performing member selection

4) Conditional Formatting

Conditional formatting is now possible on Pivot Tables (even on Hierarchical Columns).   

5) Dashboard Prompts

There is a new style of dashboard prompt called a "Variable Prompt" which allows you to specify your own custom list of values for the dashboard prompt (instead of always having to source the values from a Subject Area)

6) Importing RPD Metadata

Within the Physical layer of the RPD, when you right-mouse click on a Connection Pool there is a new "Import Metadata" option.    When adding further tables, this new option is much better than the "File > Import" menu option because all the new metadata will get imported directly into the existing Physical Database (so you won'tyou get another Physical Database created).
To make it even better, this new "Import Metadata" option will perform an incremental update of your existing tables and their columns.   So if you create new columns on your database, the tables in the RPD will be incrementally updated.   

7) Time Series Calculations

There are now 3 types of Time Series calculation available (AGO, TODATE and PERIODROLLING).    Another great enhancement is that it is now possible for report developers to build their own Time Series calculations in Answers, so you no longer have to rely on them being created in the RPD.   

8) Building Subject Areas

In the BI Administration tool, you can right-mouse click on a Business Model and choose the option "Build Subject Areas for Logical Stars and Snowflakes".    This option will automatically create a Subject Area dedicated to each logical fact in your Business Model.    Each Subject Area will one logical fact together with all its related logical dimensions.

9) Archiving/Unarchiving

You can now archive/unarchive BI Presentation Catalog content directly within the dashboard front-end, you no longer need to use the BI Catalog Manager utility.

10) Presentation Variables

It is now possible to assign multiple values to a Presentation Variable.

11) Rename Wizard

In the BI Administration Tool, you can now right-mouse click on an object and choose the "Rename Wizard" option.   This is a short-cut which will invoke the Rename Wizard directly for all the objects you selected.    In OBIEE 10g, you could only invoke the Rename Wizard via the "Tool" menu and it meant you would always have a few extra steps to do the renaming you wanted to.
There is also new new formatting option with the Rename Wizard:  Change all occurences of "_" into a space

12) LDAP Authorization

With the new OBIEE 11g security model, it is now possible for OBIEE to find out the "groups" belonging to a user directly from an LDAP store.    In OBIEE 10g, you could only do this indirectly via a PL/SQL package.

13) BI Publisher - Local Excel Files

It is now possible with BI Publisher 11g to upload your own local MS Excel files and use them as a data source for your BI Publisher reports.

14) RPD File Compression

To reduce storage needs, repositories are now stored in a compressed format. Because of this, you may notice that the size of an RPD file opened and saved in this release is significantly smaller than the size of RPD files from previous releases.

15) Oracle OLAP Integration

OBIEE 11g can now supports Oracle OLAP as a data source.    This means Oracle OLAP is now a definite option for OBIEE if you need to optimise the underlying Data Warehouse.

16) Master-Detail Linking

In addition to "drill-down" and "navigation", there is a new "Master-Detail Linking" capability which allows users to click on one table/graph/map to automatically apply filters to other views within the same Analysis (it can even apply filters to other Analyses on the same Dashboard Page).

17) View Selectors

It is now possible to include Compound Layouts in view selectors.


Wednesday, 12 September 2012

OBIEE 11g User Interfaces

OBIEE 11g gives different types of user interfaces .
Using these interfaces ,we are able to create reports ,publish the reports, create security  groups and users.

Using this we are able to access existing reports & dashboards
and we are able to create reports & Dashboards
This is the link for OBIEE publisher.
OBIEE publisher is to create pixel perfect reports.
like vouchers ,pamphlet ,statements.

This is the links for Enterprise Manager.
Using Enterprise Manager
1.we are able to control OBIEE components(i.e. Presentation services, I services , Java host ,cluster controller) individually or as whole.
2.We are able to upload RPD file
3.we are able to configure Scheduler
4.we are able to upload Catalog folder.
5.We are able to enable disable or enable global chache and specify cache related perameters
6.We are able to configure Mail server.

This is the link for Weblogic console.
Using this link
1.we are able to create Groups, users
2.we are able to create Application roles & Application policy.
3.we are able to map a particular user to groups >Application roles and Application policys.

OBIEE 11g Architecture

Hi Friends this is my first Post………………..
We need to understand the architecture how each and every component is connected internally.
We have two logical set of components here
1.weblogic domain
2. OBIEE domain.
 OBIEE domain contains all OBIEE components and weblogic domain contains
Two different components
1.Enterprize manages (i.e this we need to use to control obiee components)
2.weblogic console(i.e. this we need to use to create group ,users )