How to get the connection names associated with an UNX universe

[former_member204024]

Hi,

I tried the below query to get the connections names associated with an universe (unx format).  But it didn't fetched any rows for me.

SELECT si_name

FROM ci_appobjects WHERE CHILDREN("si_name='DSL.Universe-Connections'","si_id=7427")

Where am I going wrong.

Regards,

Subramanian S

[Former Member]

Hi, try this:

select si_id, si_name from ci_appobjects where parents("si_name='DSL.Universe-SecuredConnections'","si_id=7427")

[Former Member]

For Unv

SELECT si_name

FROM ci_appobjects WHERE parents("si_name='DataConnection-Universe'","si_name='eFashion'")

For Unx, try below

SELECT si_name

FROM ci_appobjects WHERE parents("si_name='DSL.Connection-DSL.Universe'","si_name='eFashion'")

Thanks,

Prithvi

[former_member204024]

Hi Prithvi,

I am using BI 4.1 SP5, in that I am unable to find a dependency rule 'DSL.Connection-DSL.Universe' in the available 160 rules.  The second query is not working for me.

Regards,

Subramanian S.

[Former Member]

Hi Subramanian,

I will need to find an environment to test the relationship queries for BI 4.1.

However, if you are using SDKs, you can also get the information as explained below

1. Query the infostore to get all the unx universes,

Select si_id,si_name,si_sl_universe_to_connections from ci_appobjects where si_kind='DSL.MetaDatafile'

2. Retrieve the connection ID from the property si_sl_universe_to_connections

3. Query the infostore again with this id

select si_name,si_kind from ci_appobjects where si_id=id from step 2.

4. si_name from above query gives you the connection name for the universes.

Thanks,

Prithvi

[former_member204024]

Hi Prithvi,

Thanks for the workaround.  I tried it.  But I have to make multiple calls for single universe, that why I posted my initial query.

Regards,

Subramanian S.

[Former Member]

Can you please share the list of dependency types you have in a text file. It might help for me to analyze. I only have a limited list with me.

Thanks,

Prithvi

[former_member204024]

Hi,

Please find the attached dependency rules.

Regards,

Subramanian S.

DependencyRule.txt.zip