Tag Archives: MDX

Prevent SSRS 2008 from Overwriting Datasets

Report development is one of my favorite areas of Business Intelligence and I have to say I’ve been fairly happy with the new interface for SSRS 2008.  Except for when it comes to MDX queries.  Off the top of my … Continue reading

Posted in SSRS | Tagged , , , , , , | Comments Off

[Double Clicking Bracketed Text in SSMS]

I’m a big fan of SQL Server Management Studio; it’s a really great tool with a tremendous amount of functionality.  Lately I’ve been working in the new 2008 version of SSMS and a few days ago I noticed some peculiar … Continue reading

Posted in SSMS | Tagged , , , | Comments Off

How to implement cascading parameters in a SQL Services Reporting Services MDX Report

Background Last week, I needed to prototype a report against an Analysis Services 2005 cube for a client.  The report wasn’t too complicated… I just had the requirement to allow a user to drill down a hierarchy by selecting a … Continue reading

Posted in Uncategorized | Tagged , , | Comments Off

MDX Filters in PPS Monitor

I had a question on how to implement MDX Filters in PerformancePoint Monitor awhile back.  Nick Barclay  provided an answer here. Some samples Nick provided were: 1: [Time].[Fiscal Year].Children and 1: DESCENDANTS( 2: [Geography].[Geography].[All Geographies] 3: ,[Geography].[Geography].[Country] 4: ,SELF_AND_BEFORE) Depending … Continue reading

Posted in Uncategorized | Tagged , , | Comments Off