Hi,

I'm getting a different result set back for a particular query which slices
on an extremely simple calculated member (the calc. member is just defined as
the All member for one of my dimensions). The query uses NON EMPTY on the
rows returned, and when run without a NON_EMPTY_BEHAVIOR hint on the calc.
member, it returns 10 rows. When run with a hint (NON_EMPTY_BEHAVIOR={} even
works for this), it returns 20 rows.

I've determined from the subject matter database that 20 rows is correct.
Anyone else have any experience with this problem, or know why I might be
experiencing it?

Thanks,

Will.

Note - am using Analysis Services 2005.

"Will Alber" wrote:

Hi Will,

Could you reproduce this behavior in a sample Adventure Works query?


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Hi Deepak, thanks for you response.

I've thus far been unable to reproduce a similar problem against the
Adventure Works cube. Further investigation by a colleague has brought up
the possibility that this may well only manifest itself if multiple
attributes and/or hierarchies from the same dimension are used to specify the
view.

Some sample MDX that repro's the problem against our cube is given below.
With the calculation in the slice commented out, we get 105 rows returned,
when it is used, we get 65. Note that the [Is Live In Link] and [Carrier
Type] attribute hierarchies are part of the [Container Load] dimension that
the calculation is performed on. I appreciate that the query, without a
cube, is of little use, but am hoping that it might 'ring-a-bell' as it were.

WITH MEMBER [Container Load].[Container Load Status].[AllOfEm] AS [Container
Load].[Container Load Status].[All]
SELECT
{[Container Load Count]} ON COLUMNS,
NON EMPTY
{[Trade].[EAST_AFRICA] * [Is Live In Link].[All].Children * [Carrier
Type].[All].Children * [Container Number].[All].Children} ON ROWS
FROM
DW_SM
WHERE
(
[Voyage Date].[August, 2006],
[Booking Type].[Import Booking]
,[Container Load].[Container Load Status].[AllOfEm]
)

"Deepak Puri" wrote: