Tag Archives: MDX

Prevent SSRS 2008 from Overwriting Datasets

Posted on September 13, 2010 by Melinda Cole

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 on Prevent SSRS 2008 from Overwriting Datasets

[Double Clicking Bracketed Text in SSMS]

Posted on July 10, 2009 by Melinda Cole

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 on [Double Clicking Bracketed Text in SSMS]

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

Posted on May 18, 2008 by ddarden

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 on How to implement cascading parameters in a SQL Services Reporting Services MDX Report

MDX Filters in PPS Monitor

Posted on April 26, 2008 by ddarden

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 on MDX Filters in PPS Monitor