November 2007 Entries

SSAS 2008: Aggregation Designer take 2
One of my statements in my last post about the new Aggregations tab was not entirely accurate... I stated that to edit aggregations you would still need BIDSHelper, but as I have recently seen demonstrated and as a sharp eyed Greg Galloway has noticed - there is an Advanced View button which lets you do just that from within BIDS. One of the interesting features it has is a status row that exposes the AMO warnings. There was a bit of a lag when I was testing it which meant that it was hard to tell ......

Posted On Wednesday, November 21, 2007 7:55 AM | Comments (0)

Announcing the release of PowerSSAS: a PowerShell provider for Analysis Services
Anyone who has been reading this blog for a while will know that I was quite taken with PowerShell when it was released and was even playing with it back when it was only known by it's code name of "Monad". Well, back when it was still known as Monad, I started experimenting with writing a provider for Analysis Services. It was one of those side projects that I was toying with in my spare time and I kept telling myself that I just need to add one or two more features and then it would be ready for ......

Posted On Monday, November 19, 2007 11:24 PM | Comments (9)

SSAS 2008: New Cube Aggregations tab
The November CTP of SQL Server 2008 was released on the connect MSDN Downloads site at the end of last week and when you open up a cube in BIDS you will see a new tab for aggregations. I figured I might give you a bit a walk through what you can expect from this new tab. What this tab does is to let you see all the aggregation designs that relate to a given measure group. It also lets you manage which partitions are using a particular aggregation design. As with the other Analysis Services designers, ......

Posted On Sunday, November 18, 2007 7:18 PM | Comments (3)

Announcing the release of BIDSHelper 1.2 - now with SSIS functionality
The BIDS Helper team are please to announce the release of v1.2. You can get it here And just to give you an idea of what BIDS Helper can offer you, here is a montage of some of the features. The most exciting thing about this release is that it incorporates a number of SSIS features. I won't go into the individual features too much, they are all documented on the web site. Below are links for all of the major new features. Analysis Services Column Usage Reports Delete Unused Aggregations Deploy ......

Posted On Saturday, November 17, 2007 2:38 PM | Comments (0)

Australian PerformancePoint 2007 launch event / Microsoft Business Intelligence Summit 2007
Nick Barclay posted last week about the Australian launch events for Performance Point. These are free events so follow the links and register if you are in Melbourne (Nov 28) or Sydney (Nov 29). However these events are a bit broader (see the agenda) than just a PerformancePoint launch, if you go to the registration site, you will notice that the event is actually titled as "Microsoft Business Intelligence Summit 2007" - it's interesting to have to hear about something like this from Nick's blog ......

Posted On Wednesday, November 14, 2007 9:02 AM | Comments (0)

SSAS: What changes would you like to see?
Kevin posted an interesting comment to my last post about how to setup HTTP authentication on Windows Vista and that was that this sort of thing should be built into SSAS itself. While this is not a bad idea, I don't know if it would be high on the list of things that I would like to see added to SSAS. I don't have a written list as such, but here are few things off the top of my head that I would like to see in future versions. After I compiled this list I searched the connect site and added links ......

Posted On Sunday, November 11, 2007 8:55 PM | Comments (2)

SSAS: Connecting via HTTP on Windows Vista
Microsoft has a couple of articles on how to set up HTTP connectivity for SSAS, one for Win XP http://www.microsoft.com/te... and another for Win2003 server http://www.microsoft.com/te... But Vista Business/Ultimate includes the new version of IIS (IIS 7) which means some of the steps have changed a little. So let's walk through the process with the help of a few screen shots. Getting binariesCopy the contents of the %Installation ......

Posted On Sunday, November 4, 2007 11:17 PM | Comments (15)