Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

Archive for March 2008

MDX in TM1

leave a comment »

I’m always interested to learn about the different dialects of MDX, and here’s a document on using MDX with TM1:

http://www.bihints.com/book/export/html/68

Thanks to Paul Simon for sending me this…

Written by Chris Webb

March 12, 2008 at 11:12 pm

Posted in TM1

BI Competency Centre Survey

leave a comment »

BARC, the publishers of the BI Survey, have asked me to publicise a new survey they’re doing on BI Competency Centres:

http://bi-institut.de/web/orga_of_BI/

It should only take a few minutes to complete, and they donate €1 to charity for each participant.

Written by Chris Webb

March 12, 2008 at 10:36 pm

Posted in Uncategorized

SQLMS and Connection String Properties

with 2 comments

Simon Sabin has a good list of the new features in SQL Server tools for 2008:

http://sqlblogcasts.com/blogs/simons/archive/2008/03/11/SQL-Server-2008—Whats-new-in-the-tools.aspx

Top of the list is the fact that you will be able to set connection string properties when you connect to AS in SQL Management Studio; it’s not there yet, but I guess it’ll appear in CTP7. This means (sniff) I’ll no longer need MDX Sample App any more…

Written by Chris Webb

March 12, 2008 at 10:17 pm

Posted in Uncategorized

Using Non_Empty_Behavior with YTD Calculations: Katmai Update

with 4 comments

I don’t know why I didn’t think of doing this, but after being prompted by Richard Tkachuk I ran the original query from my post of last week on setting non_empty_behavior for YTD calculations on Katmai CTP6:

with member measures.ytdsales as
sum(
periodstodate([Date].[Calendar].[Calendar Year],[Date].[Calendar].currentmember)
, [Measures].[Internet Sales Amount])
select {[Date].[Calendar].[Month].&[2003]&[12].children} on 0,
non empty
[Customer].[Customer Geography].[Customer].members
*
[Promotion].[Promotion].[Promotion].members
on 1
from [adventure works]
where(measures.ytdsales, [Product].[Subcategory].&[2])

And guess what – it ran in 7 seconds. That’s 7 seconds on a virtual machine on my laptop without that massive extra fact table, and that’s the same time as the optimised query running on AS2005 directly on my laptop with no VM slowing things down; remember that the query above was running in 1 minute 10 seconds on AS2005. That’s impressive.

Written by Chris Webb

March 9, 2008 at 12:01 am

Posted in Uncategorized

SQLBits II

with 3 comments

It was SQLBits II on Saturday, and I just wanted to say thanks to everyone involved for making it yet another massive success: Tony, Simon, Martin, Allan, Darren, Clare Burgess from Microsoft, all the sponsors, all the speakers, all the helpers who volunteered to stuff bumpf into bags on Friday night, type in feedback and other such thankless tasks, and most of all the attendees. As for those of you who signed up, confirmed you were coming and then didn’t (unless you had a good excuse like the trains being messed up), well I’m giving you an extra hard stare right now – if fifteen more of you had turned up then I would have won the attendance sweepstake…

I took a couple of photos on the day but didn’t get around to uploading them onto my laptop before I got on the plane to Switzerland yesterday. When I get home I might post them to the SQLBits group I created on Facebook a few months ago and which has been pretty much dormant ever since; if anyone else has any photos that might be a good place to post them. Martin and Tony certainly took loads of pictures and I’ll see if I can get hold of theirs too.

Next stop DevWeek next week and then PASS Europe in a month’s time. If you going to either of those and see me, say hello!

Written by Chris Webb

March 3, 2008 at 8:56 pm

Posted in Uncategorized

Analysis Services and Trimming

leave a comment »

Interesting post here on the PSS SQL Server Engineers blog on SQL Server working set trim problems:
http://blogs.msdn.com/psssql/archive/2008/03/03/sql-server-working-set-trim-problems-consider.aspx 

There’s also a related KB article here:
http://support.microsoft.com/default.aspx/kb/938486
And a representative blog entry on the subject here:
http://weblogs.asp.net/omarzabir/archive/2007/10/19/a-significant-part-of-sql-server-process-memory-has-been-paged-out-this-may-result-in-performance-degradation.aspx

I’m working with a customer where PSS think this is happening with Analysis Services. Certainly Perfmon shows some massive drops in memory usage for no obvious reason (ie the system is nowhere near the LowMemoryLimit). Something to look out for… I’ll post more details if/when I get them.

Written by Chris Webb

March 3, 2008 at 7:52 pm

Posted in Analysis Services

Follow

Get every new post delivered to your Inbox.

Join 3,302 other followers