SQL Server Performance

filtering dimension source table members

Discussion in 'SQL Server 2005 Analysis Services' started by servoy, Nov 17, 2006.

  1. servoy New Member

    Hi,

    I would like to know how I can create a dimension with only a subset of the rows from the source table?

    I also want to use that subset to filter the fact table.

    In AS2000 I was doing it by using the Source Table Filter property of the dimension.

    Thanks

Share This Page