Ranking based on a prompt

[system]

I had been searching to find out the answer for
Ranking based on a prompt and i couldn’t find out.
Finally i found out the answer .
So i thought to give it to everybody…

In designer
Go to condition
Create a prompt
In where clause
Make a new prompt
Eg:0<@prompt(‘enter number’,’N’,{‘1’,’2’,’3’,’4’},MONO,CONSTRAINED)
From tables button select any table.

Create ranking variable
Eg:
Variable Name= v_rank
Rank(, )

In Deski

Create a variable for user prompt.

Eg:
Variable name=v_user response
Formula=UserResponse (“Query 1 with eFashion” , “Enter Number”)

Then select a column in the table
Go to Format>>
Filter
Select Table
Click Add button
From the objects select State
Click on Define Button
Write the formula= <v_rank><=ToNumber(<v_ user response>)
Then edit the v_rank variable
Variable Name= v_rank
Max(Rank(, ))

---

DoSTh (BOB member since 2007-05-31)

[system]

This looks great !! How can this be done in WEBI .

Shan

---

Shan Joseph (BOB member since 2008-04-20)

[system]

Hi Shan,
Try this.

Create a universe level prompt as above.
In the webi report .
Create a variable for user response.
Example v_user_response.

Then create another variable
as follows…
=If(Rank([measure];[dimension])<=ToNumber([v_user_response]);Rank([measure];[dimension);0)

Then drag this variable into the filter pane and give not equal to 0.

---

DoSTh (BOB member since 2007-05-31)