on 12-23-2015 11:17 AM
HI
How to get the list of webi reports build on type UNV universes not UNX on a specific folder in BO?
Thanks
Ashu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.