Bex varibale change errors out on Webi side
I have a Webi report running on a Bex report universe. I needed to change a variable on the Bex and after I did that I refreshe the structure on the universe and exported it. But when I run the Webi now I am getting an error as below
A database error occured. The database error text is: The supplied XML is not valid. [ZVAR1].[CAPTION]. (WIS 10901)
Obviously the Webi is still calling the old variable which is ZVAR1, however the new one I created is ZVAR2.
I am probably missing something. Culd anyone list out what steps should be followed after changing a variable in Bex?
I appreciate any help.