For any users of Analysis Services, if you haven’t already downloaded the Excel (2002/2003) addin you’re missing out. It’s a free download from Microsoft which significantly expands Excel’s cube querying ability. Well recommended! Get it here…
» Read moreA number of our customers have reporting systems that use both MDX and SQL, retrieving data from both OLAP and SQL Server databases. This generates the problem of converting an MDX field ([Dimension].[Hierarchy].&[Attribute]) into SQL Server field value (Attribute). The following code is a Reporting Services custom code section that will rip off the MDX and leave you with the value. Public Function MDXParamToSQL(Parameter As String,…
» Read moreIt really wouldn’t be fair to kick off the Frog-Blog without a shout out to Chris Hays and his superb ‘Sleazy Hacks’ site. If you want to push SQL Server Reporting Services further than anyone else, then Chris will definately have something of use to you. He designed the RDL report language – the guy knows what he’s talking about. blogs.msdn.com/ChrisHays
» Read moreWell, what can I say – the very first Frog-Blog post. Keep checking back often for new and (hopefully) useful info… Alex
» Read more
