Re: MDX Distinct Sum

#1

Hi Sean,

Thanks for the info re the grouping. Have done that and it
seems to work ok.

Regards,

Simon.

Quote:

-----Original Message-----
A dimension with 100,000 members is not a problem at
all. You'll just need
to create some intermediate levels for it or use the
automatic grouping
functionality. The limitation is that no single member
can have more than
64,000 children.

Sean

--
Sean Boon
SQL Server BI Product Unit

**This posting is provided AS IS, with no warranties, and
confers no
rights.**
"Simon Jackson" <simon.jackson (AT) alexismedical (DOT) co.uk> wrote
in message
news:0e9601c34629$d66bfa70$a301280a (AT) phx (DOT) gbl...
Hello,

We have created a cube using Analysis Server 2000 and
need
to create a measure that calculates a distinct sum. As
this is not one of the built in aggregate functions I am
guessing that we will need to use MDX to calculate this.
Has anyone else encountered this problem before?

Having given it some consideration my initial thoughts
would be to create a dimension containing a distinct
list
of fact items to use as the basis of the sum, however
this
would mean creating a dimension with over a hundred
thousand members which I think is impossible (the
documented maximum members per group is 64,000).

Any ideas would be gratefully received.

Thanks in advance,

Simon.

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: MDX Distinct Sum

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: MDX Distinct Sum - 07-11-2003 , 04:35 AM