SQL Express上的OLAP [英] OLAP on SQL Express

问题描述

我想知道是否有任何可以使用SQL Express的台式机OLAP解决方案(因此不需要Analysis Services)

I'm wondering if there is any desktop OLAP solution that can use SQL Express (and therefore does not require Analysis Services)

我一直在寻找一种方法来允许我们的客户执行即席"报告，但是其中大多数是在Sql Express上进行的.在以前的工作中，客户曾使用过Analysis Services，通常是Cognos或Crystal报告，因此所需要做的只是设计多维数据集.

I've been tasked with finding a way to allow our customers to do 'Ad-Hoc' reports, but the vast majority of them are on Sql Express, In previous jobs, customers have had Analysis Services and typically Cognos or Crystal Reports, so all that was required was to design the cube.

推荐答案

SQL Express非常有限，我不知道任何OLAP功能.

SQL Express is pretty limited, I don't know of any OLAP capabilities.

尽管如此，我们使用 DevExpress OLAP透视网格和 ROLAP 可以解决此问题.

Although, we use DevExpress OLAP Pivot Grid with ROLAP to get around this problem.

只需创建一个类似于多维数据集的SQL查询并将其插入.

Just create a cube-like SQL query and plug it in.

SELECT productname, reasonforsale, salestotal
  FROM orderdetail

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