Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Analysis Services   (RSS)
Monday, May 12, 2008 11:59

SQL Analysis Services error processing ROLAP partitions against Teradata

Today I was playing around with stacking SSAS on top of Teradata. Essentially I have AdventureWorks DW moved over into Teradata and I’m trying to build a dumbed-down version of the AdventureWorks cube against it. Things went fairly well while my partitions
Posted by russch | 1 Comments
Tuesday, May 06, 2008 10:17

Save your SSAS browser queries for re-use: new add-in

File this under "reclaim a few second of your life". If you build semi-complex pivots in the SSAS browser, you probably get annoyed when you have to rebuild them time and time again after you close the cube designer. Well, Yossi Elkayam has written the
Posted by russch | 0 Comments
Monday, November 19, 2007 2:18 PM

SQL Server 2008 "Katmai" CTP5 released

Just got an invite from Microsoft Connect to download the November CTP of SQL 2008....you can, too! http://www.microsoft.com/downloads/details.aspx?FamilyId=3BF4C5CA-B905-4EBC-8901-1D4C1D1DA884&displaylang=en
Posted by russch | 1 Comments
Wednesday, October 24, 2007 7:41 PM

Alerting without SQL Server Notification Services

Last week I worked with a customer who wanted to give users the ability to create and subscribe to alerts for changing KPI Values. This is a pretty standard scenario, and one we covered with BSM 2005. However, with the “loss” of Notification Services
Posted by russch | 3 Comments
Attachment(s): Package.dtsx
Friday, October 19, 2007 2:29 PM

Bad password trying to process an SSAS cube against Oracle

Shout-out to my homies Chris and Thanh. Depending on how you set up the impersonation settings on your Analysis Services cube’s data source to Oracle, you may run into the following error when trying to process: Login failure: Unknown username or bad
Posted by russch | 1 Comments
Thursday, September 20, 2007 1:22 PM

Dell and Microsoft engineer BI offering

Today at SQL PASS, Dell and Microsoft announced a new set of Business Intelligence and Data Warehousing solutions. They include a stack of server hardware, storage arrays, operating system, database and analytics software, management and reporting tools.
Posted by russch | 1 Comments
Wednesday, September 19, 2007 9:00

Mosha Pasumansky releases new Analysis Services MDX tool

Mosha just announced the availability of a new tool he wrote called MDX Studio: MDX Studio is tool which helps users of Microsoft Analysis Services to analyze complex MDX expressions, monitor performance characteristics of MDX queries and get insight
Posted by russch | 0 Comments
Tuesday, September 18, 2007 9:35 PM

At SQL PASS? Don't miss these sessions!

Right now I'm in Ocean Shores, WA for team meetings, so I won't be attending SQL PASS. However, if I was, I'd be sure to hit the SQL CAT sessions being presented: https://www.sqlpass.org/summit/Lists/2007%20Summit%20Sessions/SQL%20CAT%20Sessions.aspx
Posted by russch | 0 Comments
Wednesday, August 29, 2007 5:51

Hot off the presses: resolving MDX query performance bottlenecks

Carl Rabler et al have just released a really nice looking best practives article on how to resolve query perf bottlenecks. Get it here: http://www.microsoft.com/downloads/details.aspx?FamilyId=975C5BB2-8207-4B4E-BE7C-06AC86E24C13&displaylang=en
Posted by russch | 1 Comments
Thursday, June 14, 2007 6:35 PM

AMO Error when adding an attribute to an existing dimension: The transaction cannot be committed because one or more objects were invalidated during the transaction

Today’s tale from the front: I needed to write some POC code and kept on running into the error below when attempting to Update() the dimension I had added an attribute to: The cube with the ID of '<cube>', Name of '<cube>' was invalidated
Posted by russch | 3 Comments
Monday, May 07, 2007 2:39 PM

How do you set “(Select All)” as the default for multi-value parameters in Reporting Services?

The short answer is that you can’t, although there is a workaround. Essentially, “(Select All)” as implemented in Reporting Services simply does this: if (all parameter values/members are already selected) { deselect all values/members } else { select
Posted by russch | 4 Comments
Attachment(s): DefaultSelectAll.rdl
Wednesday, April 25, 2007 8:39

MDX Script Performance Analyser on CodePlex

I forgot about this one - Chris "Master Chief of MDX" Webb is among the contributors to the MDX Script Performance Analyzer: "...The MDX Script Performance Analyser allows the user to identify how much each calculated member, named set and scoped assignment
Posted by russch | 0 Comments
Friday, April 20, 2007 3:09 PM

SQL Analysis Services Load Simulator released on CodePlex

Just a little while ago ASLoadSim was realeased on CodePlex. It "...contains a set of utilities used to generate a query load and test the scalability of Analysis Services server...". Sounds great to me! Included as part of the distro is an whitepaper
Posted by russch | 1 Comments
Friday, February 16, 2007 9:35

SQL 2005 SP2 most likely available this Monday, 2/19

Get ready to download, because SP 2 was declared "ready to ship" last night. The SQL team is hoping to have it ready for public download Monday-morning-ish (PST).
Posted by russch | 6 Comments
Thursday, February 01, 2007 7:35

Mixed Bag: Troubleshooting Reports and Viewing MDX in Excel 2007

Just making note of two very worthwhile blog entries I've seen over the last few days. In this post , Lukasz Pawlowski provides us with a nice top-to bottom SSRS troubleshooting approach with links to additional information on most troubleshooting topics
Posted by russch | 0 Comments
More Posts Next page »
 
Page view tracker