Prologika Forums

Business Intelligence to the Masses

March 2009 - Prologika (Teo Lachev's Weblog)

Blogs

Prologika (Teo Lachev's Weblog)

Home

Training

We are excited to offer online Business Intelligence classes – no travel, no hotel expenses, just 100% content delivered right to your desktop! Our first class is Applied Reporting Services 2008. Attend this class for only $799 and get a free paper copy of the book Applied Microsoft SQL Server 2008 Reporting Services by Teo Lachev!

For more information or to register click here!

News

Announcing our latest book Applied Microsoft SQL Server 2008 Reporting Services. It is designed as an easy-to-follow guide for navigating safely the most intricate aspects of the leading reporting platform - SQL Server Reporting Services.

Syndication

Reporting Services Links

Analysis Services Links

Blog Roll

Archives

Sort by: Most Recent | Most Viewed | Most Commented

Excel PivotTable Tabular Reports

Here is a great tip thanks to Greg Galloway who pointed me to the Steve Novoselac's excellent blog . By default, Excel 2007 PivotTable stacks (hierachizes) the attributes on the report even if they are from the same dimension. For example, let's...

Published Tue, Mar 31 2009 5:12 PM by Teo Lachev

Filed under: Analysis Services
Report Builder – Past, Now and Future

The Report Builder technology made its debut in SQL Server 2005. It targeted business users who wanted to author their own (ad-hoc) reports but they were not necessarily technically savvy, meaning that no technical knowledge about database schemas or...

Published Tue, Mar 31 2009 9:21 AM by Teo Lachev

Filed under: Reporting Services
Troubleshooting the SharePoint Add-in for Reporting Services Part 2

Today, a co-worker declared a victory after struggling a few days to get Reporting Services 2008 SharePoint integration mode going on Windows Server 2008 (aka Longhorn). I helped of course J It all started with access denied error when attempting to deploy...

Published Mon, Mar 30 2009 5:03 PM by Teo Lachev

Filed under: Reporting Services, SharePoint
Measures on Rows

Issue : You want an MDX query that returns measures on rows and calculated members on columns. You get The Measures hierarchy already appears in the Axis0 axis error. That's because calculated members added to measures are treated as measures and...

Published Fri, Mar 13 2009 9:26 PM by Teo Lachev

Filed under: Analysis Services
Invisible Cubes

I had a head-scratcher the other day. All of a sudden, SQL Server Management Studio stopped showing the cubes in the dropdown of the MDX Query tab although MDX queries and reports would execute just fine. The Reporting Services MDX Query Designer would...

Published Sat, Mar 7 2009 10:54 AM by Teo Lachev

Filed under: Analysis Services
Speaking at TechEd 2009 USA

One of my TechEd 2009 session proposals got approved. The session is tentatively named Reporting Services 2008 Tips and Tricks, How-to, and Beyond . I am planning to cover solutions to common questions and challenges that span the three phases of the...

Published Sun, Mar 1 2009 10:24 PM by Teo Lachev

Filed under: Reporting Services, Events

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

3DZL:andrewbelon.com

March 2009 - Prologika (Teo Lachev's Weblog)

Blogs

Training

News

Syndication

Recent Posts

Tags

Reporting Services Links

Analysis Services Links

Blog Roll

Archives

Excel PivotTable Tabular Reports

Report Builder – Past, Now and Future

Troubleshooting the SharePoint Add-in for Reporting Services Part 2

Measures on Rows

Invisible Cubes

Speaking at TechEd 2009 USA