Empty Affairs
If you have a cube with large dimensions you may have come across the following error: The expression contains a function that cannot operate on a set with more than […]
Author Archive for: Prologika
Entries by Prologika - Teo Lachev
SQL Server 2008 (Katmai) to Launch February 28th 2008
From the latest MS press release “In anticipation for the most significant Microsoft enterprise event in the next year, Turner announced that Windows Server 2008, Visual Studio 2008 and Microsoft […]
SSRS Setup Woes
I was setting up Reporting Services 2005 today on a clean Windows XP machine and I came across the infamous error: The report server has encountered a configuration error. See […]
How to install SQL Server 2005 Reporting Services on a Windows Vista-based computer
I spent a couple of hours today trying to get SSRS 2005 working on Vista. I was getting the infamous IIS 500 error when browsing the Report Manager (http://localhost/reports) and […]
Analysis Services Query Performance Top 10 Best Practices
I came across this little gem which I haven’t noticed so far. A nice summary of the 10 things you should do to optimize the UDM query performance. The best […]
Protect UDM with Dimension Data Security
SQL Magazine published the first part of my article Protect UDM with Dimension Data Security in its July issue. This article explains the fundamentals of dimension data security. I am […]
Trust Relationships
If you use VS.NET deployment to deploy your SSAS project from one domain to another, you may get the following obscure error message on deploy. The trust relationship between the […]
Aggregate Rows and SP2
Back to my When (null) is not Null post, there is a undocumented breaking change in SQL Server 2005 SP2 which you should be aware of. In response to the […]
TechEd 2007 US Memoirs
I am back from an one-week vacation to Clearwater, Florida followed by TechEd 2007 US in Orlando. Overall, nothing earth – shattering on the BI arena from TechEd 2007. Product […]
A Couple of Report Builder – UDM Hacks
If you target the SSRS Report Builder as an UDM client you may find the following two workarounds (aka hacks) useful. Both hacks require manually updating the SMDL definition. Alas, […]
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.
