Identifying shortscuts in BI platform CMS system database

[former_member596929]

Hi,
how do I have to build a query based on BI platform CMS system database universe to get a list of all shortcuts including folder path of a defined object (hyperlink, lumx, webi)?

Thanks in advance
Christoph

[former_member185603]

You can use SDK (java or .net) to build small app.

[Joe_Peters]

Can't do it in one query. To get shortcuts:

select si_name,si_parentid,si_alias_targetid from ci_infoobjects where si_kind = 'shortcut'

This will give you the name of the shortcut, the ID of the folder it's in, and the ID of the target object. To get more info on the target:

select si_name,si_parentid,si_kind from ci_infoobjects where si_id = <<id from previous query>>

This will give you the name, kind, and folder ID of the target object.

The CMS Query universe does not have native support for shortcuts (at least, as of BI4.2 SP06); if it did, it would be possible to get it all in one query using that universe.

[rajdeep_marathe]

SELECT si_id, si_name, SI_HYPERLINK_STRING FROM ci_systemobjects, Ci_appobjects, ci_infoobjects WHERE SI_KIND = 'hyperlink'

SELECT si_id, si_name, si_files FROM ci_systemobjects, Ci_appobjects, ci_infoobjects WHERE SI_KIND = 'webi'

SELECT si_id, si_name, si_files FROM ci_systemobjects, Ci_appobjects, ci_infoobjects WHERE SI_KIND = 'lumx'

check if above helps !!

Regards,
Rajdeep

[TJe]

Could not test the CMS Universe for this use case, but based on the query listed here it should be possible using two dataproviders. The second dataprovider should use the results of the first dataprovider as query filter.

If objects are missing in the universe (e.g. si_alias_targetid) you can easily add them to the universe.