Scope Assignments and Missing Members
The Analysis Services server parses the cube script on deploy and complains in case of missing dimension members. You can use the IsError() function to handle missing members, such as […]
Author Archive for: Prologika
Entries by Prologika - Teo Lachev
Reporting From OData Services
Open Data Protocol (OData), previously known as ADO.NET Data Services, is quickly gaining popularity as a web protocol for querying and updating data. A few Microsoft products already expose their […]
Debugging SSIS Script Tasks on x64
A coworker of mine complained that Integration Services doesn’t let you debug script tasks on x64. I found an easy workaround to disable the x64 runtime. Right-click the project node […]
SQL Server 2008 R2 Released to Manufacturing
Robert Bruckner announced that SQL Server 2008 R2 was released to manufacturing today. Robert summarized the most important most features. I covered them in my blog as well. I’ll update […]
Using XPerf to Test Analysis Services
I have to admit that I am a performance buff. In a previous blog, I mentioned that the Xperf utility can help you gain additional understanding about the Analysis Services […]
Speaking at Atlanta.MDF
I will be speaking at the Atlanta Microsoft Database Forum group (Atlanta.MDF) on May 10th in Atlanta, GA . The topic will be What’s New in Reporting Services 2008 R2. […]
Analysis Services I/O Time
A couple of years ago I was working on a KPI dashboard project where we had to display a bunch of KPIs produced by counting (distinct count) number of customers, […]
Feeding Reports by Code
In a previous blog, I introduced one of the new SSRS 2008 R2 feature: reports as data feeds. As I said, the R2 release will include a new Atom Data […]
Remembering Report Parameters
Scenario: You want to let end users view a report in Report Manager or SharePoint and “remember” the report parameter selection. You find that you cannot just tell the users […]
Product Release Galore
Microsoft announced release dates for SQL Server R2, SharePoint 2010, Office 2010, and Visual Studio 2010. According to the Microsoft SQL Server Team Blog: SQL Server 2008 R2 (aka SQL […]
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.
