Hi,

I'm learning how to create cubes in SQL 2005 (Analysis Services).
So, i supose that my questions will be silly questions, but i didn't
understood why my cube had that beahvior.

Two small questions:

If i have some field in fact table, but it isn't some foreign key to a
dimension table or it isn't a measure, how can i see this field in a
drilltrough action?

- i tried to make a condition in a drilltrough action but the select didn't
work.

I used a smalldatetime field to make a time dimension table, but i couldn't
desagregate the date (in sql 2000 works automaticly ), like year, month, day.

I have the exact same issue with a time dimension table. Can anyone help?

Clint
"aggc" <aggc (AT) discussions (DOT) microsoft.com> wrote