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.

Thanks

Ather