Category Archives: ProClarity

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

Performance tips for SSAS

Over the past few years I have developed a list of ways to improve performance in SSAS and in two of the tools that use it: ProClarity and PerformancePoint.  Below are those performance tips along with other important items to be … Continue reading

Posted in PerformancePoint, ProClarity, SQLServerPedia Syndication, SSAS | 3 Comments

Tools to make creating MDX much easier

For those of you who use MDX, I’m sure you share my opinion that MDX is a lot harder to master than SQL.  One trick I have learned is that instead of trying to write MDX from scratch, use one … Continue reading

Posted in MDX, ProClarity, SQLServerPedia Syndication | 4 Comments