on 08-05-2015 9:47 AM
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
Hi, try this:
select si_id, si_name from ci_appobjects where parents("si_name='DSL.Universe-SecuredConnections'","si_id=7427")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.