trying to optimise FoodMart 2000, but failing.

  • If you set the member key to time_id but do not change the member name column (also to time_id) you will create a situation where multiple members of the same parent have the same name - this is not allowed and results in the 'duplicate member' error you are receiving.

    If you consider this for a moment, you'll see why: since the grain of time is day, many time rows (with unique time_id values) have the same Month value.

    Scot Reagin

    sreagin@aspirity.com

    Scot J Reagin

    sreagin@aspirity.com

    Scot J Reagin
    sreagin@hitachiconsulting.com

Viewing post 1 (of 2 total)

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