Guys, I am using Visual Studio to browse a cube. In the cube browser I
do not understand the difference between the Filter Expression area and
the "Drop Filter Fields Here" area. As far as I can tell, they should do
exactly the same thing. However I have a situation where they do not. I
am using the Tutorial, and am browsing variabes "Internet sales -sales
amount" and "Sales amount quota".

If I use the "Drop Filter Fields Here" area and restrict to Fiscal Year
2004 I get the correct value in both measures.

If I use the Filter Expression area to do the same restriction I get
the correct value for "Internet sales -sales amount" but the "Sales
amount quota". shows a value representing all years.

If I use "Sales amount quota" in a KPI, the KPI screen supports the
Filter Expression area but not the "Drop Filter Fields Here" area, and
so does not produce the correct results.

Can someone explain how these two areas differ and what the effect of
filtering in each should be.

Thank


--
CliffordS

The "Filter expression area" defines a subcube: it has effects on
metadata navigation, in fact if you filter here a single year, you will
see that the same date dimension you place in the cube is filtered by
only the members (year and children) you filtered above.
The "Drop Filter Fields Here" area defines the WHERE condition of an
MDX SELECT statement. The behavior is different because even if the
result is the same, you could have different performance (Filter
expression area is normally faster).

Marco Russo
http://www.sqljunkies.com/weblog/sqlbi
http://www.sqlbi.eu


CliffordS wrote: