please help with my webi report

[Former Member]

Hello everyone...i need help of you...i am very new to Web intelligence ...my task is ,in the report i should give one value ,when i give that value the report should multiply with that value and report should update according to it. how to do that ??

[Former Member · Accepted solution]

Hi,

Can you attach some screenshots please.... Insufficient information to go on.

[Former Member · Accepted solution]

Hi Santosh

thank you for reply...i didn't start the work yet. my task is ,there is a report already with all measures. it's banking report. i have to create a box,in the box when i give some numeric number ,the report should take that number and multiply with that number in the rows and data has to be change . how to do that? please help me.

[Former Member · Accepted solution]

Hi Ravi Kiran:

Create a new variable called "User Entered Number" with datatype as Number and value as 1.

Create an Input Control for the same, make it as Entry Field and Operator Equal to.

Create a new variable to store the multiplied value with formula in that as [Value To Be Multiplied] * [User Entered Number]

Drag this variable into the report and voila! you are done!

Santhosh Kumar Prabhakaran

Having fun with webi! - Itz all I wanted to do!

P.S. => You will need to go to Input Control to enter a different number there... your default number would be 1!

[Former Member · Accepted solution]

hello

Santosh,

thank you very much for reply. i am very very new to webi. can you please explain me more detail. i am sorry for asking you. please help me out ..thank you..

[Former Member · Accepted solution]

Hi Ravi,

In Design mode, go to Data Access, under that you will find New Variable.  Click on it and create the variable "User Entered Number"

Input control is available under Analysis tab.

To create a variable for multiplied value, you will need to once again create a New Variable.

Just explore the interface, that should help.

Regards,

Santhosh

[Former Member · Accepted solution]

Thank you

Santosh kumar.. thanks a lot