Browse by Tags

All Tags » Analysis Services   (RSS)
Analysis Service error: Either the user, Domain\User, does not have access to the Database Name database, or the database does not exist.
10 July 08 01:02 AM | SQL Master | 2 Comments   
As it seems the error text on the subject looks familiar when you have installed SQL Server or working with SQL Server databases. How about getting the error on Analysis Services databases (OLAP) within your BI Platform. So in the case of handling the Read More...
SQL Server 2005 BI evaluate and diagnose Analysis Services database performance
18 February 08 02:57 AM | SQL Master | 3 Comments   
Performance - one word does it all! You are aware that during the Performance Tuning exercise there are few quick wins within the SQL Server Relational Database Engine such as table statistics for data and indexes. When it comes to Analysis Services (BI) Read More...
SQL Server Analysis Services MDX Query performance monitoring - highlights
29 January 08 02:27 AM | SQL Master | 5 Comments   
When it comes to monitor the query performance whether it is TSQL or MDX, the process is similar. You need to have a better understanding on how queries are executed (architecture), what tools are available for monitoring and best practices to improve Read More...
SQL Server Analysis Services slicing and dicing
27 January 08 05:08 AM | SQL Master | 3 Comments   
I was going through Books Online in learning the concepts of slicing of data within Analysis Services for the new project that is upcoming, all these years I have basic knowledge of SSAS and with latest available features in SQL Server 2005 Analysis Services Read More...
New whitepaper available on Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques
03 January 08 10:36 AM | SQL Master | 2 Comments   
Got this update from SQLCAT blog on MSDN about new whitepaper on Analysis Services many-to-many dimensions that helps in MDX query performance optimization steps you need to take care. Many-to-many dimension relationships in SQL Server 2005 Analysis Services Read More...
"Provider cannot be found" error when trying to run a MDX query?
05 November 07 01:39 AM | SQL Master | 2 Comments   
One of the Business user asked for the resolution for the error they are getting when running a MDX query against the Analysis Services database within their data mart. The error is "Provider Cannot be found", before going further on this error ensure Read More...
Monitoring the parallel processing performance of Analysis Services?
08 October 07 01:08 AM | SQL Master | 2 Comments   
The ascmd.exe command-line utility is a handy tool for testing performance characteristics to determine the appropriate values for parallel processing. This utility is similar to the sqlcmd.exe utility that you use to execute SQL statements in SQL Server. Read More...
Automation of Analysis Services database backup
26 September 07 03:19 AM | SQL Master | 2 Comments   
You may be well versed with scheduling the database backups using SQL Serve Agent --> Jobs with Enterprise Manager or Management Studio. So how about creating a automation job for SQL Server 2005 analysis services database backup every night. Simple, Read More...
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...
SQL Server 2005 Analysis Services Operations Guide
03 July 07 08:36 AM | SQL Master | 0 Comments   
You might agree with me that every Database Administrator who operates the SQL Server Analysis Services portion of a data warehouse faces certain common operational issues. To highlight what issues must be controlled I would like to specify that change Read More...
Analysis Services Performance Tuning Whitepaper Has Arrived
30 January 07 03:42 PM | Elizabeth Vitt | 0 Comments   
The long awaited Analysis Services 2005 Performance Tuning guide is now available at http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SSAS2005PerfGuide.doc I know that it has been a long time in the making but hopefully Read More...
Filed under:
Analysis Services - Importing Perfmon Data into Profiler
09 July 06 10:43 PM | Elizabeth Vitt | 0 Comments   
One of the greatest enhancements in Analysis Services 2005 is the ability to use SQL Server Profiler to troubleshoot performance issues during querying and processing. Even cooler is the ability to import Perfmon data into Profiler so you can analyze Read More...
Filed under:
Influencing Aggregation Candidates
03 July 06 01:58 AM | Elizabeth Vitt | 0 Comments   
Mention aggregations to any OLAP geek and you will likely hear that aggregations are the cornerstones of OLAP databases. In the new attribute paradigm of Analysis Services 2005, designing effective aggregations can be a somewhat challenging task. In fact Read More...
Filed under: