how to select categories in BI on BI Universe

[former_member392074]

I'm trying to pull a query from the BI on BI Universe (BI 4.2 SP-03), to get categories per document.

I have a query that looks like it does this but it's blank for the categories.

Here's the query:

SELECT Properties.si_cuid, Properties.si_name, Properties.si_kind, relationships(Properties.si_documents) FROM Properties WHERE Properties.si_kind IN ( 'Webi','WebIntelligence' )

Here's the Categories:

Here's the report (with no categories):

I can't change the Universe but I can write custom code in WebI.