Performance Improvements for MDX in AS 2008
Here is a useful page from the SQL Server 2008 BOL that summarizes the SSAS performance improvements in Katmai pretty well. It also shows which functions are optimized. For example, […]
Author Archive for: Prologika
Entries by Prologika - Teo Lachev
Radius Producer "Produces" No-nonsense SSAS Support
In my opinion, the biggest challenge the Microsoft BI initiative faces today is the inadequate support for Analysis Services. The premimum Microsoft reporting tools claim to support SSAS but they […]
SQL Server 2008 November CTP Is Out
The November CTP (CTP5) of SQL Server 2008 is out. Here are the most significant BI-related highlights that caught my attention. Reporting Services The standalone Report Designer has undergone a […]
Parameterized Parameter Prompts
One new SSRS 2008 feature that international users will undoubtedly appreciate is parameterized parameter prompts. Previously, the parameter prompts were static. In SSRS 2008, you will notice the familiar function […]
NEB Revenge in Katmai
An advanced SSAS performance-related feature is Non Empty Behavior (NEB) which has been discussed in many places including this Mosha’s blog. The issue with NEB in SSSAS 2005 is that […]
Protect UDM with Dimension Data Security Reloaded
SQL Server Magazine published the second part of my Protect UDM with Dimension Data Security article in the October issue of the magazine. In this article, I explain how to […]
Scale-Out Querying with Analysis Services Using SAN Snapshots
If your organization can afford SAN, here is another best practices article by Carl Rabeler from the SSAS team. The Scale-Out Querying with Analysis Services Using SAN Snapshots article “describes […]
MCTS Self-Paced Training Kit (Exam 70-445): Microsoft SQL Server 2005 Business Intelligence—Implementation and Maintenance
Those of you preparing for Microsoft exam 70-445 Microsoft SQL Server 2005 Business Intelligence – Implementation and Maintenance may be interested to know that Microsoft Press has just published a […]
SSRS 2008 Variables
As I mentioned in my Under the Hood post, the SSRS 2008 engine has been redesigned to perform on-demand report processing for better scalability. As a result, textbox values are […]
Under the Hood
One of the major themes in SSRS 2008 is scalability. A significant effort will be made to ensure that SSRS scales well with large reports. Why is this needed? Recall […]
Follow Us
Prologika is a boutique consulting firm that specializes in Business Intelligence consulting and training. Our mission is to help organizations make sense of data by applying effectively BI technologies.
