How to make drillthrough more efficient?
From: Deepak (anonymous_at_discussions.microsoft.com)
Date: 05/06/04
- Next message: Learner: "Re: Question for Nigel and other experts: Regarding OLAP front-end tools"
- Previous message: Deepak: "Filter and Tail"
- In reply to: Aymer: "How to make drillthrough more efficient?"
- Next in thread: Michael Vardinghus: "Re: How to make drillthrough more efficient?"
- Reply: Michael Vardinghus: "Re: How to make drillthrough more efficient?"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 5 May 2004 20:26:45 -0700
You have to optimize the indexing of the underlying
relational tables on which the cube is built, because
drillthrough issues a SQL query to the data source. You
can capture this query and use it to optimize indexing.
But common-sense indexing will often improve drill-through
performance dramatically. For example, ensure that the
cube fact table is indexed on columns that are specified
in the drill-through query (date is a common case).
>-----Original Message-----
>Scenario: I have SQL Server 2000 with Analysis Server.
In Analysis Server I have several cubes. In one cube, I
have drilthrough enabled. With that cube, I am able to
browse the data and drillthrough to the source.
>
>Problem: However the process of drillthrough is not
consistent. Sometimes it works and sometimes it doesn't.
When it doesn't work, I get the error: "Unable to drill
through. The operation requested failed due to timeout."
I have read high and low to find out what is wrong. The
problem is that Analysis Service allows 15 secodns to
connect to the query. With service pack 1 installed, the
time limit goes up to 30 seconds. This is a know
limitation to Analysis Server. The solution to problem is
to optimize analysis server.
>
>Question: How can I optimize Analysis Server so that
drillthrough becomes consistent and reliable?
>
>Any help or clue would be appreciated,
>aymer
>aymerb1980[@]hotmail.com
>.
>
- Next message: Learner: "Re: Question for Nigel and other experts: Regarding OLAP front-end tools"
- Previous message: Deepak: "Filter and Tail"
- In reply to: Aymer: "How to make drillthrough more efficient?"
- Next in thread: Michael Vardinghus: "Re: How to make drillthrough more efficient?"
- Reply: Michael Vardinghus: "Re: How to make drillthrough more efficient?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
