Sub query not available in info view

Hello I am using BOBJ XI 3.0 and SAP BW. I am trying to familiar myself with the functionality of WEBBI in XI as im from a 6.5 and full client background.

I understand that sub queries can now be used in WEBBI, however it is disabled (greyed out) to I have to activate this functionality in the CMC if so how, or do I have to do something else to activate it.

Thank you in advance


rlbourne (BOB member since 2009-07-22)

By default, sub queries are turned off against an SAP BW universe.

You can turn this on by going to File / Parameters from the menu, and select the SQL tab of the Universe Parameters dialogue. You can enable the sub query option there.

I have tried sub queries on a BW universe but haven’t got them to work…let me know how it goes.


SteveBickerton :canada: (BOB member since 2002-08-15)

Thank you for your reply. Within the cmc I cannot find file/parameters. Were can I find it.


rlbourne (BOB member since 2009-07-22)

sorry, you need to do this in universe designer itself.


SteveBickerton :canada: (BOB member since 2002-08-15)

wicked thank you I will let you how I get on.


rlbourne (BOB member since 2009-07-22)