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 ......

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 ......

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 ......

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}-... ......

News

About Me
I am a consultant, based in Melbourne Australia. I primarily work in the Business Intelligence area with SQL Server, although I also dabble in Content Management Server and .Net coding

Contact Me

MVP

Legal
Any and all code, software, examples, suggestions and anything else on this web site is available for you to use at your own risk. No warranty is expressed or implied.
Views and Opinions
The views and opinions expressed on this web site are not necessarily the views or opinions of my employer.

Subscribe in Bloglines Subscribe in NewsGator Online
Locations of visitors to this page

Twitter












Tag Cloud


Article Categories

Archives

Post Categories

.Net Blogs

Aussie Bloggers

BI Blogs

CMS Blogs

Syndication: