BI 4.1 upgrade

[jino_jose]

Hi ,

We have done an in place upgrade from  BI 4.0 SP2  to BI 4.1 SP5, we are  facing below issue on Webi.

In the existing webi report, the mandatory prompts from Bex are populated with values are disabled using the set variable option on Webi query panel.

After migration, if we go to the set variable option, The option “use bex query defined default values at run time” is ticked & Set as prompt is ticked for all the variables, including the one which is disabled on BI4.0.

The set variable are not hidden on the initial refresh, but the subsequent refresh the set variable got hidden. I understand this is due to the difference on the workflow followed for the  Bex -> Webi between 4.0 & 4.1. The first refresh creates the transient universe then the set variables are enabled. It looks like we need to open up each report refresh and save so that the trasient unvierse will be created.

Is there any option/tool to update the Webi document metadata in one shot along with the upgrade from 4.0 to 4.1.

Thanks

Jino.

[Former Member]

Hi Jino,

I have the same issue, in WEbi Report based on Bex query I have some variables set as prompt and other no but with some default value, after promotion to BI 4.1 SP 5 all bex variables are set as primpt and the option use bex query defined default values at run time” is ticked. How do you resolved?

Thanks in advance.

Laura

[jino_jose]

Hi Laura,

We couldn't find any option to fix this automatically. we have edited the set variables on the document manually and saved the document.

Thanks,

Jino.

[Former Member]

Hi Jino,

Thanks for the reply, we have also modified the settings manually in all reports.

Thanks,

Laura