Hello all, I have a newbie problem.

I have a cube with fabrication lots, phisical tables has 2 fields:
refurbished, rejected.

These fields can have: 0,0 (lot ok); 1,0 (lot refurbished); 0,1 (rejected);
but never 1,1.

I I'd like to separate them using an adittional dimension with members: ok,
refurbished, rejected. But I can't find how

¿Some help?
¿Some alternate way to do it?
¿Need to provide more info.. like what?

Thanks

You can define a view on the table, with an additional field like
StatusID = (FieldA*2) + FieldB. Then create a Status dimension table
with 3 entries, join via StatusID:

Key Name
--- ----
0 Lot OK
1 Lot Rejected
2 Lot Refurbished



- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!