Skip to Content

how to select categories in BI on BI Universe

Nov 10, 2017 at 02:45 PM


avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers