Passing parameters to BI Query from VC

[Former Member]

Hi

I would like to know if there any way to pass parameters to BI query based on pages and roles selected by user in portal.

Thanks

[former_member206397 · Accepted solution]

Hi,

You can interact with BI from VC three ways

1. BI Integration Wizard ( BI -> BI Integration Wizard) , where you can select the Query template -> Cube -> Design Layout -> Define Filter. But you can not write query.

2. Using RFC/BAPI from BI system. Within the Custom RFC you can write Query.

Within the query you can set variable whose value will set at runtime from the

input of custom RFC. The you can Use that RFC in VC.

3. Creating Web Service from your Custom RFC and use it in VC. But for both the

cases (2 and 3) you need to define the system configuration in portal.

Now it is up to you. Which option you will take. If you have any question please let me know.

Thanks

Chandan

[Former Member · Accepted solution]

Can you briefly explain how to use 2nd option ie RFC to BI system?