| anders t 2005-04-18, 8:23 pm |
| Quoting Ather Mian in microsoft.public.sqlserver. datawarehouse:[color
=darkred]
>Hi,
>
>I have a cube where the products we get for repairs under warranty are
>analyzed. My dimensions are repair date, symptoms, root cause and products.
>All this works fine my only problems is that I need to put in another
>dimension called actions (things done to rectify the problems). The only
>problem is that 90 percent of the times more than one action is taken to do
>the repair.
>
>If I put action id in my transactions query then every repair that has
>multiple action gets repeated that many times. is there a way to model
>this in a cube?
>
>Any help would be greatly appreciated.[/color]
Could the creation of an action minidimension help you? I'm not clear over
what you mean by "action". Different, repeated or both? How many different?
--
All that we see, or seem,
is but a dream, within a dream,
installed by the Machine
|