Hi

I am using Crystal Analysis Pro as my front end. When eliminating null values from a result set, it uses the NonEmptyCrossJoin function. I have a report where I need to create calculated members and include them with members from another dimension that are mostly null because they don't apply to the location for which I am creating the report

The problem is that the NonEmptyCrossJoin function causes the result set to be empty since it eliminates calculated members. I get a result set when I use the crossjoin function and the NON EMPTY keywords in the Select Clause, but CAP is all or nothing with NonEmptyCrossJoin it either uses it everywhere or nowhere and uses NON EMPTY instead. It is controlled by a registry switch

I was wondering if anyone has come up with a work around for this that does not require converting the calculated members into fields in the underlying data.

On the rows

[Src Customer].[All Src Customer].Children (This dimension contains a lot of members, only a few of which are applicable to location XXX

Aggregate({[Dest Book Container].[Contnr Terminal Name].&[XXX].&[IT], [Dest Book Container].[Contnr Terminal Name].&[XXX].&[TK]}

Aggregate(Except([Src Book Container].[Contnr Terminal Name].&[XXX].Children, {[Src Book Container].[Contnr Terminal Name].&[XXX].&[IT], [Src Book Container].[Contnr Terminal Name].&[XXX].&[TK]} )

On the Columns

Year and month


Thanks
Asa Monsey

Hi Asa,

I learned you encountered problems with NonEmptyCrossJoin function /
Crossjoin function and the NON EMPTY keywords when you use Crystal Analysis
Pro as the front end. According to you description, it seems this problem
is related with Crystal Analysis Pro. Because Crystal Analysis Pro is not
the product of Microsoft, I am not familiar with Crystal Analysis. I found
the following URL for your reference.

http://www.crmsoftwares.com/mainsupser.html
http://www.crmsoftwares.com/mainsupser.html

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Hi Asa,

Thank you for taking time to write in your experience so that it may help
other customers who may encounter similar issues.

Thanks & Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.