Can I filter the rows in the source fact table so that only rows which
meet certain conditions are processed in the cube ?

Can I divide the rows in one fact table so that two mutually exclusive
cubes are built from the same fact table? For Example: I want one cube
with all sales in USA and one cube with all sales in Europe where
everything sits in the same fact table?

I'm using MS SQLServer 2000 for my source data as well as Analysis
Services.

Thanks!

Two ways to do this
1) Create 2 views in sql server with different where statements (one
which filters USA records and one which filters Europe records). Then
use these views as the source tables for your cubes.
2) Define a different data slice for your partitions of the cubes.

HTH

Milind


Rivkarak wrote:

Another method is "source table filtering" under the advanced tab in
MSAS
i.e.: NOT([dbo].[DimG_MdcDrg].[mdc_DNL]=15)

We traditionally use the "Create view" method discussed earlier
though....
Byron