cancel
Showing results for 
Search instead for 
Did you mean: 

List on UNV universe

Former Member
0 Kudos

HI

How to get the list of webi reports build on  type UNV universes not UNX on a specific folder in BO?

Thanks

Ashu

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

You can also check the below link

Former Member
0 Kudos

Hi Ashu,

'To get the list of all WebI Reports based on given Universe (.unv, .unx), following SQL code can be used in VBA.

strSQL = "SELECT * FROM CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS  Where PARENTS ( " & Chr(34) & "SI_NAME = 'WEBI-UNIVERSE'" & Chr(34) & "," & Chr(34) & "SI_NAME = 'Opex'" & Chr(34) & ")" & "OR PARENTS ( " & Chr(34) & "SI_NAME = 'Document-DSL.Universe'" & Chr(34) & "," & Chr(34) & "SI_NAME = 'universename.unv'" & Chr(34) & ")"

Thanks,

Venkat

former_member219634
Active Participant
0 Kudos

Hi Ashu

Use Query Builder and this Query to check :SELECT SI_NAME, SI_UNIVERSE FROM

CI_INFOOBJECTS WHERE  SI_NAME = ‘<Web Intelligence Report Name>’ and

SI_KIND = ‘webi’

Best Regards

Ines