Browse by Tags

• analysis
• architecture
• backup
• bi
• business intelligence
• cube
• fact
• high availability
• holap
• katmai
• molap
• olap
• restore
• rolap
• sql server
• ssas
• storage mode
• table
• technet
• what if
• whitepaper

SQL Server OLAP - back to basics for Cube access from front-end application?
11 February 08 02:38 AM | SQL Master | 3 Comments   

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 Read More...

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

Backup and Restore of Analysis Services Database - gotchas
12 December 07 02:38 AM | SQL Master | 2 Comments   

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. Read More...

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

SQL Server 2008 June CTP: Analysis Services - Dimension Design
11 June 07 03:36 AM | SQL Master | 1 Comments   

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 Read More...

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