Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Need clarification on @prompt usage

Dear Team,

I have gone through most of the sites & blogs, but still i did not got the concept  of the following topics:

(1Q) I am ok with initial syntax of @prompt, But i am not clear with the exact usage of User:0, User9 and User1 concept. Plz find below

  • @Prompt(‘1) Enter Country Name’,’A’,’Country Dimension\Country Name’,multi,free,Not_Persistent,{‘USA’,’UK’,’CANADA’,’INDIA’},User0)
  • @Prompt(‘1) Enter Country Name’,’A’,’Country Dimension\Country Name’,multi,free,Not_Persistent,{‘ALL’},User:9)
  • @Prompt(‘1) Enter Country Name’,’A’,’Country Dimension\Country Name’,multi,free,Not_Persistent,,User:1)

Could u plz explain its usage?

(2Q) I have a country object at universe with different countries names like India, Usa, UK, Honkong, London, Sunderland, Pakistan, Africa,Philipians,Tykio.

Case i: when the user runs the report using prompt at report level, He should able to see only TOP five countries.

Note: Dont define five countries at universe level @prompt. How can we do the same at report level prompt?

Case ii: For the same countries object how we can  get data in alphabetical order at report level prompt > like Africa, Honkong, India,London,Pakistan, Philipians, Sunderland, Tykio, USA, UK.

(3Q) I have year & month object,

if we run report for 2014 we will getting data for month starting from Jan, Feb Mar, April, May June, July Aug Sep Oct Nov...December

But for same 2014 we want starting month should be April, May June July Aug Sep Oct Nov Dec Jan Feb Mar. How to obtain this?

(4Q) How to represent the half of the webi report data in Pie chat?

For ex:

employee     SalesRevenue  Percentage

aaa                10000                   50

bbb                 5000                    30

ccc                   2500                   10

ddd                  1250                    7

eee                  625                      3

In this case we want to represent data of ddd and eee sales reveunue with percentage? How to do this?

(5)How to dynamically change the title of the webi report with repect to report data?

Title: sales report for 'INDIA'

For eg: Page1 contain country object with India information

            Page2 contain country object with USA information

            Page3 contain country object with US information

Note: whenever we go to corresponding page the title should dynamically, for page2 it should be USA.

Thanks in advance,



Former Member
Former Member replied

This is regarding your 2nd question.

Add 'Order by' clause  in the object definition and use the same in universe and report level prompts.



1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question