Named sets are simply MDX expressions defined with an alias that return a set of members. If you find yourself writing complex MDX expressions to return a set of members often or if you have a commonly used expression, consider creating a named set. This will prevent you from having to duplicate your work. To create a named set, open your SSAS project and head to the Calculations tabs. Find the icon with the curly brackets and click it. Give your named set a name. For this example, I'm using the...
Read More
Last week it was announced that Pragmatic Works' tool, BI xPress , won the SQL Server Magazine Gold Editors Choice Award for Best Business Intelligence and Reporting Tool and the Silver Community Choice Award. BI xPress allows for real time monitoring of all your SSIS packages executing on your servers. The way that BI xPress can allow you to monitor your SSIS package in real time is by applying a standardize auditing framework across all of your SSIS package using the BI xPress Auditing Framewo...
I get lots of questions about how to implement various types of calculations in a cube so I figured I'd cover some of the more commonly used calculations I run into on a regular basis. All of these example calculations I'll be providing were written against the Adventure Works 2008 R2 example cube. 10. YTD, QTD, and MTD Calculations These kinds of calculations are pretty common and I see these in a lot of cubes. They're pretty easy to wire up since there are only a couple simple MDX functions ne...
If the organizations you've worked with are anything like the ones I've had the pleasure of working with, then they probably had or have thousands of SSRS reports spread out all over the place. And back around the time a majority of companies were gearing up to migrate to SQL 2008 from 2005, getting a grasp on the number and complexity of these reports was quite a challenge. This is just the scenario where BI Documenter really shines. Besides being able to document your SQL databases, SSIS packa...
Thanks to everyone who attended my session, Reporting on a Cube with SSRS 2008. I had a great time at the event and I hope those who attended enjoyed the great sessions and maybe even learned a couple things. If you're interested, here is the link to download my slide deck and examples I used during the session. In my example, I used the Adventure Works 2008 R2 cube, so head over to Codeplex to pick up the materials . Also, here is the link to Mosha Pasumansky]s MDX Studio Online tool that will ...
The native SSIS functionality currently prevent you from performing a batch update from a Data Flow Task without staging the data. If you wish to update records from within the Data Flow Task, you're going to have to use the OLE DB Command transform, which is very slow. If you're update more than just a few records, I'd highly recommend first staging the data and then using an Execute SQL Task to perform the batch update. Or you could just use the Task Factory Update Batch Transform from Pragmat...