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?