Join me for Lunch - SQL Lunch #33 (Indicators, Sparklines and Databars) #33-SSRS 2008 R2 - Indicators, Sparklines and Databars Speaker: Patrick LeBlanc Add To Outlook: Add To Calendar Live Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=RZW5HJ&role=attend Date and Time: 9/1/2010 11:30:00 AM CST BIO: Patrick LeBlanc, SQL Server MVP, is currently a Business Intelligence Architect for Pragmatic Works. He has worked as a SQL Server DBA for the past 9 years. His experience includes...
Read More
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 one of my co-workers at Pragmatic Works. Here are the requirements: Columns: Reseller Sales Amount and using the Source Currency Code add a column to the result that displays US if the currency code is USD and International for all other currency codes. Rows: Country and State-Province Filters: None ...
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 simple statement that satisfies most of the puzzle requirements. The only one that is does not satisfy is the ordering of the results. To do this I used the ORDER function. The function accepts two arguments. The first is a valid expression that returns a set. In this example it is the set of Produ...
As we continue with the puzzles, I will continue to introduce new MDX functions. In this puzzle the requirements are as follows: Columns : Reseller Sales Amount Rows : Product Subcategories Filters : None Hints : This puzzle is too easy for a hint. ;) Ahhhh, but there is one additional requirement, the resulting rows should be returned in DESC order by Reseller Sales Amount. Remember, don't post your solution here. Save them for my solution post. I will post it along with the steps that was take...
After spending a week in Tampa, FL at a client site I've had some time to unwind and reflect back on SQL Saturday #28. I have received some really positive feedback from all individuals involved. While I can't say that every aspect of the event was excellent, I can say that compared to last years event this one far exceeded any of my expectations. I have read several blog posting about the event and I have to issue one correction, most of you are reporting our attendance as 350 attendees. That i...
So, I was recently asked if you could display a vertical bar on a line graph to denote the last day of the month. Initially, I had no clue how to solve this problem. I talked to a couple of people and searched the web, but came up empty. I decided to just dive into a report and solve the problem on my own. So I started with the following query that can be run in the AdventureWorks2008 database: SELECT st.CountryRegionCode, CAST (sod.OrderDate AS DATE ), SUM (sod.TotalDue) TotalDue, NULL Marker F...
Again I want to apologize for the slow posting of the solution to this puzzle, but I have been hard at work on SQL Saturday #28 . Fortunately, I carved out some time to write it up. The solution to this puzzle could have been accomplished a couple of ways. I chose to use the SUM and YTD MDX functions, but before I discuss these functions I will start with the basic query, which satisfies these requirements: 1. Internet Sales Amount as a Column 2. Delivery Date Calendar Month as a Row 3. Applies ...
In this three part series SQL Server MVP Andy Leonard will discuss SSIS Design Patterns . Speaker: Andy Leonard Add To Outlook: Add To Calendar Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=J8NSMR&role=attend Date and Time: 8/9/2010 11:30:00 AM CST Topic: #28-SSIS Design Patterns 1a: Introduction to SSIS Design Patterns This is part one of a three part series. A brief introduction to the concept and usage of design patterns and a demonstration of the Counts Acquisition in ET...
We are just about a week away from probably the biggest FREE training event to ever take place in Baton Rouge, LA. Heck this is probably the biggest FREE technology event in Louisiana. I really don't know. Nevertheless, since it is almost here I wanted to encourage any one that has not already signed up to do so now. We are well over 500 registered attendees and that number is increasing daily. If you are not sure whether to attend or not here are a few highlights: 53 sessions, including 4 early...
Do you have a challenging SQL Server or .Net issue that is causing you to have sleepless nights? Well, we have convinced 12 of our speakers (Experts) to allocate an additional hour of their day strictly for answering questions. These are some of the top SQL Server and .NET guys in the industry. So, if you have any questions bring them to SQL Saturday #28 Baton Rouge. Here is the schedule. Time Slot Speakers Topics 9:00 am – 10:00 am Chris Eargle and Chander Shekhar Dhall Software Development, Ap...
Writing YTD totals and Running totals using T-SQL can take a little effort. However, with MDX it's not too difficult. In this puzzle I will write an MDX statement that produces a monthly YTD or Running total. Here are the requirements: Columns : Monthly Running Total (Calculation), Internet Sales Amount Rows : Delivery Date Calendar Month Filters : Delivery Date from January 2006 to December 2006 Hints : You may need to create a scope calculation (WITH MEMBER), use the YTD and SUM functions Reme...