Skip to Content
0
Former Member
Feb 12, 2009 at 09:15 AM

Using pre-query with 2 characteristics in rows?

24 Views

Hi @all,

I need your help regarding the following problem:

There are multiple conditions in one query, I'd like to do in a certain sequence.

Because these multiple conditions in BEx where processed as "AND", for example

companies must be part of the Top x and an key-figure of these have to be more than y.

As a result, we have the top x companies reduced by these companies that doesn't match the key-figure condition. So there were less than x companies.

That's why we decided to use pre-queries. Because the key-figure is a ratio of the company on a higher level that is "restricted" by a condition, we need two characteristics in rows. That seems to cause some strange results in the main query wherein not all companies where submitted.

Does anyone know some workaround or any approach for this problem? Please let me know every idea.

Or do you know another way to set a certain sequence of conditions?

Many thanks for your help.

Tobias