Browse by Tags

• architecture
• backup
• bi
• business intelligence
• dimension
• fact
• high availability
• holap
• molap
• restore
• rolap
• sql server
• 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