I did a presentation last week for the Denver SQL Server User Group (www.DenverSQL.org) and the Colorado Springs SQL Server User Group (www.SpringsSQL.org) on Intro to Analysis Services.  The slide deck can be found here: http://www.marcbeacom.com/downloads/IntrotoAnalysisServices.pptx.  Both were short presentations (30 minutes) aimed at getting folks started with… Read more

Denver SQL Server User Group:

A “Biking Buddy” Adventure Works hospitality report.  Always have something in common to talk about with a biking buddy that is a palatable drive from your zip code.

Thursday February 19, 2009

Description:

Ever want to bike with someone but would like to have something… Read more

We use the Analysis Services Deployment Wizard when moving our cubes from Dev to QA and then QA to Prod.  Up until this point, we have been in "Beta" meaning that we have a few developers that have access plus a few SME's (Subject Matter Experts).  So every once in… Read more

I attended this years  PASS Summit in Seattle and it turned out to be a great event.  Many of the sessions I attended were standing room only.  During the first Keynote, the presenter showed off a few new features in Kilimanjaro.  Kilimanjaro is the code name for the next release… Read more

You will see this or a similar code sample when referring to clearing the analysis services cache.  However, I have yet to find a good resource that explains exactly what running an empty MDX query against a cube really is doing. 

Here is an example of code to clear the… Read more

I just leaned today that Glenn Berry has had his MVP award renewed for another year.  If you have not read his weblog, I'd highly recommend checking it out at http://glennberrysqlperformance.spaces.live.com.  Besides the informative information he blogs about, he is also a very active member in the community and… Read more

Including the parameter values to the physical report so they get printed with the business data is a best practice and for good reason.  I have seen several printed reports that you could not tell the date ranges, products, etc... the report was ran for.

The Join function in SSRS… Read more

Ever wanted to change the default template and style for the Reporting Services Wizard?  Just think how much time this would save of repetitive work inserting images, formatting colors and text.

Well there are two files that maybe of interest to you; StyleTemplates.xml and Report.rdl.  If you are familiar with… Read more