8 responses to “OBIEE Impact Analysis – What if I delete a column from RPD, what are the reports that are being affected? – Part 2

  1. amit

    June 10, 2013 at 2:07 am

    Nice post. Keep it up.

  2. Jonathan

    June 21, 2013 at 1:49 pm

    Thanks so much. We implemented this and tied it with Usage Tracking. Great idea!

  3. Shalini

    July 15, 2013 at 7:31 am

    Thank you for providing the detailed steps. Could you please also suggest a method how to find out what all reports are having filter conditions for a particular column that we wish to delete.

  4. michael

    July 25, 2013 at 2:45 pm

    Hi,Attractive piece of information of “OBIEE Impact Analysis” ,and let me tell you, your website gives the best and the most interesting information. This is just the kind of information that i had been looking for, i’m already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanks a lot once again,

  5. Venu Kavuru

    December 18, 2015 at 12:39 am

    Dear Shiva,

    Happy techie blogging and value added post

    Already following the approach you mentioned using two excel files webcat & RPD, but your approach to import in to database and analyzing them seems to be a good idea.

    However, Looking for capturing the data model diagram along with Joins and cardinality from BMM layer from Siebel Analytics 7.8 version,

    After seeing your above blog, from the RPD data, the BMM layer info Imported in to SQL Developer tables using them, we hope (need to try) to create the logical tables, using the modeling tool we would be able to mimic/create similar BMM model diagram along with logical table.logical column & Join conditions and cardinality

    Can you please advise ? is there any other better approach ?

    Already raised in forums:

    Appreciate your help in advance.

    Venu .Kavuru

  6. Vinay

    July 1, 2016 at 10:25 am

    Hi Shiva,

    I need to create catalog report using catalog manager,that report contains Subject Area,Name,Owner,Column,Table.
    We can generate report by using export option,but our requirement is we need to automate this process.Could you please help me to do this from informatica side or obiee side.
    If you have script please share to me and also please explain me the process.

    Vinay G

    • Shiva Molabanti

      October 12, 2016 at 12:28 am

      You can use teh catalog manager command line utility (runcat.cmd/sh) with the column names as parameters . And then automate that OS comamnd using cron job or any etl tool.


Leave a Reply

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

You are commenting using your 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

%d bloggers like this: