Tagged Questions
3
votes
1answer
184 views
How do I display subtotals in cube browser in SSAS 2012 (Sql Server Data Tools)?
Apparently this feature was available in previous versions but has now been removed.
What are some alternatives?
6
votes
3answers
511 views
What advantages does in-memory OLAP have over traditional systems with significant memory?
Do in-memory OLAP engines have advantages over the traditional OLAP engines backed by enough RAM to contain the entire cube(s)?
For example, if I use a MOLAP engine (SSAS) and GB / TB of RAM where ...
5
votes
1answer
158 views
How to report on sparse areas of sparse fact table
A source system tracks student attendance for a school district by reporting absence events. Attendance on any particular day can be determined by examining three datasets: school calendar, student ...
3
votes
2answers
385 views
Combining retail sales and payment OLAP cubes
I'm using SQL Server 2005 Standard Edition Analysis Services (SSAS). I'm trying to build cubes from a retail OLTP database that can answer these kinds of questions:
List down all products that were ...
