Grouping level in 2005.

#1

Hi,

Could anybody tell us if the having of a hidden grouping level in a large
dimension (more the 100K elements) make a sence for performance?

Vladimir Chtepa

#2

Creating a level from grouping attribute and then hiding it looks a bit
strange.
Groping level is there to facilitate browsing of large levels. Any reason
you would like to hide it?

In general hiding a level should have little impact on performance from the
server stand point.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

"Vladimir Chtepa" <vc.nospam (AT) diacom-systemhaus (DOT) nospam.de> wrote

Quote:

Hi,

Could anybody tell us if the having of a hidden grouping level in a large
dimension (more the 100K elements) make a sence for performance?

Vladimir Chtepa

#3

Hi Edward,

I have migrated from AS2K cube. I should so there because of 64K border.
Yet in AS2K5 I have a dilemma, to delete or not delete that level.

Vladimir

"Edward Melomed [MSFT]" <edwardm (AT) norely (DOT) micrsoft.com> schrieb im Newsbeitrag
news:uVICzV0NGHA.3864 (AT) TK2MSFTNGP10 (DOT) phx.gbl...

Quote:

Creating a level from grouping attribute and then hiding it looks a bit
strange.
Groping level is there to facilitate browsing of large levels. Any reason
you would like to hide it?

In general hiding a level should have little impact on performance from
the server stand point.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

"Vladimir Chtepa" <vc.nospam (AT) diacom-systemhaus (DOT) nospam.de> wrote in message
news:%23E655YuNGHA.740 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
Hi,

Could anybody tell us if the having of a hidden grouping level in a large
dimension (more the 100K elements) make a sence for performance?

Vladimir Chtepa

#4

If you are not using Grouping level for browsing, it makes sense you delete
it.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

"Vladimir Chtepa" <vc.nospam (AT) diacom-systemhaus (DOT) nospam.de> wrote

Quote:

Hi Edward,

I have migrated from AS2K cube. I should so there because of 64K border.
Yet in AS2K5 I have a dilemma, to delete or not delete that level.

Vladimir

"Edward Melomed [MSFT]" <edwardm (AT) norely (DOT) micrsoft.com> schrieb im
Newsbeitrag news:uVICzV0NGHA.3864 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
Creating a level from grouping attribute and then hiding it looks a bit
strange.
Groping level is there to facilitate browsing of large levels. Any
reason you would like to hide it?

In general hiding a level should have little impact on performance from
the server stand point.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no
rights

"Vladimir Chtepa" <vc.nospam (AT) diacom-systemhaus (DOT) nospam.de> wrote in
message news:%23E655YuNGHA.740 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
Hi,

Could anybody tell us if the having of a hidden grouping level in a
large dimension (more the 100K elements) make a sence for performance?

Vladimir Chtepa

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

Grouping level in 2005.

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

Grouping level in 2005. - 02-21-2006 , 06:56 AM

Re: Grouping level in 2005. - 02-21-2006 , 06:18 PM

Re: Grouping level in 2005. - 02-22-2006 , 02:56 AM

Re: Grouping level in 2005. - 02-23-2006 , 12:50 AM