Inbuilt Function

[Former Member]

Hi Experts,

I have a universe on SAP BW Bex Query, I have a Dimension "Tracking Number" Defined as

[ZTRCK_NUM].[LEVEL01]

in Select clause.

I need to create a new Object in Universe Designer which gives count of "Tracking Number"; I am not sure how to use the inbuilt function which is defined as below:

COUNT(,)

COUNT("Set"[, EXCLUDEEMPTY | INCLUDEEMPTY] ) count number of cells in a set, optionally including or excluding empty cells

Your help is highly appreciated.

-Thanks,

DEEPU

[marc_daniau · Accepted solution]

If you have a simple characteristic with Level0 and Level1 you can count the members using this syntax

<EXPRESSION>Count([ZTRCK_NUM].[All].Children, excludeempty)</EXPRESSION>