Post reply

Tricky dimension

  • September 7, 2004 at 4:41 pm

    #164914

    Hello all, I have a newbie problem. :-\

    I have a cube with all 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

  • September 7, 2004 at 11:23 pm

    #522049

    I suppose to get the data on to the cube you should have had an original database:tables etc.

    Use the base tables, and perform an ETL to transform the rows into columns

    i.e 0,0=ok, 1,0=refurbished, 0,1=rejected etc.

    Then Load the dimension from the newly transformed table straightaway.

    Hope this Helps.

    Cheers-Gan.

  • September 8, 2004 at 10:31 am

    #522160

    Used a calculated field:

    refurbished + (rejected*2), So I have 3 possible values in one single field.

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply