Skip to Content
avatar image
Former Member

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,

Nikki

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 15, 2015 at 06:48 PM

    Hi,

    instead of using UserResponse([Query 1];"Fiscal Year";Index)  this put the prompt text only.same for other.


    let say if prompt text is "Enter Year" then correct one is userresponse("Enter Year")

    Amit

    Add comment
    10|10000 characters needed characters exceeded