SSAS Articles 
Local Cube Complete OLAP infrastructure without Microsoft Analysis Services, parts 1-3
Local Cube Complete OLAP infrastructure without Microsoft Analysis Services, parts 1-3
| Complete OLAP infrastructure without Microsoft Analysis Services, parts 1-3 |
| Written by Wiktor Zychla |
| Friday, 27 June 2008 23:55 |
|
Few weeks spent in the OLAP world searching for answer for following question: How to be able to do OLAP with no additional tools available? Specifically: are we able to build a full OLAP infrastructure for clients who do not have Microsoft Analysis Services or any other enterprise OLAP severs? For few last years our company used Microsoft Excel to perform online analysis of the relational data. As you know, Excel's capable of building pivot tables for any kind of relational data. There are three problems with Excel:
Read more: |
Top Rated
- SSAS Implementation Best Practices slides in PDF format
- SSRS Report Against a SSAS Parent Hierarchy
- Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005
- Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage
- Handling Multiple Calendars with a M2M Scenario
- Passing MDX parameters in Reporting Services reports
- Using UserName to Control Data Access and Default Member in SSAS 2K5 (Carrie Williams)
- SSAS Tutorial: SQL Server 2005 Analysis Services Tutorial by Accelebrate
