Thursday 17 October 2013

OBIEE 11g: Cannot Copy Data from Reports and Paste to the Windows Clipboard


Scenario:

The users are trying to copy some cells or particular portion of data from Obiee report manually and paste it on Excel,MS Word, Notepad etc. but this is not allowed in the OBIEE 11g version where as the same in possible in 10g. We have created an SR with the same issue and got the reply from Oracle support. I am blogging the same workaround whatever is proposed by oracle here.

Solution:

This feature not available in OBIEE 11g. The only way is exporting the view to another file and then copy/paste.

There is an Enhancement Request for this functionality to be included in a future 11g version:

Bug 10406798- unable to copy data from 11g table or pivot table like in 10g
Currently slated to be addressed in 11.1.1.8 or 11.1.1.9.

The only possible workaround that you may try is described in the following note:

OBIEE 11g: Cannot Copy Data from Reports and Paste to the Windows Clipboard [Doc ID 1287265.1]

As per above note:
Until the enhancement requests are implemented, there is the following work-around:

1) Place the mouse cursor outside the view and click.
2) Drag the mouse across the view to highlight the data you want to copy.
3) Use control+C or copy from the edit menu or right mouse menu to copy the text to the clipboard.

Please note this workaround only works with Internet Explorer. It does not work with Firefox or Chrome.


This issue existing in 11.1.1.7.1 also













2 comments:

  1. I have a requirement to copy an the data similarly but we also have an action link embedded in the report. Is it possible to copy the link too?

    ReplyDelete
  2. You can create an action link to a Is prompted report with only the Filter showing in that report. Let it open in a new browser window. Lets the user select the value and then close the window.

    ReplyDelete