Query 1

with
member measures.mymember as
count(
nonempty(
{[Customer].[Customer].[Customer].MEMBERS} *
{[Date].[Date].[Date].MEMBERS} *
{[Product].[Product].[Product].MEMBERS} *
{[Measures].[Internet Transaction Count], [Measures].[Internet Order
Count], [Measures].[Customer Count]}
)
)
select {measures.mymember} on 0
from [Adventure Works]runs withou problem.Query 2with

member measures.mymember as
count(
nonempty(
{[Customer].[Customer].[Customer].MEMBERS} *
{[Date].[Date].[Date].MEMBERS} *
{[Product].[Product].[Product].MEMBERS} *
{[Measures].[Internet Transaction Count], [Measures].[Internet Order
Count], [Measures].[Customer Count]}
)
)

select {measures.mymember} on 0
from [Adventure Works]returns on x64 (I have only it) #Error (some thing
about UInt32.Max) Why?Query 3with

member measures.mymember as
count(
nonempty?rossjoin(
{[Customer].[Customer].[Customer].MEMBERS},
{[Date].[Date].[Date].MEMBERS},
{[Product].[Product].[Product].MEMBERS},
{[Measures].[Internet Transaction Count], [Measures].[Internet Order
Count], [Measures].[Customer Count]}
)
)

select {measures.mymember} on 0
from [Adventure Works]Query 4with

member measures.mymember as
count(
nonempty?rossjoin(
{[Customer].[Customer].[Customer].MEMBERS},
{[Date].[Date].[Date].MEMBERS},
{[Product].[Product].[Product].MEMBERS}
)
)

select {measures.mymember} on 0
from [Adventure Works]forces the AS server to take all of the RAM (8 Gb) end
gets "Out of memory".

The case of infinite recursion occured, because in query 4
currentmember on measure is measures.mymember
I don't know why AS generate no error message

Vladislav Beliaev

Hi

Let us don't repeat here our discussion from SQL.RU.


"VBeliaev" <vbeliaev (AT) mail (DOT) ru> wrote

I've repost message because not all people who read this newsgroup can
read sql.ru discussions

Vladislav Beliaev