PowerPivot Configuration Tool
One great enhancement in SQL Server 11 (Denali) is the PowerPivot for SharePoint setup refactoring. Previously, the PowerPivot for SharePoint setup and configuration was included and performed at the end […]
Author Archive for: Prologika
Entries by Prologika - Teo Lachev
Cube vs. VertiPaq Query Performance
This is a big topic and frankly it’s too ambitious on my part to tackle it. Assuming equivalent multidimensional (BISM Multidimensional) and tabular (BISM Tabular) models, I was curious how […]
The Load Balancing Act
I had some fun lately setting up a Reporting Services farm of two SSRS 2008 R2 nodes and a hardware load balancer. We followed the steps in BOL only to […]
PowerPivot and SQL Server Denali CTP3 Release Notes Available
Microsoft published release notes for PowerPivot and SQL Server Denali Community Technology Preview (CTP) 3 Release Notes. This means that the CTP3 release is imminent although the download link is not […]
Applied Analysis Services 2008 and PowerPivot Onsite Class
I am partnering with Data Education to deliver an intensive five-day onsite class on Analysis Services and PowerPivot. The class will be held September 19-23 at the Microsoft Technology Center […]
Using the IF Operator in Scope Assignments
UDM scope assignments are incredible useful because they let you write to the cube space, such as to implement custom aggregation, allocations, currency conversion, data calculations, and so on. Unfortunately, […]
Atlanta BI Record Attendance Last Night
We had a blast light night at Atlanta BI and ran out of space with a record attendance of some 60+ people. This is phenomenal given that we are amidst […]
Performance Considerations for Securing Parent-Child Dimensions
Parent-child dimensions are a very useful feature of Analysis Services to model recursive hierarchies, such as an organizational hierarchy. Recently, I had to apply dimension data security to a parent-child […]
Dimension Data Security and Cube Script
If you have worked with Analysis Services dimension data security for a while, you know that MDX allowed/denied set expressions can become rather complex. You might be tempted to externalize […]
My TechEd 2011 Sessions Available Online
All TechEd 2011 breakout sessions are available online on MSDN Channel9 website. Here the links to mine: Top 10 Reasons to Upgrade to Microsoft SQL Server 2008/R2 Reporting Services Can […]
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.
