The reposnse time of my report (displayed using OWC), deteriorates when i
drill down to a dimension having large number of members (60 - 70k). I have
to display this level of detail in main report (in addition to drill
through). Sometimes it takes a minute to drill down to that level. How can i
improve the response time? Any workaround?

Ali

In general, when you go ahead and that many members of a level to display,
in general it will take awhile for it to show. Saying this - there are
somethings to consider:
1. your UI application: OWC and XL rely alot on the client to go through the
data to list the values out. A web-based application (for example) could
possibly return values faster.

2. Custom Aggregations: For that particular level within that dimension of
the cube, you could instruct Analysis Services to base the aggregations at
that level thus allowing for OLAP to calculate these values faster.

3. Add another level: For example, add a "A-Z" level between the top level
and the current level you are going to.

HTH!
Denny



"Ali [Xavor]" <alishahzadbutt (AT) hotmail (DOT) com> wrote