枢轴性能行为与多维数据集浏览器有很大不同 [英] pivot performance behaviour so much different from cube browser

问题描述

我们在excel 2007中构建了一个枢轴，该枢轴的性能非常差.

在多维数据集浏览器中执行同样的操作2秒钟，信息就在那里了.

当然一直使用探查器，查询也大不相同.

是否有一种方法可以使用枢轴来加快速度，是否已在某处进行了记录?
如果没有，是否有办法将查询存储在此特定excel报告的.odc文件中?

---

商务智能专家

We've built a pivot in excel 2007 which performs very badly.

Doing the same in the cube browser, 2 seconds and the information is there.

Of course been using the profiler and the queries are very different.

Is there a way in using the pivot which speeds it up and is this documented somewhere?
if not , is there a way to store a query in the .odc file for this specific excel report? and would it be able in the filters to choose another value once you store a query?

---

Business Intelligence professional

推荐答案

你好，

谢谢您的发帖！不幸的是，当前没有论坛发布您要提问的问题，因此我建议您将您的问题发布到位于以下位置的microsoft.public.excel.programming 中的 Discussions 中的一个: (

Thank you for your post!  Unfortunately there is not a current forum to post the question you are asking so I would recommend that you post you question to one of the (Discussions in microsoft.public.excel.programming) located here:  (http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.excel.programming&cat=en_us_19e6ab45-8feb-4ce1-9a70-1d87d8dfb131&lang=en&cr=us)

希望会有所帮助.

希望有帮助！

感谢&问候，

这篇关于枢轴性能行为与多维数据集浏览器有很大不同的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！