Condition behavior in BeX analyzer with LEAF function

[former_member192763]

Hi,

I have a calculated KEY figure ('detail') in a BeX Query, with a formula like the following one:

LEAF( 'KF1') + LEAF('KF2')+LEAF('KF3')

In the query, there is a hierarchy characteristic; in the following columns there are more drill-down characteristic.

The value of 'detail' is zero for rows corresponding to hierarchy nodes, is 1 or more on rows corresponding to the characteristic final node in the hierarchy.

We need to display the detail rows only for leaf nodes, leaving only totals for the hierarchy nodes. This is easy to achieve creating a local condition in the workbook, with a selection " 'detail' > 0 ".

If I create the same condition as a predefined condition in the query, the result is not what expected: all the rows in the workbook are hidden, except the final total. Deactivating the query condition, and recreating a local condition, with the same criteria, works fine.

I have double checked that both the query condition and the local one have the same (easy...) criteria.

Can you suggest a reason for this behavior?

Thanks,

Massimo

______________________

BI Add On 7.x

Support Package 1, Patch 1

Revision 642

[Former Member]

Yes Coletti, there's a data fxn called NOT LEAF. Please refer this http://goo.gl/wf0mE Thanks, AB