How to use LOV on a derived table dependent on a prompt for Webi web intelligence view.

[Former Member]

The semantic layer has not created a defined LOV for the derived table.   This only happens when pulling columns from derived table which depends on a prompt for unique selection.  When pulling from derived table that does not depend on a date prompt does not have an issue in Webi.

I don't know if this is a universe design issue or WEBI.

Webi Rich internet application   selects the date prompt first but if click on Storeno in List it returns a LOV with auto refresh.

Webi Web Intelligence returns  List of Values for current prompt requires values for following prompts:   and when you click to refresh  webi responds with 'undefined'

[former_member4998]

Hi…

Can you check Prompt : Store No is created at universe level and defined the syntax correctly

@Prompt(1,2,3,4,5)  insert a prompts in SQL. When the user runs the query, the user is prompted to enter a value for a refresh each time.

1 = 'Prompt Text Message'

2 = 'Prompt Type'  (i.e. A,N,D,U)

where A= Character, N= Number, D= Date, U= Unit.

3 = 'Class Name/ Object Name'

4 = 'Multi/ Mono'

Multi means Multiple ( Example = 2004,2005,2011)

Mono means Single ( Example = 2012)

5 = Free/Constrain (Type value or select value in LOV/ Select Value)

Example for creating a @prompt filter is below

@Prompt('enter year','A','time period/year', Multi', Free)

Pointer to a “List of Values” from an existing universe object. You invoke the target list of values by double-clicking on the object contain ing the list of values that you want to use in the "Classes and Objects" panel. This gives the Class name and the Object name, separate ed by a backslash. It must be enclosed in single quotes. For example: 'Client\Country'. When you are using “Index Awareness”, and you want to return the key values for an object,set the 5th value to primary_key

• Hard-coded list of single values or value pairs. The values in a pair are separated by a colon. Each value is enclosed in single quotes. The pairs of values are separated by a comma. The whole list is enclosed in curly brackets. Set the constraint to primary_key

http://www.businessobjectstips.com/tips/web-intelligence/prompt-functions-the-next-step-optional-pro...