BusinessObjects Board

Need prompt based on or

building semantic layer
#1

Hi All,

I have to create new report as per following requirement.
for this report we need following prompts

  1. Prompt for Fund Name
  2. Prompt for Fund Type
  3. Prompt for no.of rows they want to display(Numeric Prompt )
  4. Prompt for date range
    Date selections: Weekly, Monthly, Quarterly, Yearly or Hourly

My issue is with 4th prompt
users want to enter week range or month range or quarter range or year range or Hours range.

how to achieve this?

I really appreciate your valuable Suggestions.

Thanks in advance

Regards,
Praveen.S

praveen557 (BOB member since 2008-05-07)

#2

If you are on XI 3.1 version and need this for webI reports then look into the optional prompts option in webI query panel
Or simulate the above feature in the universe by setting the ‘All’ option for all the 4 prompts (for week,month, quarter,year,Hours) which should allow you to enter a range for any one range while selecting all values for others

.

haider :es: (BOB member since 2005-07-18)

#3

Hi haider,

Thanks for your reply.

I am using XI R2.

how can achieve this in XI R2?

Please let me know.

Thanks,
Praveen.S

praveen557 (BOB member since 2008-05-07)

#4

Check the syntax for ALL from forum FAQ

.

haider :es: (BOB member since 2005-07-18)