Skip to Content
0
Former Member
Jan 23, 2009 at 07:21 AM

Conditional logic in characteristic filtering

36 Views

Hi,

I'd like to know if it's possible to define conditional filtering criteria in a query, based on characteristics in the selection definition of a structure, without the need to code user exits. For example, the requirement may be to include all data that meets the following criteria:


( ZFUND = 'A'  AND 0COSTELMNT IN EXPENSES) OR (ZFUND NOT EQUAL 'A' AND 0COSTELMNT IN
 ASSET_COSTS)


where ZFUND and 0COSTELMNT are characteristics;
      EXPENSES and ASSET_COSTS are cost element groups

It is easy to include such selection criteria in SQL or MDX. However, the BEx Query Designer only seems to support simple selections based on inclusions and exclusions of characteristic values.

Any suggestions for meeting this requirement?

Thanks,

Mustafa.