Earlier this month the latest version of BI xPress was released. There are several new features in this latest release of BI xPress, but one of the coolest is the SSRS Performance Monitoring. The BI xPress SSRS Performance Monitor has four performance monitoring panels. Average Run Time The Average Run Time panel displays the average … Continue reading
The MDX function, Descendants, is a very versatile and commonly used function that returns the members at, below, or even above a specified level. The first argument of the descendants function is a member or set expression. The second argument can either be a specific level expression or a number indicating the number of levels … Continue reading
Regular Expressions are a powerful way for you to search for patterns in strings of text. In SSIS, we can leverage Regular Expressions to assist us in cleansing data. I’m going to show you a couple different ways we can accomplish this task. The first method involved using a Script Component within a Data Flow … Continue reading
One of the nice things about a stepped report is that the child groups are displayed beneath the parent groups but within the same column as the parent group. In the next several steps, I’m going to walk through creating a basic stepped report using the Tablix data region. I used the Matrix data region … Continue reading
