Add prompt to report

[Former Member]

Hello:

I want to add a prompt to a web intelligence report and then use that prompt in a formula to determine at what level the data gets rolled up. For example, if the user enters "Daily", then the formula rolls up the data into dates and then I group on that. If they enter "Monthly" then it rolls up into months.

I know I can use fields in the Edit Query window to add prompt filters, but in the case I am not filtering, I just want a value I can pass to the report.

How to do?

Thanks!

[Former Member]

Hi Blair,

If you check following post by Noel just few days ago, he has explained similar functionality with detailed screenshot:

http://scn.sap.com/thread/3327215

Hope this helps.

[arijit_das]

better to use input control. you can use a checkbox or radio button to select Daily/Monthly and according to the selection, you need to write a formula for the time dimension used in the report.

I assume, you already have Day and Month objects under time dimension which you can use in the report.

First create a variable v_Period with formula ="Daily".

Then create an input control based on this variable. In the custom list of values, add "Monthly".

Then in your report where you are using the time dimension, use the formula =if([v_Period]="Daily";[Day];[Month])

Based on the exact requirement, the formula can change. The drawback here is the all selection you can not remove the all values selection option.

[Former Member]

Hello Blair,

Without using the prompts I don't think it is possible to use the filter value to bring the data.You may consider using opendoc to pass a filter value to another sub report, but again, it will filter data in the sub report for the passed value.

Thanks,

Madhumitha