Publishing BI Report to Portal.

[Former Member]

Hi All,

I need to Publish Bi reports in to Portal ( BI7 n EP6) and I created web template and passing in to EP .

<b> But EP team expecting to pass query parameters dynamically.</b>

I got this Below information from SDN Forums :

it depends on your variable type, but here is a single value mandatory command you can append at the end of a URL:

Variable Name="DISTGOP"

Variable Value="3"

&BI_COMMAND_1-BI_COMMAND_TYPE=SET_VARIABLES_STATE

&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE=DISTGOP

&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE=VARIABLE_INPUT_STRING

&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-VARIABLE_INPUT_STRING=3

How can i get this above URL Parametarization. Or is there any other Alternative.

Thanks and Regards,

santosh.

[Former Member]

If We want to Pass two Variables ,Then We need to append the URL as Follows

&BI_COMMAND_1-BI_COMMAND_TYPE=SET_VARIABLES_STATE

&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE=DISTGOP

&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE=VARIABLE_INPUT_STRING

&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_1-VARIABLE_TYPE-VARIABLE_INPUT_STRING=3

&BI_COMMAND_1-BI_COMMAND_TYPE=SET_VARIABLES_STATE

&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_2-VARIABLE=DISTGOP

&BI_COMMAND_2-VARIABLE_VALUES-VARIABLE_VALUE_2-VARIABLE_TYPE=VARIABLE_INPUT_STRING

&BI_COMMAND_1-VARIABLE_VALUES-VARIABLE_VALUE_12VARIABLE_TYPE-VARIABLE_INPUT_STRING=3