Tuesday, 12 August 2014

OBIEE Change Analysis Subject Area

Assume you created a more or less complex OBIEE analysis with a lot of views and settings. It perhaps looks like:

OBIEE Analysis

If you want to reuse the analysis and report settings in a new report, then there exists a very fast solution for changing the OBIEE subject area which keeps all the settings. Go to Advanced tab and search for subjectArea in the Oracle BI Analysis XML (usually located at the top):


To change the subject area you need to know the name of the new one, e.g. Supply Chain Process. Now just substitute as follows and press Apply XML:

subjectArea=""Delivery Process""
with
subjectArea=""Supply Chain Process""

As new OBIEE subject area probably doesn't contain the same fields as the old one you will see a lot of errors that fields cannot be found. Change back to Criteria tab and use Column Formula editor to change to the fields needed in the new subject area. Don't delete the fields and add new ones, because thus you would need to adapt your views again.

Be careful not to overwrite your old Oracle BI analysis. Press Save as first ;-)
Interested in some more end user topics? Check out Oracle BI useful things.

7 comments:

  1. Thanks!

    And is there a way to change subject area for a dashboard prompt?

    ReplyDelete
    Replies
    1. You're welcome! Unfortunately there is no smart solution to change the subject area of a dashboard prompt from the user interface. Or better, we didn't find one yet, although we regurlaly ask the same question to ourselves.

      But, if you use the same dimensions for filtering without limiting the values, you can use the former dashboard prompt for the subject area changed. We would recommend to create a new dashboard prompt. That isn't too much work to do.

      Delete
    2. You can edit the xml text of the object in Catalog Manager the same way as in this example.

      Delete
    3. Correct, this would be fine! Catalog Manager is a tool for administrators which isn't intended for end users. So, that's only a solution for OBIEE admins.

      Delete
  2. Change the name of the subject area from the advanced clause.. under the checkbox which says " enter the name of subject area". Might be easy way instead of editing the report xml.
    Thanks,
    Sai.

    ReplyDelete
    Replies
    1. Could do so alternatively for simple analyses. Editing the xml is also feasible for combined results sets and hierarchical columns, even though you need to save the report and open it again.

      Delete
  3. Ya.. you are right!! Dint think in that perspective.
    Thanks,
    Sai Kumar

    ReplyDelete