Skip to Content
author's profile photo Former Member
Former Member

List of Values in Desktop Intelligence

Hi,

I have to create a report which does not have a Universe as a back-end. The Query uses Free Hand SQL to generate the reports. The user is requesting for a prompt with list of values(LOV) to be displayed.

However, LOV can can be displayed only if an object is created for which universe is mandatory.

I tried creating an object in Free-hand SQL but it didn't work... Is there any way I can provide a prompt with the LOV?

Regards,

Karthik Mohan

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 11, 2008 at 08:56 PM

    You can use the parameters for the @prompt to require that the user select from a list of values:

    @prompt('Enter User ID number:', 'a', {'113', '144', '114', '115'}, multi, constrained)

    the above will allow for multiple selection of values, and require the user to pick from the list.

    there should be more details about the syntax in the user guides.

    hope that helps!

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Karthik,

      You can use a workaround to achieve this if you already have a Data Provider with a Date Prompt.

      For E.g.

      Step-1: Create a report with a prompt on start_date as 'Enter Date:' and Run the report.

      You will see the LOVs for this prompt.

      Step-2: Create a second Data Provider using Free Hand SQL with the desired prompt in the WHERE clause as

      trunc(Table_Name.Column_Name) <= @variable('Enter Date:')

      This prompt will take the LOVs of the prompt of the first Data provider.

      Test this. It worked for me in BO 6.5.4. You can test the results and let me know if it works for you as well.

      Thanks / Regards,

      Bharat Ahuja.

  • author's profile photo Former Member
    Former Member
    Posted on Nov 23, 2011 at 05:39 AM

    This can be done by using adding Universe as the first data provider and use the same prompts name and add the master data which you are using for LOV and then add the Free Hand SQL.

    The sequence of data provider is very important. Thefirst data provider should be universe.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 18, 2012 at 10:13 AM

    Hi,

    If LOV's are few then define them as default values in prompt definition itself or else try with user defined objects.

    Cheers,

    Suresh A.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.