dbTalk Databases Forums  

slow loading bip views

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


Discuss slow loading bip views in the microsoft.public.sqlserver.olap forum.



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

Default slow loading bip views - 08-22-2005 , 02:16 AM






hi,
we have a datawarehouse on a 8 GB RAM Server. On the cllient side, bip views
are used to access the cubes on the server. Views accessing data from one
particular cube return data to the client within a minute. For another cube,
this time goes up to about an hour. We also found out that the fast loading
views transfer about an MB of data while the slow loading ones transfer in
access of 100 MB.

Are there some configuration values, cube properties to fix that will
address this problem.

thanks in advance,




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.