Prologika Forums

Making sense of data

April 2010 - Prologika (Teo Lachev's Weblog)

Blogs

Prologika (Teo Lachev's Weblog)

Home

Books

Learn PowerPivot and Analysis Services-Tabular at your own pace with our latest book Applied Microsoft SQL Server 2012 Analysis Services (Tabular Modeling). It is designed as an easy-to-follow guide for learning how to implement BI solutions spanning the entire personal-team-organizational BI spectrum.

Training

We offer onsite and online Business Intelligence classes! Contact us about in-person training for groups of five or more students.

For more information or to register click here!

Syndication

Reporting Services Links

Analysis Services Links

Blog Roll

Archives

Sort by: Most Recent | Most Viewed | Most Commented

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 Iif(IsError([Account].[Accrual Basis].&[30/360]), null, ([Account...

Published Wed, Apr 28 2010 9:59 PM by Teo Lachev

Filed under: Analysis Services
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 functionality as OData services, including SharePoint...

Published Sun, Apr 25 2010 10:57 PM by Teo Lachev

Filed under: SQL Server 2008 R2, ODATA
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 and click Properties. Switch to the Debugging tab and change the...

Published Fri, Apr 23 2010 8:27 PM by Teo Lachev

Filed under: Integration Services
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 this blog once I find out when R2 will be available on MSDN....

Published Wed, Apr 21 2010 11:45 AM by Teo Lachev

Filed under: SQL Server 2008 R2
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 performance. Akshai Mirchandani from the SSAS team was kind enough to share his...

Published Fri, Apr 16 2010 6:34 PM by Teo Lachev

Filed under: Analysis Services
Speaking at Atlanta.MDF

I will be speaking at the Atlanta Microsoft Database Forum group (Atlanta.MDF) on May 10 th in Atlanta, GA . The topic will be What's New in Reporting Services 2008 R2. Given that SQL Server 2008 R2 (aka SQL Server 2010) will be released in May, timing...

Published Wed, Apr 14 2010 9:17 PM by Teo Lachev

Filed under: Events
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, accounts, etc. Even with SSAS 2008 we couldn't much to optimize the queries to render...

Published Tue, Apr 13 2010 9:11 AM by Teo Lachev

Filed under: Analysis Services

Powered by Community Server (Commercial Edition), by Telligent Systems

3DZL:andrewbelon.com

April 2010 - Prologika (Teo Lachev's Weblog)

Blogs

Books

Training

Syndication

Recent Posts

Tags

Reporting Services Links

Analysis Services Links

Blog Roll

Archives

Scope Assignments and Missing Members

Reporting From OData Services

Debugging SSIS Script Tasks on x64

SQL Server 2008 R2 Released to Manufacturing

Using XPerf to Test Analysis Services

Speaking at Atlanta.MDF

Analysis Services I/O Time