Why my NonEmptyCrossJoin using two tuples used to determine which
members are considered nonempty doesn't work?

I have the following situation, a cell calculated that works in the
Schedule Y and in the nonleaf members of Prod dimension. In fact, it's
just a simple example. The formula is:

Sum(NonEmptyCrossjoin(Descendants ([Prod].CurrentMember,,LEAVES),
{[Schedule].[X]}, {[Schedule].[Y]}, 1),1)

I have the values below in my fact table, I get null in
(Prod.Total,Schedule.Y)

Prod.Total Prod.A Prod.B
Schedule.X 30 10 20
Schedule.Y NULL 100 50

However, if I put just one tuple to be tested as nonempty, like

Sum(NonEmptyCrossjoin(Descendants ([Prod].CurrentMember,,LEAVES),
{[Schedule].[X]}, 1),1)
or

Sum(NonEmptyCrossjoin(Descendants ([Prod].CurrentMember,,LEAVES),
{[Schedule].[Y]}, 1),1)

I properly get (Prod.Total,Schedule.Y) = 2. According to BOL I can
define more than one tuple to determine the nonempty. So, why does it
happen?

Thanks in advance,

Vinicius Bellino

Unless there was a typo, shouldn't the expression be:

{[Schedule].[X], [Schedule].[Y]}, 1),1)

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Deepak,

I confused the last set with a tuple, so I thought that I couldn´t use
two members of the same dimension in that tuple. In fact, I found odd
when I saw your solution at the first time. But you are right, being a
set it will probably work.

Thanks,

Vinicius Bellino

Deepak Puri <deepak_puri (AT) progressive (DOT) com> wrote