Filter Expression in Visual Studio RRS feed

  • General discussion

  • Guys, I am using Visual Studio to browse a cube. In the cube browser 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.



    Thursday, September 28, 2006 5:59 AM