User Response with BEx queries

[Former Member]

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

[amitrathi239]

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

[Former Member]

I already tried this and I seem to be getting the same results... Unfortunately. Do you believe it is something of the original formula that is causing this?

Thanks so much

[amitrathi239]

Hi

share the screenshot prompts window. want to see the prompt text.

also what is the BO version

Amit

[Former Member]

Hi Amit!

This is what I meant by Empty Value... And when I get this, my result comes out as the second screenshot attached.

Any idea what can be causing this? This does not happen for all the reports. Some other ones just get blank values or some other ones pick up the incorrect period. Is there anything in BEx or Webi I can select?

Thanks so much,

Nikki

[amitrathi239]

Hi,

check this thread.similar issue.

Amit