Drillthrough on large Attribute Hierarchy

[JPO]

Hi there,

We were usign the drillthrough example from the OWC toolpack, but recently
we have been trying to migrate to 2005.

We have a customer hierarchy which is a natural hierarchy, made up of eight
levels (the bottom attribute hierarchy has 1m+ members).

Using some asp code we are able to provide a search facility so that a user
is able to disaply a single member from the lowest level in the cusotmer
hierarchy. We tried using the Natural Hierarchy, but the MDX generated by OWC
was so inefficient it would take approx 1-mins to display 40 cells. If we use
the attribute hierarchy to display the searched customer, all is fine until
the user trys to drillthrough using the DRILLTHROUGH.HTC functionality from
the toolpack. The users machine "appears to hang, but a simple look at the
performance monitor shows memory usage of IE growing rapidly (sometimes to
1GB plus).

I have steped through and found the issue with a fucntion call "FindMember",
aka memTemp.Field.FieldSet.FindMember(sTemp, ptconst.plFindFormatPathName).

Is there a possible work around for this - our poor users are screaming for
help.

Thanks
JPO

 

[Colbert Zhou [MSFT]]

Hello Justin,

Yes, I understand it is a problem that the slow performance may occur when
the data hierarchy is deep and data count is huge. I do a lot of research
on this aspect, but unfortunately, I did not find any workaround for this
currently.

What about exologic's comment in this discussion, adding an indexing level?
http://groups.google.com.sg/group/microsoft.public.sqlserver.olap/browse_thr
ead/thread/57b138502ed58567/c5173ea10edc4397?hl=en&q=OWC+drillthrough+exampl
e+performance

Since the OWC stops updating, personally speaking, I would like highly to
suggest you migrate to the new Excel Service for PivotTable on web. See
detailed information in the following link,
http://msdn.microsoft.com/en-us/library/ms546696.aspx
http://go.microsoft.com/fwlink/?LinkId=84830&clcid=0x409
http://blogs.msdn.com/excel/archive/2008/01/09/replacing-owc-reporting-with-
excel-services.aspx


Best regards,
Colbert Zhou (colbertz @online.microsoft.com, remove 'online.')
Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://support.microsoft.com/select/default.aspx?target=assistance&ln=en-us.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.