Business Objects XI Web Intelligence how to reference a list of measures as variables in a prompt? -

the requirement present user list of measure names in 2 prompts. user selects measure name each prompt. based on user selection, actual measures mapped blocks on report. of measures counts , dollar amount sums data type specific formatting applies.

the final report gives side side comparison of 2 measures user selects.

prompt #1 targets left hand block

prompt #2 targets right hand block

each list of measure names 10 items long.

the idea 1 report can used template number of different side side comparisons 2 measures.

how reference list of measures variables in prompt?

how map user selections actual measures in data provider?

if understand correctly want give user possibility select between e.g. revenue, amount, cost, profitability, average price.

each of values represents measure in universe.

i create in universe object

[promptmeasure]= case @prompt('select measure','a',{'revenue', 'amount', 'cost',  'profitability', 'average price'}),mono, constrained,persistent)  when 'revenue' [revenue]  when 'amount' [amount]  when 'cost' [cost]  when 'profitability' [profitability]  when 'average price' [average price] end 

add object query in report. in report can use function formatnumber , apply conditional formatting dependent on value of prompt:

for example:

[formattedmeasure]=if userresponse("select measure")='profitability'  formatnumber([promptmeasure];"#,##0.0%")  else formatnumber([promptmeasure];"#,##0.00")