dbTalk Databases Forums  

performance with owc and large dimensions

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


Discuss performance with owc and large dimensions in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
jerome
 
Posts: n/a

Default performance with owc and large dimensions - 01-13-2005 , 04:03 AM






Hi,

I've a large customer dimension with levels:
type 4 members (unique keys/names)
customer 150' members (unique keys/names)

I'm planning to impement one or two dummy levels (not
unique level keys/names):
name first char 130 members and/or
name first 2 chars 1300 members

This is for not exceed the 64'-members limit and speed up
drilling from type to customer.

Have anyone tried this with OWC clients ? One or two dummy
levels ? Effects on client drilling time, cube-size etc ?

/Jerome


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.