Hi,

Does anyone know the difference between 'Data Slice'
and 'Filter' statement in Advanced Setting in the
Partition wizard ?

Thanks in advance.

Hari

Hi Hari,
i assume slicing is done by dimension content as in: only
1999 instead of all times. It defines a subset of the
complete data.

Filtering this subset leaves an even smaller subset of
data and is very similar to slicing. Filtering is done
based on one or more conditions (like revenue
<=10,000USD).
I guess filtering is not based on a dimension member's
name, but on attributes or on measures.

HTH Lutz

Hi,

I couldn't find any difference in specifying filter
condition in either 'Slice data' or 'Filter'. Both fetches
the same set of results.

But I read in this forum that MSAS uses partition slice to
identify the partition when a query is issued to the cube.
Is that the difference between Data Slice and Filter?

Moreover, in Filter also, I was able to specify dimension
members.

Any clarification is highly appreciated.

Thanks,
Hari

Specifying a filter is just for building the SQL query that populates an
Analysis Services object. For example, if you set up a "filter" on a
partition, you are specifying what records will be included in the partition
when the partition is processed.

Setting the data slice is for querying. When you set a data slice for a
partition, you are giving the server information about what exists in the
partition. The server can then use that information when it attempts to
resolve user queries. For example, if a user asks for Time.1998 in a query
and you have a data slice on a partition set to 1998, then the server will
only scan that partition, and NOT scan any of the other ones. Setting the
data slice is very important for optimal query performance. For more info
please see the whitepaper

http://www.microsoft.com/technet/tre...e/ANSvcsPG.asp

Sean


--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

"Hari" <harihcl (AT) hotmail (DOT) com> wrote

Thanks a lot for the information, Sean

Hari