Scenario:


An incident dimension table has two dates "OpenedDate" and "ClosedDate". I
have created an "Incidents" dimension and I want to create 2 measures
"Opened Incident Count" and "Closed Incident Count" and then browse the cube
displaying both incident counts, slicing with the time dimension and dicing
with various "Incident" dimension members.

In Yukon, how do I create the link between the time dimension and both the
OpenedDate and ClosedDate in the Incidents dimension?

Thanks,
Steven

Assuming that "Opened Incident Count" is the number of incidents whose
"OpenedDate" falls within the selected time, and similarly for "Closed
Incident Count", then an event fact model might work better. For each
incident, there would be an "Opened" event with an "EventDate" and, if
the incident was closed, a "Closed" event with its own "EventDate". This
fact table would then join to the time dimension on "EventDate" and to
the incident dimension on an Incident ID. An "EventType" field could
have "Opened" and "Closed" values, joining to an "EventType" dimension.


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***