Use Stored Procedure Output Parameters in SSRS
It’s commonly known that there are a few frustrations when using stored procedures as the source for SSRS 2005 datasets, the inability to cope with temporary tables is always […] Continue Reading…
Ranking results from MDX queries
This post explains how you can create a ranking of data from an OLAP MDX query. This will take the results from the query, and assign a ranking to […] Continue Reading…
SSRS Report Performance monitoring
Today’s Frog-Blog top-tips are quite simple ones, but ones that I always find very useful. SSRS Report Performance monitoring.
Once you start to build up a few Reporting Services reports, […] Continue Reading…
Semi Additive Measures using SQL Server Standard
One of the most frustrating limitations of SQL Server 2005 Standard edition is that it doesn’t support semi additive measures in SSAS Analysis Services cubes. This post explains a […] Continue Reading…
Sky Anytime – Killing Kontiki
I think it’s about time for a good old rant. Nothing to do with Business Intelligence, but…
Anyone out there who uses Sky Anytime (and I believe the BBC iPlayer) […] Continue Reading…
Extract Datasource and Query from Excel Pivot
Have you ever tried to reverse engineer an Excel pivot table? It’s not as easy as you would think! Whether you just want to find out the datasource details, […] Continue Reading…
Report Parameter Selection Memory
This post explains a method of enhancing Reporting Services reports to make them more user friendly. I have been quizzed many times by end users who want reports to […] Continue Reading…
Open SSRS report in a new Window
There isn’t yet a built-in facility within Reporting Services to open a report link (i.e. a drillthrough report) in a new browser window or tab, however it isn’t too […] Continue Reading…
Excel Addin for Analysis Services
For any users of Analysis Services, if you haven’t already downloaded the Excel (2002/2003) addin you’re missing out.
It’s a free download from Microsoft which significantly expands Excel’s cube querying […] Continue Reading…
Convert MDX fields to SQL
A number of our customers have reporting systems that use both MDX and SQL, retrieving data from both OLAP and SQL Server databases. This generates the problem of converting an MDX […] 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) |  |
| Jeet Kainth |  |
| Jon Fletcher |  |
| Nick Edwards |  |
| Joe Billingham |  |
| Lewis Prince |  |
| Reiss McSporran |  |
