Monthly Archives: September 2007

www.proclarity.com

It’s Friday afternoon, so I decided to check out http://www.proclarity.com.   Looks like MS finally made Proclarity their own…

Posted in Uncategorized | Leave a comment

Calling AMO code within a SSIS package

We execute our AMO code within SSIS packages by calling a custom written DLL (registered in c:\windows\assembly). Originally, I wanted to call the code via a SSAS stored procedure, however it did not handle transactions like I wanted them to.  Calling the AMO … Continue reading

Posted in Uncategorized | Leave a comment

Realtime BI

  A blogging by the CTO here about the frequency of our data loads. http://smithkl42.blogspot.com/2007/06/realtime-bi.html   "It can be tempting to sit in front of ProClarity and hit "Refresh" all day long, waiting for the latest revenue or install numbers … Continue reading

Posted in Uncategorized | 1 Comment

Partition Slice Impact on Query Performance – SSAS2005

I’ve been going through a case with MS and ths issue of setting a partition slice came up. Based on what I read here, http://msdn2.microsoft.com/en-us/library/ms174764(SQL.90).aspx, I didn’t think that the slice had any impact on MOLAP data. The article states: … Continue reading

Posted in Uncategorized | 2 Comments