Menu
I'm wondering if there is any desktop OLAP solution that can use SQL Express (and therefore does not require Analysis Services)
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.
412
SQL Server Analysis Services (SSAS) offers OLAP and data mining functionality for business intelligence applications.
In this article, we learn about Online Transaction Processing System (OLTP) and Online Analytical Processing System (OLAP). OLTP and OLAP both are online processing systems. OLTP is an online database modifying system, whereas OLAP is an online database query answering system.
OLAP cubes can be considered as the final piece of the puzzle for a data warehousing solution. An OLAP cube, also known as multidimensional cube or hypercube, is a data structure in SQL Server Analysis Services (SSAS) that is built, using OLAP databases, to allow near-instantaneous analysis of data.
SQL Server Analysis Services (SSAS) is a multi-dimensional OLAP server as well as an analytics engine that allows you to slice and dice large volumes of data. It is part of Microsoft SQL Server and helps perform analysis using various dimensions.
SQL Express is pretty limited, I don't know of any OLAP capabilities.
Although, we use DevExpress OLAP Pivot Grid with ROLAP to get around this problem.
Just create a cube-like SQL query and plug it in.
SELECT productname, reasonforsale, salestotal
FROM orderdetail
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
