Browse by Tags

• analysis
• backup
• credentials
• cube
• error
• excel
• olap
• operation failed
• pivot
• security
• sql server
• ssas
• ssms

OLAP Connectivity from Pivot Table in Excel - security permissions
25 September 07 02:14 AM | SQL Master | 4 Comments   

Security permissions in OLAP is similar to normal OLTP based environment. Say if you are using Pivot Table object in MS Office Excel to display the reports using OLAP objects like Cubes. To achieve this it should connect to an OLAP Server and database Read More...

Filed under: sql server, ssas, olap, execute, ssms, pivot, credentials, security, excel

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