Results 1 to 2 of 2

Thread: Combining two different fact "grains"

  1. #1
    Join Date
    Jan 2005
    Posts
    2

    Combining two different fact "grains"

    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!

  2. #2
    Join Date
    Jan 2005
    Posts
    2
    I found one way of doing it:
    I created both a vehicle and a trip cube. I then created a virtual cube that references both of these cubes.

    Is there another approach that I could take?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •