BusinessObjects-Infoview freezes when click on "Document List"

You can find several solutions for this dummy situation. I never tried it but IE8 users solve this by setting their zoom ratio to %100 on their browser.

But i faced this problem on IE9 and the zoom trick didn't help me. I solved it by adding "about:blank" to the trusted sites on IE. Hope this helps you too.

Tweet

BusinessObjects-Merged Dimension Incompatible Object

Merging dimension is always a need by creating webi documents. But by default you can use only dimensions from one query, merged dimensions and the measures. If you want to use dimensions from other query and you can't merge them, you got an error message "Cannot drop here - the object is incompatible". See pic below.

To avoid this problem you have to create a detail variable object and associated it to the merged dimension. In the example above you want to use the phone numbers from Query2. Select the type as "detail" and associated object.

Now you can use this variable with your Query1 dimensions.

To understand why this works with detail please refer to this document:
http://michaelwelter.wordpress.com/2011/04/18/tips-for-merging-dimensions/

Tweet

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