Skip to Content
0
Former Member
Dec 02, 2009 at 03:43 PM

Apply filter on Class gives database error

30 Views

Hi ,

We are on BO XI 3.2.1 (SP2 fixpack 2.1).

In most of our reports we have to use the designer feature "Apply filter on Class" for a mandatory variable of bex query as we need the prompt to be applied only in few of our reports based on a particular universe.

And this filter(prompt) can't be applied explicitly at BO level as it is a currency variable (currency conversion) which has to come from bex query only.

Here the problem we are facing is,

Reports which doesn't contain any object from that currency class doesn't prompt for currency input ,which is correct, but gives database error saying "failed to execute the query with the error. Specify a value for varible currency"

What is working is,

Reports which contain atleast one object from that currency class, prompts for currency input ,which is correct and refreshes properly.

Please Help.

Regards.

Naresh Nookala