Chris Webb's BI Blog

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

Archive for February 2007

Essential Sharepoint 2007

leave a comment »

Now I know pretty much nothing about Sharepoint; just about all I do know is that since it’s playing a big role in Microsoft’s BI strategy I ought to find out more about it. Mauro Cardarelli blogs about BI from the Sharepoint point of view and has just announced that he and his co-authors have just finished a book, "Essential Sharepoint 2007":
Looks like it’s pitched at the right level for someone like me, and it has a chapter on "Providing Business Intelligence" too. I’d better put it on pre-order at Amazon. 

Written by Chris Webb

February 3, 2007 at 10:25 pm

Posted in Books

Crossjoin function now takes more than two parameters

with 3 comments

Crossjoin is a function which, for obvious reasons, is dear to my heart. It’s been at least a year since I last found a feature in AS2005 MDX that I wasn’t aware of, but the other day I found out that the Crossjoin function can now take more than two sets as parameters, much in the same way that NonEmptyCrossjoin can. Here’s an example:
 
select
measures.[internet sales amount] on 0,
crossjoin(
[Date].[Day Name].[Day Name].members,
[Date].[Day of Week].[Day of Week].members,
[Product].[Color].[Color].members
)
on 1
from [Adventure Works]
 
Not exactly revolutionary (and anyway I use the * operator instead nowadays) but fun to note.

Written by Chris Webb

February 2, 2007 at 11:36 am

Posted in MDX

Follow

Get every new post delivered to your Inbox.

Join 3,113 other followers