May 2008 Entries

We are hiring
My employer, James & Monroe are currently looking for people with strong skills in the Microsoft BI technologies. We are specifically looking for people to work at the Senior Consultant level that have experience with the SQL Server 2005 BI technologies in addition to experience with .Net programming. There is the likelihood of working with PerformancePoint so any experience in that would be advantageous. The role would be based in the Melbourne area so you would either need to live in Melbourne ......

Posted On Friday, May 30, 2008 4:37 PM | Comments (2)

What's New in SQL Server 2008 BI - Melbourne SQL Server User Group - May 20
If you are on the mailing list for the Melbourne SQL Server User Group you will already be aware of this, but I am doing a talk on Tuesday night on the new BI features in SQL Server 2008. You can find the details here: http://www.sqlserver.org.au... If you are going to be in town feel free to drop by and say hello ......

Posted On Saturday, May 17, 2008 2:11 PM | Comments (1)

SSAS: Reporting on Metadata
I had a comment recently on one of my older posts that I did about XMLA which asked about listing cubes in a database and whether the cube is processed and it's size. I have posted about a number of different ways of doing this over the last few years, but I thought I would use this opportunity to consolidate a list all the various ways of doing this that I could think of. Under the covers all these techniques are ultimately issuing some sort of XMLA discover against the SSAS database and returning ......

Posted On Tuesday, May 6, 2008 10:08 AM | Comments (4)

powerSSAS: Listing Role information
After my last post on how to list the aggregations for a given attribute using Powershell and PowerSSAS, miltruenos commented, asked if it was possible to do a similar script to show roles and allowed/denied sets, so here is just such a script. add-PSSnapin powerSSASnew-PSDrive ssas powerssas localhost $roles = gi "\Databases\Adventure Works DW\" ` | % {$_.Dimensions} ` | % {$_.DimensionPermissions} ` | % {$_.AttributePermissions} ` | add-Member ScriptProperty DimensionName {$this.Parent.Parent.Name}-... ......

Posted On Thursday, May 1, 2008 10:29 PM | Comments (3)