SSAS Reporting Action with Date Parameters
Reporting Actions in Analysis Services allows you to open a report in Reporting Services. Most of the time users want...
2014-01-22 (first published: 2014-01-20)
2,242 reads
SSAS – Using the Euro or Pound currency Symbol in a measure Format String
If you have a set of measures and some of them are US dollars, some are Euros, and some are...
2014-01-17 (first published: 2014-01-13)
2,041 reads
SSAS Dynamic KPI from a table
KPI’s (Key Performance Indicators) in Analysis Services are a great way to show visually if a measure is above or...
2014-01-09 (first published: 2014-01-06)
2,590 reads
SSIS For Loop Skip Files
When running a For Each Loop through a set of files, sometimes you will have specific files that you do...
2013-12-30 (first published: 2013-12-23)
2,676 reads
SSRS Interactive Sorting a Matrix
Sorting a matrix report can be done interactively. To perform interactive sorting, your report you will need a cell to...
2013-12-30
1,853 reads
Setting up Security on sub sites in SharePoint 2010
A lot of companies have several departments and want to limit the sub sites users can view. For example, the...
2013-12-20 (first published: 2013-12-16)
1,541 reads
SSAS – Setting Attributes as Properties for Excel
When a user is browsing your cube with excel they may not understand how to slice the data and end...
2013-12-09
1,252 reads
SSRS – Self Referencing Reports or Drill through to same report
When looking at a report and wanting to drill through to get more detail, we often create two reports for...
2013-12-04 (first published: 2013-12-02)
2,988 reads
Reverse or Mirrored Bar Chart in SSRS
There are some pretty charts out there and most of them can be done in Reporting Services. There is one...
2013-11-25
1,181 reads
SSIS Execute SQL error – No disconnected record set is available
If you get the error in SSIS that says:
…failed with the following error: “No disconnected record set is available for...
2013-11-18
2,504 reads
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
Purpose of the Rice Purity Test
The main purpose of the Rice Purity Test is entertainment and self reflection. Many...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers