Problems with dimensions and measures

hi i a newbie in the world of cubes and i have a problems to show a report of quantity of products sales for year

this show like this

1997 62

1998 62

1999 62

2000 62

and only sale producs sales in 1999 the right thing is

1997 0

1998 0

1999 62

2000 0

If you are using Analysis Services 2005 this seems like a problem with the relation between your product dimension and your fact table/measure group. Check the dimension usage tab in the cube designer in Business Intelligence Development Studio.

When dimensions and fact tables are not related correctly Analysis Services will show the All member value for the unrelated dimension.

HTH

Thomas Ivarsson

|||thanks for you help..