Who is online?  165 guests and 0 members
Home  »  Blogs  »  DevinKnight  »  Anaylsis Services Partitions and Aggregations PASS Session

Anaylsis Services Partitions and Aggregations PASS Session

change text size: A A A

posted  12/18/2009 4:42:46 PM  by DevinKnight

For a little more than a year now I've been a part of the PASS BI SIG and have tried to contribute whenever possible.  The SIG is split into several focus groups that meet on all BI topics.  I help in leading the SSIS group.  Today I actually had an opportunity to present to the Analysis Services focus group on the topics of Analysis Services Partitions and Aggregations which you can view here.

If you think you would like to present on any BI topic contact me and we'll get you lined up as a speaker (dknight@pragmaticworks.com).

 

 

tags :    SSAS, Partitions, Aggregations
  Rate This Blog Entry:  register  or  login

Author

DevinKnight DevinKnight (Member since: 10/27/2009 11:25:07 AM)
Devin (MCTS, MCITP) is a Senior BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin helps run his local users’ group (JSSUG) as a Vice President.

View DevinKnight 's profile

Comments (1)

DevinKnight
12/18/2009 5:32:57 PM DevinKnight said:
You may have to run an add-on at the top of your web browser to view this video.
by

Leave a comment


 
Type the characters:
 *
 
   

Join Business Intelligence Developer Network for FREE Today!

It's fast, easy and free! Submit articles, get your own blog, ask questions & give answers in the forums, and become a better developer, faster.

enter your email address:

Blogs RSS Feed

DevinKnight's latest blog posts

  • Creating a PerformancePoint 2010 Data Source
    9/1/2010 3:23:11 AM by DevinKnight  - Views: 2800  - Comments: 0
    In a previous post I wrote about getting started with PerformancePoint 2010. In that post you learned about what PerformancePoint is and where to open in in SharePoint 2010. Your next steps are to con...
  • SQL Lunch #26 Analysis Services Security
    8/5/2010 12:31:25 PM by DevinKnight  - Views: 277  - Comments: 0
    Today at 12:30 EST I will be presenting for SQL Lunch on the topic of Analysis Services Security. Make sure to be there to learn how to create dynamic or table based security in SSAS. Speaker: Devin K...
  • Getting Started With PerformancePoint 2010
    8/3/2010 4:01:47 PM by DevinKnight  - Views: 577  - Comments: 2
    PerformancePoint is a great tool for monitoring and analyzing the performance of your business at a high level but also has the ability to dig into the details. It makes it simple to create quick dash...
  • SSIS - Event Handler Performance
    7/20/2010 2:40:22 AM by DevinKnight  - Views: 308  - Comments: 0
    Event handlers are a great tool for managing errors and other events that occur during the execution of a package run. Using event handlers can however add additional time to the run of a package. Dep...
  • SSAS Cache Warming with an SSIS package
    7/1/2010 11:26:49 AM by DevinKnight  - Views: 486  - Comments: 3
    There are several techniques that can be used for performance tuning Analysis Services. You may already be familiar with the typical methods used like Partitions and Aggregations . However, an often f...
  • MDX webinar
    6/24/2010 6:43:01 PM by DevinKnight  - Views: 213  - Comments: 0
    Today I did a webinar on MDX solution. For those of you interested you can grab the slides here and code example here . If you missed the session you can also download the recording here . We do month...
  • SSIS R2 Configuration File Issue Fixed
    5/14/2010 1:30:51 PM by DevinKnight  - Views: 526  - Comments: 3
    Using configurations files in SSIS is a great way to change how your package will run from outside the development environment. One thing that I’ve always recommended when using files (I actually pref...
  • Reporting Services 2008 R2 Report Parts
    4/24/2010 7:59:40 PM by DevinKnight  - Views: 985  - Comments: 0
    Reporting Services 2008 R2 has many new great features that I’ve written about lately ( Data Bars and Indicators ). Today I wanted to tell you a little about another nice add called Report Parts. Repo...
  • SQL Saturday #38 Jacksonville Update
    4/15/2010 1:03:41 PM by DevinKnight  - Views: 421  - Comments: 0
    With less than a month away, May 8, before the big event in Jacksonville I wanted to give you a little inside information about this event if you've never been to one before. SQL Saturday is a free tr...
  • Reporting Services 2008 R2 Data Bars
    4/13/2010 12:30:27 AM by DevinKnight  - Views: 1409  - Comments: 1
    Last week I wrote a blog explaining how the new tool inside Reporting Services 2008 R2 called Indicator will be help for displaying KPIs in Reporting Services. Today I want to looks at another nice fe...
  • Reporting Services 2008 R2 KPI ready
    4/9/2010 7:06:06 PM by DevinKnight  - Views: 2174  - Comments: 1
    As I begin to explore more and more of the new feature that will be available in SQL Server 2008 R2 I can’t help but think why was this not available before? One of these features is the new item in t...
  • Auditing Report Executions with Free Source Code
    3/30/2010 1:28:36 PM by DevinKnight  - Views: 2209  - Comments: 2
    Have you been looking for a way to measure report performance? Want to know who accesses your reports most frequently? Well there are some free reports on http://msftrsprodsamples.codeplex.com/ that y...
  • Using SSAS MDX Calculation Color Expressions
    3/17/2010 12:10:25 AM by DevinKnight  - Views: 3436  - Comments: 9
    Analysis Services calculations are great for storing formulas that your users need to see on a regular basis. They also have another little feature that adds just a little more wow when your end users...
  • Solving All Versus (Select All) SSRS End User Confusion
    3/12/2010 11:11:39 PM by DevinKnight  - Views: 1335  - Comments: 0
    When developing reports that use Analysis Services as a data source end user can sometimes be confused about some of the options they see in report parameters. Anytime you have a parameter that allows...
  • Using Excel 2007 in SSIS 2005
    3/2/2010 10:16:14 PM by DevinKnight  - Views: 3108  - Comments: 2
    Many companies are not in a rush to upgrade their SQL Servers because of the enormous cost to upgrade. This results in the majority of companies still running previous versions of SQL Server (2005, 20...
  • Using Database Transactions across multiple SSIS Tasks
    3/2/2010 8:17:55 AM by DevinKnight  - Views: 1024  - Comments: 2
    If you experiment at all with transactions that are built into SSIS you will discover that they are highly flawed. For example, if you have a transaction running on an entire package some tasks may no...
  • IntelliSense Slow to Refresh
    2/23/2010 11:36:14 AM by DevinKnight  - Views: 522  - Comments: 0
    IntelliSense in SQL Server 2008 can sometimes not be very intelligent. It’s there to help you can sometimes cause more problems than it does solve problems. Here’s one of those problems cases: Create ...
  • Free Webinar Series This Week
    2/22/2010 6:50:40 PM by DevinKnight  - Views: 419  - Comments: 0
    If you haven’t heard already this week there is a great free webinar series going on that’s meant for beginners. This series is meant to get you up to speed on many topics like TSQL, DBA Fundamentals,...
  • Development Lifecycle Deployment SSAS, SSRS, SSIS
    2/17/2010 10:26:07 AM by DevinKnight  - Views: 1042  - Comments: 0
    Many companies have a very rigid development lifecycle for all products or solutions they develop. Deploying to each of these environments (Development, UAT, and Production) can be a nightmare to main...
  • Foundation Class Review
    2/12/2010 10:22:46 PM by DevinKnight  - Views: 341  - Comments: 0
    This week was an exciting teaching week for me. I taught the Pragmatic Works Foundation class, one of my favorite and most rewarding classes to teach. This class is designed to help individuals who ha...
  • Pragmatic Works Foundation Class Introduction
    2/9/2010 8:38:56 AM by DevinKnight  - Views: 1427  - Comments: 0
    You may have noticed a flux of new blog post entires yesterday from a group of people talking about the Pragmatic Works Foundation. This is a great group of people that are new to IT and learning the ...
  • SSRS Commonly Required Date Expressions
    2/5/2010 2:01:40 PM by DevinKnight  - Views: 2077  - Comments: 1
    Reporting Services has many expressions that can manipulate date fields. These expressions can be used just about anywhere in SSRS including object properties, displayed data, and parameters. Recently...
  • Handling Escape Sequences in SSIS Expression String Literals
    1/27/2010 1:18:27 PM by DevinKnight  - Views: 1834  - Comments: 3
    The SSIS expression language is a powerful tool for a developer that gives you one method of making a package dynamic. When writing an expression there are a few things to be careful of that could pot...
  • SSIS Checkpoints with Tasks Running in Parallel
    1/22/2010 1:40:42 PM by DevinKnight  - Views: 825  - Comments: 2
    Several months ago I blogged about why Checkpoints are a great feature in SSIS to use. It seems with every feature there are potential problems you can run into and it is no different with Checkpoints...
  • SQL Lunch #8 recording
    1/15/2010 11:17:22 AM by DevinKnight  - Views: 277  - Comments: 0
    If you weren't able to attend tuesday for SQL Lunch you can watch the recording now mosted on the website. This session was on Data Driven Subscription. We had a great group of people with lots of goo...
Blogs RSS Feed

Latest community blog posts

  • Pirates of PASS: Curse of the Elections Process
    13 hours, 30 minutes ago by sqlchicken  - Views: 7843  - Comments: 3
    Pirate Code: They're more like guidelines really... The last few weeks we've watched the drama unfold in regards to the PASS BOD elections. We've seen people attack criticize the NomCom, the board, PA...
  • What are plan guides?
    9/2/2010 1:34:14 AM by indupriya  - Views: 6265  - Comments: 0
    Just a while ago I was watching a video on sqlshare Creating a Plan Guide for a Parameterized Statement By Andy Warren . Only then I heard about plan guides. I didn't know what plan guides were. Here ...
  • Did You Know..
    9/1/2010 8:22:35 PM by britmccullar  - Views: 6879  - Comments: 0
    Unfortunately, I don't have one big topic to write about in this post, so I decided to share some observations from the past few weeks - little things that might be of interest in the next report you ...
  • Creating a PerformancePoint 2010 Data Source
    9/1/2010 3:23:11 AM by DevinKnight  - Views: 2800  - Comments: 0
    In a previous post I wrote about getting started with PerformancePoint 2010. In that post you learned about what PerformancePoint is and where to open in in SharePoint 2010. Your next steps are to con...
  • Rock the Vote - Outlook Voting Buttons
    8/31/2010 5:46:06 PM by ChrisAlbrektson  - Views: 6023  - Comments: 1
    So today at the office I was faced with one of the more common and important questions that come up regularly and that was ‘Where are we going for lunch?’ This usually in tells a few minor arguments a...
  • Avoiding dynamic SQL - COALESCE( ) and your parameters
    8/31/2010 3:00:38 PM by KeithHyer  - Views: 7137  - Comments: 1
    Problem: Everyone that's programmed a system that users will interact with has run across a statement like this one in the fact-finding stage. "I want to be able to search on phone number. I can't ima...
  • "Drive" a great book
    8/31/2010 1:23:59 PM by MikeDavis  - Views: 2255  - Comments: 0
    If you only get a chance to read one book this year, it should be Drive , The Surprising Truth about what Motivates Us. This book has made me rethink how I am motivated and how I can motivate others. ...
  • An other Example of Calculation-Dimension
    8/31/2010 12:47:44 AM by Qazafi  - Views: 4104  - Comments: 0
    Recently one of my clients would like to see their Revenue figures represented some of the time as a positive (+VE) value and some time as a negative (-VE) value. They would like to have the ability t...
  • Template Parameters - Little Time Savers
    8/30/2010 8:45:36 PM by KeithHyer  - Views: 13373  - Comments: 3
    Lately, I've been enjoying various shows on the Science channel about Time and Space. No one yet understands exactly what time is yet - still, everyone wants to save some. I'd like to show how one mig...
  • Pragmatic Works Shines at 2010 Jacksonville Code Camp
    8/30/2010 3:24:25 AM by timmurphy  - Views: 2876  - Comments: 0
    I attended the 2010 Jacksonville Code Camp Sataurday and really was impressed with Pragmatic Works. The entire Business Intelligence stack was covered by speakers from PW including Brian Knight, Adam ...
  • Keyboard Shortcut to List All Column Names for a Database
    8/30/2010 2:51:25 AM by timmurphy  - Views: 532  - Comments: 1
    One of the hardest things about starting a new project is getting to know the database with which you are working. Here is a quick way to make a list of the all columns along with the name of the corr...
  • MDX Puzzle #7
    8/29/2010 9:40:12 PM by PatrickLeBlanc  - Views: 4190  - Comments: 2
    I have presented you with a couple of easy puzzles in the last few posts. So, let's step it up a little with one that is a little more challenging. I have to be honest, this puzzle was sent to me by o...
  • Restarting SQL Server using the GUI
    8/29/2010 4:23:50 PM by briankmcdonald  - Views: 4545  - Comments: 2
    Sometimes you may need to restart your instance of SQL Server. You should rarely do this on Production boxes, but in development or on your local desktop instance I restart my SQL Server instance fair...
  • Jax Code Camp - My Presentation and Projects
    8/28/2010 10:52:08 PM by briankmcdonald  - Views: 908  - Comments: 1
    First and foremost, I want to thank everyone who attended my presentation today. It got off to a late start due to the prior presentation running over and a little setup issues set me back a little bi...
  • SSRS Interactive Sorting
    8/27/2010 7:52:27 PM by SMcDonald  - Views: 574  - Comments: 0
    The other day I was creating a report and it needed some sorting capabilities. I said to myself, "Self, there may not be a lot of begginers that know how to add sorting capability". What I would like ...
  • MDX Puzzle #6 - Solution
    8/27/2010 6:15:17 PM by PatrickLeBlanc  - Views: 176  - Comments: 4
    Puzzle #6 should not have presented too much of a challenge, it's intentions were to introduction you to the ORDER function that is available in MDX. Ok, so this is what I started with: This is a very...
  • Jax Code Camp 2010
    8/26/2010 9:28:34 PM by BradSchacht  - Views: 74  - Comments: 0
    This Saturday is Code Camp in Jacksonville, FL. There are a lot of great speakers lined up, some of which you may have seen at other events such as SQL Saturday. If your free on Saturday come on out a...
  • Adding a Bing Map Layer
    8/26/2010 2:07:20 PM by ChrisAlbrektson  - Views: 174  - Comments: 0
    With the release of the SSRS 2008 R2 reporting developers now have a new tool that they can use when creating reports. The new tool I am talking about is the new map wizard. With this you can easily s...
  • PASS Elections Portal
    8/25/2010 9:31:01 PM by sqlchicken  - Views: 87  - Comments: 0
    If you've been under a rock the last few weeks you may not know that PASS is currently undergoing their board elections process. I'm not going to rehash the entire saga here but this is just a quick p...
  • Code Camp in Auckland New Zealand -- 29th August 2010
    8/25/2010 9:11:47 PM by indupriya  - Views: 100  - Comments: 0
    The MS Communities Code Camp & Technology Summit is a Free , non-commercial event, open to everybody with an interest in any of the technologies being discussed. Development This year we will be r...
  • Changing of the Guard
    8/25/2010 8:23:15 PM by sqlchicken  - Views: 91  - Comments: 2
    A few weeks ago Andy Leonard ( Blog | Twitter ) announced that he was stepping down from his position as PASS Regional Mentor. It is with great humbleness and excitement that I can officially say I'll...