This week's puzzle used a couple functions we learned about a few weeks back . To solve the Sixth Sense puzzle, you should have used the TopCount function (or the Head and Order functions) and the Generate function . So lets start off with a basic query that gives us the Internet Sales for the five states with the highest Internet Sales Amount by using the TopCount function . SELECT [Measures].[Internet Sales Amount] ON COLUMNS, TOPCOUNT( [Customer].[State-Province].CHILDREN, 5, [Internet Sales ...
Read More
After earning my MCTS certification a few months back, I jumped right into prepartion for passing the 70-452 certification exam (MCITP). Shortly thereafter in mid November, I earned my MCITP certification. The 70-452 exam builds upon the technical skills tested on in the MCTS exam. Basically the MCITP exam validates that you have the skills necessary to perform the role of a database administrator or enterprise messaging manager. According to Microsoft, the MCITP candidate can "make the design a...
This week's MDX puzzle builds on one we had a few weeks back , so check it out. I know it's been a while since I gave away a prize for a correct answer, but this week I'll be giving away another Kick'n SSAS t-shirt! Now on to the puzzle! Rows: State/Province Products Columns: Internet Sales Amount Filters: None Hints: Show the top 5 states or provinces with the highest Internet Sales Amount. Show the top 10 Products with the highest Internet Sales Amount for those 5 states or provinces. Check th...
A few days ago Adam Jorgensen posted a blog outlining some of the current job openings at Pragmatic Works so I thought I'd post a little bit about my experiences working for this great company. I was the third employee hired in our office as a Jr. Business Intelligence Consults in October of 2008 and I can honestly say that working at Pragmatic Works is the best job I have ever had. Every day I am genuinley excited to go to work. Working with the crew at Pragmatic Works allows me to increase my ...
Our latest MDX puzzle called for using a few functions we haven't used yet. To solve the Fifth Element puzzle, we were required to show the Year to Date Reseller Sales, the Reseller Sales for the same month in the previous year, and the Reseller Sales Amount for each month in the year 2007. Let's start out with a base query that simply shows the Reseller Sales Amount on the columns and the months on the rows. You can see I've used the where statement to filter the results for only months in the ...
After a relaxing and enjoyable Thanksgiving break from work, its back to the grind stone. Monday and Tuesday were a little crazy for me, which is why this week's puzzle isn't getting posted until today. Due to that fact, the answer won't be due until Friday of next week, which is December 10th. So here is the next MDX puzzle: Rows: Calendar Month Columns: Reseller Sales Amount Year to Date Reseller Sales Amount Reseller Sales Amount for the same month in the previous year Filters: Calendar Year ...