问题描述
我试图在我们的应用程序的报告中找到一种提高性能的工具,并且听说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.
它称为 ROLAP存储模式
这篇关于Microsoft SQL Server Analysis Services OLAP多维数据集的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!