|
Home > Archive > MS SQL Data Warehousing > August 2005 > Help linking two date columns to time dimension
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Help linking two date columns to time dimension
|
|
| Steven 2005-08-25, 8:23 pm |
| 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
| |
|
| 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.
"Steven" < stevenheinz57@hotmai
l.com> wrote in message
news:eSXvfXbqFHA.544@TK2MSFTNGP11.phx.gbl...
> 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
>
>
|
|
|
|
|