Querying dimension members in MDX
Today we’re back looking at MDX with a quick how-to. How do you extract a list of dimension members using MDX?
This could be used for example to populate a […] Continue Reading…
Rock Paper Scissors Lizard Spock
I want to share with you some genius level work by Phil Quinn (blog | twitter), who is furthering the boundaries of […] Continue Reading…
Find first order date in MDX
I had an interesting question the other day; “how do I find the date of the first order/activity for a given customer/employee/product etc in MDX”?
Well you’ll be pleased to […] Continue Reading…
Still time to register for SQL Saturday 162 in Cambridge
Just a quick reminder, if you haven’t registered already then get yourself to the SQL Saturday website and register for the UK’s first ever SQL Saturday, in Cambridge on […] Continue Reading…
Speaking at SQL Saturday 162 in Cambridge
I’m thrilled to have been selected to speak at the UK’s first SQL Saturday event – A big thank you to the organisers, I’ll already buzzing about it!
SQL Saturday […] Continue Reading…
MSc Dissertation – Performance of Loading SCDs in SSIS
Well after 3.5 years, I’ve finally completed my MSc Business Intelligence – hoorah! And to reward the time, effort and increased grey hair, they saw fit to give me […] Continue Reading…
SQLBits X Video available
SQLBits X Video Now available
The video of my talk at SQLBits X is now available on the SQLBits website here. The talk was focused on presenting the results of […] Continue Reading…
SQL Relay Agenda Announced
SQL Relay: Free, Full Day SQL Server Events
If you’ve not heard the news yet, then where have you been hiding?! With SQLBits X such a phenomenal success, but already […] Continue Reading…
Automating T-SQL Merge to load Dimensions (SCD)
This is the 3rd post in the Frog-Blog series on the awesomeness of T-SQL Merge.
Post 1: Introduction to T-SQL merge basics
Post 2: Using T-SQL merge to load data warehouse […] Continue Reading…
Map Postcodes in SSRS Reporting Services
I was asked the other day for some help on how to plot data by postcode on an SSRS spatial map. I’ve done this a few times, initially for […] Continue Reading…
The Frog Blog
Team Purple Frog specialise in designing and implementing Microsoft Data Analytics solutions, including Data Warehouses, Cubes, SQL Server, SSIS, ADF, SSAS, Power BI, MDX, DAX, Machine Learning and more.
This is a collection of thoughts, ramblings and ideas that we think would be useful to share.
Authors:
| Alex Whittles (MVP) |  |
| Reiss McSporran |  |
| Jeet Kainth |  |
| Jon Fletcher |  |
| Nick Edwards |  |
