Devin Knight
Archives: March 2011
SQL Saturday #74 Jacksonville
For the 4th year SQL Saturday comes to Jacksonville, FL this year on April 30, 2011. Many of you already know about these events but just to remind you it is a totally FREE all day event that brings top speakers to you.
I hope everyone already realizes this, but… Read more
0 comments, 1,482 reads
Posted in Devin Knight on 30 March 2011
SSAS - Measures or Attributes in Multiple Display Folders
I had a client recently show me a neat little tip that I thought I would share. In the cube he was designing he had the need for measures to show under multiple display folders. For example, he had a Sales Amount measure and he wanted it to be in… Read more
1 comments, 1,257 reads
Posted in Devin Knight on 22 March 2011
Passing Values into an SSIS Package at Runtime from Outside the Package
SSIS provide several methods for passing values into your packages at runtime. The benefit of doing so allows you to change the results of the package without having to even open the package in the development environment (BIDS).
The typical way of doing this is to create variables inside your… Read more
8 comments, 28,344 reads
Posted in Devin Knight on 14 March 2011
SSAS – Changing the Dimension ALL Member Name
All Analysis Services dimensions have a default All member that represents all the members for a particular attribute. For example, let’s say you have a product dimension with an attribute for the product name. This attribute will be given an All member that represents every product. The All member has… Read more
0 comments, 2,120 reads
Posted in Devin Knight on 7 March 2011