OWC scans all partitions (SSAS 2005)

Hello,

I have a cube with three partitions. Each partition holds data for the years 2005,2006 and 2007 respectively. In our web application we are creating OWC Pivot Table and putting "date dimension" in the filter area automatically. Altough only "2007-01-01" is included in filter, when we trace the query from profiler we saw that all partitions are read. Is there anyone encountered the same thing?

By the way, storage modes for all partitions are MOLAP.

Nilgun Celikok

Hi Nilgun,

First of all, have you set the Slice property on your partitions? Although in general AS is able to detect what data is in each partition, read the following article for details on when it will and won't work:

http://blogs.msdn.com/sqlcat/archive/2007/03/05/ssas-partition-slicing.aspx

In your case it sounds like it will be quite straightforward to set the slice, and this will also detect whether your partitions hold the data you think they hold (which could be another reason why you're seeing AS scan all partitions).

If you have set the slice, however, you could be running into an issue I've seen before and which I think is fixed in the latest cumulative hotfix build for SP2:

http://support.microsoft.com/kb/936305

Look for the brief description under issue 50000890.

HTH,

Chris

OWC and SSAS 2005

So I am about to impliment my intranet site with my pivot table reports that conect to SSAS2005 cubes, I am just curious if anyone knows the minimum requirements that need to be installed on the client for them to be able to view the report. I know they need msxml6.msi and SQLServer2005_ASOLEDB9.msi installed but what version of office web components are required? Does anyone know.

I am trying to play it as safe as possible but I don't think installing Office XP web components is feasable, will 2003 web components work?

Thanks in advance for the help.

OWC 2003 will work against AS 2005. As you mentioned you need to get AS OLEDB 9 installed.

In fact is you mention, SQL Management Studio and BI Dev Studio using OWC for browsing cubes.

Though there are quite a few better AS clients out there in the market that work way better with AS2005. Excel 2007 pivot tables for example.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Yeah, I was just looking if someone knew the oldest version of office web components coupled with the install of the OLEDB provider and the XML services that would work for browsing cubes.