Tag Archives: SSAS

BIDS Helper 1.5 Is Available!

BIDS Helper 1.5 Released Continue reading

Posted in SSIS | Tagged , , , | Comments Off on BIDS Helper 1.5 Is Available!

Tuning SSAS Processing Performance

Guide to tuning SSAS processing performance Continue reading

Posted in SQL Saturday, SSAS | Tagged , | Comments Off on Tuning SSAS Processing Performance

Using MSBuild with SQL Server Analysis Services Projects

I’ve written several blogs and community samples on working with SSAS Projects directly using AMO (instead of SSAS Databases on an Analysis Services server).  I was travelling this weekend, and got a chance to create a sample MSBuild task that … Continue reading

Posted in Uncategorized | Tagged , | Comments Off on Using MSBuild with SQL Server Analysis Services Projects

Validating SSAS Projects Programmatically

Earlier this week I got a feature request from someone someone that was looking in to my SsasHelper sample on the Microsoft SQL Server Community Samples:  Analysis Services site on CodePlex.  She was interested in Building a SQL Server Analysis … Continue reading

Posted in Uncategorized | Tagged , | Comments Off on Validating SSAS Projects Programmatically

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

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

Retrieving Information from Active Directory with SSIS

I was recently asked to help someone retrieve information from Active Directory for use in SSIS. My initial thought was “This shouldn’t be too difficult. I know there is an OLE DB driver for Active Directory, so it should just … Continue reading

Posted in Uncategorized | Tagged , | Comments Off on Retrieving Information from Active Directory with SSIS