Could someone please help me clarify this...

I am under the impression that for efficiency reason I
should remove dates from my fact tables and link them to a
multipurpose 'time' table. However if there are dates in
the time table that are not needed for a particular fact
table they still show up in the data viewer.

Is there a way to basically suppress 'Zero' rows (where
there is no data don't show it?).

Am I creating my fact table correctly by using a generic
time table?

Thanks for the help.

Yes, highly recommended to have a time dimension table: You can specify your
own member names in the dim table, rather than letting AS derive the names.
You can have "non-standard" rollups (i.e. 13 four week accounting periods).
You can assign member properties (i.e. Holiday Y-N). It's sharable, whereas
when derived from fact table it can only be used with that fact table.

How to suppress null rows in a query depends on your client.

tom @ the domain below
www.tomchester.net


"Mike Morse" <mike.morse (AT) micrmo (DOT) com> wrote