SSAS Cube性能 [英] SSAS Cube performance

问题描述

我是SSAS的新人。我有几乎800MB大小的立方体，没有定义任何分区和聚合。用户需要几乎所有度量和事务级别的数据。当用户在DateKey级别浏览数据时，它会停留很长时间并且没有返回
任何结果。我已经实现了分区和聚合，但结果是一样的。在我的场景中，用户想要审计，并希望在行级别上有80％的多维数据集数据。 

I am a new one in SSAS. I have cube of almost 800MB size without any partition and aggregation defined. User want data of almost all measures and at transaction level. When user browse data at DateKey level then It stuck for a long time and did not return any result. I have implemented partitions and Aggregations but result is same. In my scenario user want auditing and want 80% of cube data at row levels. 

我应该去进行缓存吗？请建议我任何解决方案。 

Should I go for Caching? Please suggest me any solution. 

推荐答案

您可以在此处发布您的问题  http://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlanalysisservices 功能;或者论坛的版主
需要在那里提出您的问题。

You may want to post your question here http://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlanalysisservices or moderators of this forum need to move your question there.

这篇关于SSAS Cube性能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！