May 2009 Entries

I am happy to announce that we recently put out a new release of BIDS Helper. I have copied the release notes out below, but one important "feature" that is not listed is that we now have a build script which is a modified version of the psake Powershell build script written by James Kovacs. It had gotten to the point where it was a bit of an effort to do a build. You had to start by making sure you had the latest version of the source code, then version number had to be updated in a number of spots, ......

Share This Post:
Short Url: http://wblo.gs/YMV

I was experimenting with some of the PerformancePoint APIs today, but I was doing something wrong as I kept getting ERROR! back. I assumed that some of the parameters that I was using was resulting in invalid MDX being generated. I was running against a test database on SSAS 2005 and as I suspected there was a syntax error in the MDX. Unfortunately Profiler against SSAS 2005 showed me the error, but not the offending MDX, which was not much help. On a whim I decided to move my test database to SSAS ......

Share This Post:
Short Url: http://wblo.gs/YLt

This question came a while ago now in this SSAS forum thread: What is wrong in my query and I thought it was something that may interest other people. Basically it boiled down to trying to find a T-SQL equivalent to the following MDX which is querying a dimension with a many-to-many relationship to the measure. So given the following simple MDX query, what would be the equivalent in SQL? select measures.[Internet Sales Amount] on 0 , [Sales Reason].[Sales Reasons].[Reason Type].Members on 1 FROM ......

Share This Post:
Short Url: http://wblo.gs/YFz

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.

NetworkedBlogs

Blog:

Random Procrastination

Topics:

MDX, SQL Server, BI

Follow my blog

Twitter

darrengosbell @blu3S41l0r It's really a new capability of MD not Power View, so yes, Dax Studio will work with MD servers running SQL 2012 CU 4 or later about 13 days ago

darrengosbell @mtydeman sorry, was not on twitter last week. Yes, SSAS MD works well with snowflakes. The joins are resolved during dimension processing about 37 days ago

darrengosbell SSAS: Clearing the MDX Script for a session in SSMS http://t.co/jioE6bQO about 137 days ago

darrengosbell SSAS: Executing MDX Scope statements using SSMS http://t.co/Tpx9pfoz about 182 days ago

darrengosbell @MitchDenny thanks - I had a ball, #powerview is such a cool thing to demo about 273 days ago

darrengosbell @asantaballa @jenstirrup daxeditor is not me, that's an MS sample. I'm working on http://t.co/b1JsRLps at the moment about 330 days ago

darrengosbell @Technitrain I can see it too about 330 days ago

darrengosbell @jppp I hope you enjoy the 2012 release :) life's been pretty good - too busy, but still good. about 455 days ago

darrengosbell BIDS Helper 1.6 Beta Release (now with SQL 2012 support!) http://t.co/dSWkG7PI about 455 days ago

darrengosbell @Kjonge just showed that in post-ctp3 #denali #Dax in #ssas will have query plans as profiler events about 613 days ago

Darren Gosbell [MVP] - Random Procrastination

Business Intelligence, SQL Server, .Net, Powershell and MDX Madness

May 2009 Entries

BIDS Helper release 1.4.1

An Analysis Services 2008 nugget

SSAS: T-SQL Equivalent for a Many-to-Many relationship

News

Twitter

Tag Cloud

Article Categories

Archives

Post Categories

.Net Blogs

Aussie Bloggers

BI Blogs

CMS Blogs

Syndication: