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.