Hi everyone,

I have a cube with the following dimensions:

Time
Location
People

The Measures are # of people.

I am trying to model the cube such that I can track the whereabouts of a
person. For example, I want to track that Person A went to Location A,
then Location B, then Location C.

I first thought that may be I can have two dimensions (i.e one for Prev.
Location and one for Current Location) but this only works if there are
2 locations but if there are multiple locations, I'm not sure what to
do.

I hope this makes sense,

Audrey



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!