• My current thought is that this information should not be in the cube. If it is, they are not utilizing the cube properly; i.e. addresses, IMHO, have no place in a cube as this is raw data. Any PII is raw data and should not be in a cube (at least in our case). If the user needs to drill down, this should be ROLAP to get row level information as opposed to aggregates.

    Jared
    CE - Microsoft