Showing December to December to see opening values for a year in SSAS/MDX
I came across an interesting MDX challenge this week; within a cube’s Date dimension, how to show December twice, once where it should be and again as the opening […] Continue Reading…
SQL Server 2016 Licensing Changes, SP1, v.Next CTP1, etc.
By now you’ve probably heard the exciting news announced at today’s Microsoft Connect conference; SQL Server licensing is changing, significantly, from SQL 2016 SP1.
The functionality of SQL Server Standard, […] Continue Reading…
What is U-SQL?
By now you may have heard about U-SQL, the new kid on the query language block. But what is U-SQL? Where is it? What’s it for?
I was lucky enough […] Continue Reading…
PASS Summit and MVP Summit 2015
I’m currently sitting in Seattle-Tacoma airport waiting for BA048 to take me home, and coming to terms with what an amazing couple of weeks I’ve been fortunate to have.
The […] Continue Reading…
MDX Compare or Rank Similar Members
Or should this be called: “Recreating DAX’s EARLIER function in MDX” – either way, a useful technique that solves a problem…
MDX makes it very easy for us to compare […] Continue Reading…
Excel crashes when enabling macros
I’ve had a problem with Excel 2013 crashing a number of times when opening/editing spreadsheets with macros. When I click ‘Enable Content’ to enable macros, the Excel window fades […] Continue Reading…
First thoughts on DataZen
Following the recent announcement of Microsoft acquiring DataZen, I’ve been having a play around to see what it can and can’t do. Here’s a very brief summary so far:
The […] Continue Reading…
Excel creates inefficient MDX
Whilst investigating a slow set of Excel pivot tables (connected to a multidimensional SSAS cube), I found some odd behaviour in how Excel generates its MDX, sometimes doing far […] Continue Reading…
Microsoft Acquires Datazen
Exciting news in the Microsoft Analytics space. On 14th April 2015 Microsoft announced they are acquiring Datazen – what does this mean, and is it a good or a […] Continue Reading…
New Azure User Group in Birmingham
We’re launching a new Azure user group in Birmingham, UK! The first session is on Thursday 16th April, 6.30pm at the MAC (Midlands Art Centre) next to Edgbaston Cricket […] 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 |  |
