How to avoid Distinct in OBIEE 11g Reports.

Hi,

By default in OBIEE 11g repository, the distinct feature is enabled and reports doesn’t allowed duplicate records in reports level and it shows each record single time only.

But, some times Clients will asks about this kind of issues and the solution is below:

We have add one Unique ID column (any Id column) to the existing report from the same Subject Area to avoid/disable the Distinct feature which is enabled in Repository level in OBIEE 11g . It’s a default feature from Oracle and they are not supposed to give duplicates to the users in OBIEE 11g reports.  So, we have to disable the distinct feature manually if we need duplicates for any Single report in OBIEE 11g.

Steps:

  1. Login into the Analytics URL and enter required username, password details.
  2. OPen one report wchich is having duplicates in Source level.
  3. Open Criteria tab, then expand Table  from same Subject Area, then drag the “Unique Id(Customer Trx Id)” column and drop it into before the existing report columns.
  4. If you want to hide the newly added column in the report, just right click on new column, select Column Properties–>Column Format–> Hide.
  5. Click on Results tab, select Table view under Views list available in left side pane. Then, click on Edit button to edit the Table view.
  6. Keep the “Unique IdCustomer Trx Id” column at first (By default, the column will be added at last of the columns list. Then we will move backward the column from one place to another.)
  7. Click on Done, then Click on Save.
  8. Now, see the report results and notice that there are duplicate records.

Have a nice time.. 🙂

Thanks,

Raghu Nagadasari

 

Advertisements

About raghunagadasari

Working with a MNC on BI Applications 7.9.6x, OBIA 11.1.1.7.1. Having work exp on EBS, Oracle Apps, ODI, Informatica, OBIEE, Pl/sql,
Image | This entry was posted in OBIEE. Bookmark the permalink.

One Response to How to avoid Distinct in OBIEE 11g Reports.

  1. Gayatri says:

    Tnq..

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s