I'm trying to get one cube to display two different grains of data:

1) Vehicle measures - such as total time and total miles.

2) Trip measures - such as total trip time and total trip miles.

How would I accomplish this? I assume that the measures have to be in the same fact table?

Thanks for your time!