Help linking two date columns to time dimension

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steven - 25 Aug 2005 21:45 GMT

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

Reply to this Message

Jéjé - 27 Aug 2005 13:57 GMT

in yukon 1 dimension can be used multiple time in the same cube

create 1 time dimension
create a measure group
add the incident dimension
add the time dimension and link it to the measure group a first time, call
it opening date
then add the dimension a second time and call it closing date.

when you link the dimension to the fact table, choose the right option to go
through the incident dimension and not directly to the measure group table.

> Scenario:
>
[quoted text clipped - 9 lines]
> Thanks,
> Steven

Reply to this Message