BI query-- creation

[Former Member]

Hi Experts,

I don't know where will write the BI query(create,update,delete) and how to activate to our system()

Regards,

P.Manivannan

[Former Member]

Hi,

you can create the queries with BEx Query Designer (this is a BI frontend tool).

For using the queries in VC you have to create a portal system. I have described how to do this in one of my weblogs:

<a href="/people/marcel.salein/blog/2007/03/14/how-to-create-a-portal-system-for-using-it-in-visual-composer:///people/marcel.salein/blog/2007/03/14/how-to-create-a-portal-system-for-using-it-in-visual-composer

Best Regards,

Marcel

[Former Member]

solved

[Former Member]

The BI query is created/updated/deleted in the B.I 7.0 system not in Portal.

And if "activate to our system()" is referring to getting the data in VC, once the query is published, a portal system created, SSO established, you will be able to see your system in the Models section.

Hope this helped you.