Report using BICS connection only allows default values in prompts from SAP Exit
I have a BOBJ report built off a standard BEx query that has several prompts where the variables use SAP exits to pre-fill the prompt values. One of these is "Controlling Area" and another is "Fiscal Year/Period" and lastly "Access Method" which allows the user to choose replicated data in a cube or direct access via a virtual cube. When I run the BEx query I can change the values from these pre-filled defaults without issue by selecting from a list of all possible values. Previously I could do the same in the BOBJ report but now when I run the report the only options I have to select from are the pre-filled defaults from the SAP exit. I've tried purging the data and prompt values in the report and creating a new report off the same BEx query but get the same results. I'm not sure if this is related to the patch version of BOBJ (4.1 SP4 P2) or BW (7.4 SP9)? We recently went from SP8 to SP9 in BW but I haven't read anything about this being an issue in SP9.
Edit: added a picture showing the comparison between the available BEx prompt values and BOBJ prompt values for Controlling Area.