OLAP连接{多维数据集}的Excel性能问题 [英] Excel Performance Issue with OLAP Connection { Cube }

问题描述

大家好，

从Cubes(SSAS)获取的Excel报告中，我们当前面临性能问题.

We are currently facing performance issue in Excel reports fetched from Cubes( SSAS ).

我们已经向用户提供了这个excel多维数据集，当他们尝试在5-6维度级别上进行搜索时，性能开始呈指数级下降，并且需要数小时才能获取结果或发送错误消息.

We have provided this excel cube to user and when they try to do search on 5-6 Dimension level performance start degrading exponentially and it takes hours to fetch the result or it send an error message .

请提出我们如何解决该excel性能问题的问题，即使用适当的连接字符串进行olap连接.

Please suggest how can we fix this excel performance issue its a olap connection with proper connection string .

直到二维报表仍能正常工作..但是，一旦我们尝试将其拉低，它就会变低.

Till 2 dimension reports work fines..but as soon we try to pull more it goes low.

此致

Sweta

推荐答案

嗨Sweta，

Hi Sweta,

能否请您显示错误的屏幕截图以进行进一步分析?

Could you please show me the screenshots of the errors for further analysis?

最好的问候，
刘奕迅

Best regards,
Ethan Liu

这篇关于OLAP连接{多维数据集}的Excel性能问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！