Prologika Forums

Making sense of data

Prologika (Teo Lachev's Weblog) » All Tags » Analysis Services (RSS)

Browse by Tags

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

Attend One BI Training Class - Get One Consulting Hour Free!

I am back from vacation in Florida and I am all rested despite the intensive sun exposure and the appearance of some tar from the oil spill. I have scheduled the next two runs of my online training classes: Applied Reporting Services 2008 Online Training...

Published Sun, Jun 6 2010 10:45 PM by Teo Lachev

Filed under: Reporting Services, Analysis Services, Business Intelligence, Training
In Search of Aggregations

The other day I decided to spend some time and educate myself better on the subject of aggregations. Much to my surprise, no matter how hard I tried hitting different aggregations in the Internet Sales measure group of the Adventure Works cube, when I...

Published Sat, May 22 2010 4:15 PM by Teo Lachev

Filed under: Analysis Services
To Partition or Not – This is the Question

As Analysis Services users undoubtedly know, partitioning and aggregations are the two core tenants of a good Analysis Services data design. Or, at least they have been since its first release. The thing though is that a lot of things have changed since...

Published Fri, May 21 2010 7:29 PM by Teo Lachev

Filed under: Analysis Services
Online Analysis Services 2008 Class on May 17th

There is still time to register for the online Applied Analysis Services 2008 class run on May 17th . No travel, no hotel expenses, just 100% content delivered right to your desktop! This intensive 3-day online class (14 training hours) teaches you the...

Published Fri, May 7 2010 12:22 PM by Teo Lachev

Filed under: Analysis Services, Business Intelligence, Training
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
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
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
Beware Hidden Calculated Members

Here is another one of those "by design" issues (see the Not All Calculated Members Are Born Equal blog for another recent gotcha) that are not documented but can sure waste you precious time figuring out. The issue was first submitted on connect...

Published Mon, Jan 18 2010 6:06 PM by Teo Lachev

Filed under: Analysis Services
Most Requested Features

You can use the Microsoft Connect website to find most requested features. Unfortunately, the search doesn't let you specify a product so the search results may be related to other products. For example, searching on reporting services may bring in...

Published Mon, Dec 21 2009 4:06 PM by Teo Lachev

Filed under: General, Reporting Services, Analysis Services
Infragistics Silverlight for Analysis Services

Don Demsak pointed out another Silverlight-based control from Infragistics, which is currently in a CTP phase. There are actually two controls: XamWebDataChart and XamWebPivotGrid. I played a bit with it and it looks great. I liked the Excel-like paradigm...

Published Wed, Dec 9 2009 5:11 PM by Teo Lachev

Filed under: Analysis Services
Analysis Services Top 10 Wish List

Analysis Services leads the OLAP server market and it should be your platform of choice for historical and trend reporting. In the spirit of the season, here is my Top 10 Wish List for Analysis Services. All items are related to regular cubes and none...

Published Mon, Dec 7 2009 1:27 PM by Teo Lachev

Filed under: Analysis Services
Expert Cube Development with Analysis Services 2008

Now that I've got my copy and read it, I can say a few things about the book Expert Cube Development with Microsoft SQL Server 2008 Analysis Services by Chris Webb, Alberto Ferrari, and Marco Russo. As mentioned in another post , the authors (all...

Published Wed, Dec 2 2009 9:00 AM by Teo Lachev

Filed under: Analysis Services, Business Intelligence
Not All Calculated Members Are Born Equal

An interesting issue popped up yesterday regarding the calculated member syntax. I had to multiply negative amounts in a financial cube for certain account categories that had negative amounts. The cube also had a Many:Many relationship between financial...

Published Fri, Nov 13 2009 9:30 AM by Teo Lachev

Filed under: Analysis Services
Where is the SSAS 2008 Book?

Readers have been asking about a revised edition of my Applied Microsoft Analysis Services book for version 2008. First of all, I'd like to thank all my readers who bought and liked the book. This book has been a great success and it really exceeded...

Published Tue, Nov 10 2009 5:50 PM by Teo Lachev

Filed under: Analysis Services
SQL Server 2008 R2 November CTP (CTP3)

Microsoft announced release on SQL Server 2008 R2 November CTP (CTP3) with a build number of #1352.12. MSDN, TechNet Subscribers and TAP customers can download the SQL Server 2008 R2 November CTP today. Non-subscribers will be able to access the CTP on...

Published Mon, Nov 9 2009 10:13 PM by Teo Lachev

Filed under: Reporting Services, Analysis Services, SQL Server 2008 R2

1 2 3 4 5 Next > ... Last »

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

3DZL:andrewbelon.com