Variable input in Webi Report

[former_member553124]

Hello Experts,

I have a requirement to create a Webi report which has 3 key figure columns.

While executing report It should ask for input variable fiscal year/period.

Now 1st key figure colum should show Amount for the fiscal year/period I entered as an input variable.

2nd column should show Amount for previous YTD for the fiscal year I entered.

For Ex. if I enter 04.2009 it should show amount for 01.2009 - 04.2009 and if I enter 04.2008 then it should show amount for 01.2008-04.2008.(based on the variable input I provide)

3rd column should provide the Amount <= ficsal period I enter as an input.

Can anyone guide how would I achieve this?

Regards,

Nirav Shah

[Former Member]

Hi Nirav,

How did you solve your problem could you please let me know as I have the same problem

Regards

[former_member553124]

Hi,

Yes, UserResponse function will work for this. we just have to get input from user response.

Regards,

Nirav Shah

[former_member142702]

Hi Nirav,

what is the granularity of the time dimension of your data in your report? Generally you make sure that you fetch all required in your report and then use formulas (applying the if operator on the time field of your data and the value returned from your prompt) to calculate the desired key figures.

Regards,

Stratos

[former_member553124]

Hi Stratos,

My requirement is to get value of input variable and use it to calculate YTD and <=Variable entered.

Can we apply the formulas on the variable values you enter while executing report?

Regards,

Nirav Shah

[former_member142702]

Hi,

yes. Try using the UserResponse function in a WebI formula.

Regards,

Stratos