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

athermian (AT) yahoo (DOT) com wrote:

add both a dimension (e.g. "action_id") and a measure (e.g. "action_count").
this lets you keep track of which action was performed how many times on
which model per month blah blah etc.

HTH

cheers
Heimo

--
l'essentiel est invisible pour les yeux.

If you used a true "multi-cube" product then this would not be an issue. It
would be analogous to designing multiple tables in the SQL world, and doing
a natural join on the data.

Tony Proctor

<athermian (AT) yahoo (DOT) com> wrote

Hi,

What you term a "Cube" is what exactly?

Are you using an toy OLAP product like MSAS, or an industrial strength OLAP
product like Essbase?

John

<athermian (AT) yahoo (DOT) com> wrote