Microsoft SQL Server Analysis Services OLAP多维数据集 [英] Microsoft SQL Server Analysis Services OLAP cube

问题描述

我试图在我们的应用程序的报告中找到一种提高性能的工具，并且听说OLAP + Reporting Services被描述为可以很好地完成这项工作的组合.无论如何，我没有找到使OLAP多维数据集保持最新状态的方法，因为原始数据库中的数据可以更改. (这是一个交易应用程序，一个待处理的记录可以标记为已付款等).

I was trying to find a tool to increase performance in the reports of our application and I heard about OLAP + Reporting Services which is described as an excellent combination to do this work. Anyway I didn't find the way to keep the OLAP cube up-to-date since the data in the original DB can change. (It's a transactional application and one pending record can be mark as paid etc).

这是更好的方法吗?还是应该使用其他技术?

Is this the better way to do this, or should I use another technology?

如果建议仍然使用OLAP + Reporting Services，如何获取最新信息?

If the suggestion is still to use OLAP + Reporting services how can I have the information up-to-date?

推荐答案

我从未使用过它们，但是我听说占星术+算命的价格非常便宜，更快，更有效，制作魔术并需要提供更少的输入比您在此问题中所做的要好.

I have never used them but I've heard that astrology + fortune telling are extremely cheaper, faster, more efficient, make magics and require to provide even less input than you did in this question.

无论如何，由于原始数据库中的数据可能会发生变化，因此我没有找到使OLAP多维数据集保持最新状态的方法."

"Anyway I didn't find the way to keep the OLAP cube up-to-date since the data in the original DB can change."

它称为 ROLAP存储模式

这篇关于Microsoft SQL Server Analysis Services OLAP多维数据集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！