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.