Category Archives: SSRS

End-User Microsoft BI Tools – Clearing up the confusion

Given two types of underlying data sources (a data warehouse and a OLAP cube built from the data warehouse) there are many different possible presentation layers (client tools) that serve different user communities with varying usage profiles.  There is a … Continue reading

Posted in Excel, PerformancePoint, Power Pivot, Power View/Project Crescent, ProClarity, Report Builder, SQLServerPedia Syndication, SSRS, White Paper | 2 Comments

Complex reporting off a SSAS cube

While using a cube in SSAS is usually a great source for reporting, it is not always the best choice.  Sometimes it is better to report off of the data warehouse that the cube is built from. For example, say … Continue reading

Posted in Data warehouse, SQLServerPedia Syndication, SSAS, SSRS | 10 Comments

BIDSHelper 1.5 for SSAS, SSIS, SSRS released

BIDS helper is Visual Studio add-in with features that extend and enhance the functionality of the SQL Server 2005 and SQL Server 2008 BI Development Studio.  Version 1.5 can be downloaded here, and read up on the new features. It’s a must-have … Continue reading

Posted in SQLServerPedia Syndication, SSAS, SSIS, SSRS, Tools, Visual Studio 2008 | Comments Off on BIDSHelper 1.5 for SSAS, SSIS, SSRS released

Watch out, Visual Studio 2010 does not support BI

When Visual Studio 2010 was released about a year ago, I was very excited and wanted to quickly open up a SSAS project created in VS 2008 to see the new features that were available in VS 2010.  So I copied … Continue reading

Posted in Business Intelligence, SQL Server, SQLServerPedia Syndication, SSAS, SSIS, SSRS, Visual Studio 2008, Visual Studio 2010 | 4 Comments