472,794 Members | 2,215 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,794 software developers and data experts.

HELP: OLAP data cube in web browser loads slow or errors!


I am using the OLAP data cube in a web browser (using the code from
the SQL 2000 toolkit). The OLAP services is on database server and the
web interface is on the web server. If we do simple queries on the
cube, it works fine. When we do complex queries the cube in the web
browser loads very slow or errors. Also, I noticed that when it is
building the output for the cube (the display) that most of the
processing is taking place on the web server and not the database
server. Our database server is a much faster machine with 8 processors
(our web server has only one processor).

Besides moving the web interface of the data cube to the faster
database server or adding more processors to the web server, is there
anything that I can do to improve the performance of the cube, so that
complex results load quicker and do not error out?


Jul 20 '05 #1
0 3061

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: DD | last post by:
Hi Guys! Just would like to share with you my experiense in this matter. I was trying to evaluate how suitable Oracle OLAP for our applications. As probably you did, I have downloaded from OTN...
by: Philip Stoev | last post by:
Hi all, Please tell me if any of this makes sense. Any pointers to relevant projects/articles will be much appreciated. Philip Stoev http://www.stoev.org/pivot/manifest.htm ...
by: Devin McMahon | last post by:
I cannot seem to find a group where this question would fit so I am posting it here. I have what I believe is a unique situation. I am using SQL Server Analysis Server to build a cube of...
by: Pradeep | last post by:
I have created a crystal report connecting an OLAP cube .But once i try to view a report it took around 15 minutes and finaly gave an error like "cannot retrieve data from cube".I want to know why...
by: Moco | last post by:
Well I installed my first OLAP Server ever just yesterday, allright. I built my first cube with a data source from a MSSQL Server 2000 on the same machine, allright. I browsed the cube with...
by: mrwoopey | last post by:
Hi, Instead of using the Japanese version of the OLAP control for vs.net there is now an English version: Visual Studio .NET Web Control for Business Intelligence - ...
by: Naeem | last post by:
I am working in SQL Server OLAP Services 7.0. I have stored the monthwise data in separate table for each month. All tables have same columns. Is it possible to build a cube on these multiple...
by: Joel Leong | last post by:
I use C# to invoke DTS. The DTS run successfully if no process cube function in it. But after i add process cube function, the ASP.NET page hang. I even impersonate ASP.NET to an account with...
by: =?Utf-8?B?TWFyaw==?= | last post by:
Hi - Is is possible to connect to a data source that is an OLAP Cube? If so what are the steps that are needed to "Add New Data Source"? Thank you, Mark
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
by: lllomh | last post by:
How does React native implement an English player?
by: Mushico | last post by:
How to calculate date of retirement from date of birth

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.