list of values in prompt

building semantic layer
1

Hi
i have a pre defined filter like:

TABLE.A=@PROMPT(…)
IF I USE @SELECT(CLASS\OBJECT)
I GET INVALI DEFFENITION WHEN PARESING
WITHOUT IT THIS WORKS

WHY ?

eyalb (BOB member since 2009-08-13)

2

Where are you using the @SELECT function?

vinod_menon :india: (BOB member since 2007-04-09)

3

=@PROMPT(‘AAA’,‘N’,@select(class\object),multi,free)

eyalb (BOB member since 2009-08-13)

4

The @SELECT gives you a select on the column to which the object in your @SELECT is mapped. The third argument in the @PROMPT should ideally give you the LOVs (distinct) of the column to which the @PROMPT restriction is being applied. No reason why you should use the @SELECT inside the @PROMPT syntax. Just use the class name/object name format.

vinod_menon :india: (BOB member since 2007-04-09)

5

So the correct snytax would be:

Allowing to select ONE value (alphanumeric):

TableName.ColumnName =@PROMPT('Prompt Text', 'A', class\object, MONO, free)

Or allowing to select multiple values (alphanumeric)

TableName.ColumnName IN @PROMPT('Prompt Text', 'A', class\object, MULTI, free)

I kindly suggest you read up on the help text of the @PROMPT function :wink:

Andreas :de: (BOB member since 2002-06-20)

6

can i use the input of the prompt in self join to decide which join i want to use ?

eyalb (BOB member since 2009-08-13)

7

You mean like to select which context path you want to use?

The answer is no.

When the SQL generator kicks off, it first has to select the proper query path. Contexts and Aggregate Aware objects are both elements that are used to determine which path will be used. From that point, any prompts in the selected joins are evaluated. So by the time you get to the prompt interaction the path has already been determined.

Dave Rathbun :us: (BOB member since 2002-06-06)