Re: How to design large dimensions in Analysis Services

#1

A dimension is NOT limited to 64k members. No member can have over 64k
children (including ALL member).

tom @ the domain below
www.tomchester.net

"GP" <geeta_pajjuri (AT) yahoo (DOT) com> wrote

Quote:

MSAS has limitaions with respect to the number of records
in a Dimension (64,000) How should I design dimensions for
example an asset dimension, where the company has more
than 64000 assets (unique assetid) and would like to drill
down by an asset number?

#2

Thanks David and Tom. I understand that no member in a
Dimension can have over 64K children, as such there can be
64K levels with 64K*64K members overall, but such a big
MOLAP dimension as an Invoice might lead to low
performance issues right as David suggested? Is it
actually adviceable to have such big dimensions? The other
option we were considering was drill through to list
invoice numbers making up the revenue figures? Is there
any other way of handling such dimensions?

Quote:

-----Original Message-----
A dimension is NOT limited to 64k members. No member can
have over 64k
children (including ALL member).

tom @ the domain below
www.tomchester.net

"GP" <geeta_pajjuri (AT) yahoo (DOT) com> wrote in message
news:473701c37618$eaa59a40$a501280a (AT) phx (DOT) gbl...

MSAS has limitaions with respect to the number of
records
in a Dimension (64,000) How should I design dimensions
for
example an asset dimension, where the company has more
than 64000 assets (unique assetid) and would like to
drill
down by an asset number?

.

#3

It depends on how big. Indeed, huge dimensions can be a problem.

tom @ the domain below
www.tomchester.net

"GP" <gepa (AT) yahoo (DOT) com> wrote

Quote:

Thanks David and Tom. I understand that no member in a
Dimension can have over 64K children, as such there can be
64K levels with 64K*64K members overall, but such a big
MOLAP dimension as an Invoice might lead to low
performance issues right as David suggested? Is it
actually adviceable to have such big dimensions? The other
option we were considering was drill through to list
invoice numbers making up the revenue figures? Is there
any other way of handling such dimensions?

-----Original Message-----
A dimension is NOT limited to 64k members. No member can
have over 64k
children (including ALL member).

tom @ the domain below
www.tomchester.net

"GP" <geeta_pajjuri (AT) yahoo (DOT) com> wrote in message
news:473701c37618$eaa59a40$a501280a (AT) phx (DOT) gbl...

MSAS has limitaions with respect to the number of
records
in a Dimension (64,000) How should I design dimensions
for
example an asset dimension, where the company has more
than 64000 assets (unique assetid) and would like to
drill
down by an asset number?

.

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

Re: How to design large dimensions in Analysis Services

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

Re: How to design large dimensions in Analysis Services - 09-08-2003 , 11:16 AM

Re: How to design large dimensions in Analysis Services - 09-08-2003 , 12:01 PM

Re: How to design large dimensions in Analysis Services - 09-08-2003 , 01:20 PM