BusinessObjects Board

How to search specific DB function used in report

security CMC
#1

Hi experts

Here is typical requirement –

We have a database function named Func1() used in several objects definition of a particular universe say Unv1. Now, we want withdraw that function and replace with a new DB function. To do, I need to know the report(s) name where that Func1() is in used. Any idea how to search? I had tried with CI_INFOOBJECTS and CI_APPOBJECTS but with no luck.

Any idea will appreciate!

SD_0833 :india: (BOB member since 2008-08-07)

#2

Hi,
Is there any specific reason behind looking at which reports use Func1()?
Changing the Object defination in universe (i.e function) should directly reflect in any reports using those objects.

If you need to get list of objects used in reports,check this post in BOB’s Downloads
https://bobj-board.org/t/60568

Thanks

forgotUN (BOB member since 2006-12-13)

#3

Yes, Before we proceed with the change, we need to submit an impact analysis document where need to mention the report name uses that function.
Is there any way to do?

SD_0833 :india: (BOB member since 2008-08-07)

#4

Note down the Object names (i.e with Func1()) and use the tool provided in above link.
Thanks

forgotUN (BOB member since 2006-12-13)