Browse by Tags

SQL Server OLAP - back to basics for Cube access from front-end application?

Published 11 February 8 3:38 AM | SSQA.net

One of the [SSP] forum user asked about what is OLAP, how the process flow occurrs when update happens to a fact table! It sounds like the basic question for Analysis Services user, OLAP - On-Line Analytical Processing for BI - Business Intelligence is...

Filed under: sql server, technet, bi, olap, dimension, table, whitepaper, cube, business intelligence, architecture, fact, what if

Backup and Restore of Analysis Services Database - gotchas

Published 12 December 7 3:38 AM | SSQA.net

Since the evolution of SQL Server 2000 version the backup and restore methods have been enhanced for better performance to provide a better option for the DBA, as usual the backup and restore operations are an integral part of the Analysis Services infrastructure...

Filed under: sql server, restore, high availability, backup, olap, dimension, cube, rolap, molap, holap, storage mode

SQL Server 2008 June CTP: Analysis Services - Dimension Design

Published 11 June 7 5:36 AM | SSQA.net

This is the first of the 6 technical Live meeting series we have planned for you. In this session you will hear directly from Robert Zare who leads this improvement team. AS-Dimension Design enhances UI for creating and editing dimensions to guide users...

Filed under: sql server, analysis, ssas, katmai, dimension