User Response with BEx queries
Hello webi gurus!
I am facing an issue with my webi reports with what seems a standard webi formula. I am using the UserResponse formula for the 2 prompts coming from BEx. These prompts for Fiscal Year and Period are variables that read the current year and period. Sometimes the reports work and they pick up the user responses but some other times they dont, even though I use the same formula. Usually, when they don't, the prompt box shows things like <Empty_Value> and even when I enter year and period, it still doesn't work in the report.
Do you believe that the formula is incorrect? Or is it something that seems incompatible between BEx and Webi for User Response? It may also be relevant to note that I often have many queries as data providers (albeit the same BEx queries).
="FY" + UserResponse([Query 1];"Fiscal Year";Index) + " - Period 0" + UserResponse([Query 1];"Posting Period"; Index)
Any help or guidance would be greatly appreciated,