BuisnessObjects-Order Prompts in Web Intelligence

If you use prompts which you have defined in your universe, you can't order them through Query panel in your web intelligence document.

To order your prompts you have to use the {user:n} parameter in your filter definition. n is the order number of the prompt and starts from 0.

Here is an example:

On the query panel you see that the order of the prompts is ProductNumber, ProductName, ProductId.

After running the query you will see that the prompt order is like ProductId, ProductName, ProductNumber.

Take a look to the SQL script and you can see the definition of the prompts. They are like;

   ( SalesLT.Product.ProductNumber  IN  @Prompt('Enter values for Productnumber:','A','Productheader\Productnumber',Multi,Free,Persistent,,User:2)  )
   AND
   ( SalesLT.Product.Name  IN  @Prompt('Enter values for Product Name:','A','Productheader\Product Name',Multi,Free,Persistent,,User:1)  )
   AND
   ( SalesLT.Product.ProductID  IN  @Prompt('Enter values for Productid:','N','Productheader\Productid',Multi,Free,Persistent,,User:0)  )

So, all you have to do is change the numbers of the end of your prompts.

Tip: If you parse your filter in universe you will get an error message like this:

 Just ignore it.

Tweet

BusinessObjects-Webi Ignores Prompt

Today i faced a new property(!) of BI4. I create a query. Put my dimensions and my prompts. After running the query i saw that my query returns result which schould filter after my prompt.

I checked the SQL script and there it is. The query stays without the prompt. See the picture below.

As you seen on the screenshot, i have two prompts but the script shows me only one of them. After a little search i found that the properties are different of the dimensions.

Aftermath: Webi prompt doesn't support "Hierarchical Display" dimensions.

Tweet