Browse by Tags

• analysis
• Analysis Services
• architecture
• backup
• bi
• business intelligence
• dimension
• error
• execute
• fact
• high availability
• holap
• memory
• molap
• olap
• operation failed
• performance
• process
• restore
• rolap
• server
• 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

The operation has been cancelled. at Microsoft.AnalysisServices.Xmla.XmlaClient.CheckForSoapFault(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError)
28 August 07 02:08 AM | SQL Master | 2 Comments   

Full error text of above message while performing the backup of a Cube: The operation has been cancelled. at Microsoft.AnalysisServices.Xmla.XmlaClient.CheckForSoapFault(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError) at Microsoft.AnalysisServices.Xmla.XmlaClient.CheckForError(XmlReader Read More...

Filed under: sql server, analysis, cube, execute, operation failed, error, backup

While processing Cubes - Error: Memory error: Allocation failure : Not enough storage is available to process this command
27 August 07 03:47 AM | SQL Master | 2 Comments   

Got an email to inbox asking a resolution for : I can't find a remedy for this problem on Google either. Any help would be appreciated. When performing the data mining cube process - Error: Memory error: Allocation failure : Not enough storage is available Read More...

Filed under: sql server, server, performance, Analysis Services, process, memory, cube