Analyse Services Filter

#1

Can I filter some records on fact table?

example: WHERE Field='xxx'

#2

In the Cube editor, Advanced properties then there's a setting for
Source Table Filter. It's also somewhere in the cube builder wizard at
the end I think.

Steve

#3

Would do it before AS with a view on top on you're fact table...

"Dario Concilio" <dario.concilio (AT) dakyn (DOT) it> wrote

Quote:

Can I filter some records on fact table?

example: WHERE Field='xxx'

#4

Dario

There are some front end tools on the market that allow you to do this in
more than one way to achieve what you need. This also could be done through
a view as suggested but is possible on the cube as well.

Regards
Howard.Taylor@ domain below
www.o2olap.com

"Dario Concilio" <dario.concilio (AT) dakyn (DOT) it> wrote

Quote:

Can I filter some records on fact table?

example: WHERE Field='xxx'

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Analyse Services Filter

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Analyse Services Filter - 11-15-2004 , 02:16 AM

Re: Analyse Services Filter - 11-15-2004 , 06:46 AM

Re: Analyse Services Filter - 11-15-2004 , 12:26 PM

Re: Analyse Services Filter - 11-16-2004 , 01:49 AM