Query Builder: Reports that source from Universe

server administration BI4.3
1

I can run the following query in Query Builder:

Select *
From CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS
Where PARENTS("SI_NAME = 'Webi-Universe'", "SI_NAME = 'eFashion'")
And SI_KIND = 'WebI' And  SI_INSTANCE = 0

This will return all of the Web Intelligence reports that point to the eFashion universe created with the Universe Design Tool (.unv).

If I change the query to find the reports that point to the converted universe into .unx, it doesn’t return anything.

Select *
From CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS
Where PARENTS("SI_NAME = 'Webi-Universe'", "SI_NAME = 'eFashion.unx'")
And SI_KIND = 'WebI' And  SI_INSTANCE = 0

Does anyone know why this would be?

I think it may be related to the SI_NAME = ‘Webi-Universe’ portion of the PARENTS statement but I can’t figure out what the correct value would be.

2

In case of unx universes you should use the ‘Document-DSL.Universe’ relationship:
Select *
From CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS
Where PARENTS(“SI_NAME = ‘Document-DSL.Universe’”, “SI_NAME = ‘eFashion.’”)
And SI_KIND = ‘WebI’ And SI_INSTANCE = 0

2 Likes
3

Thanks @Surika , that’s what I was looking for. Too many things without documentation.