M
Martin
Anyone know exactly how the table MSP_CUBE_ASSN_FACT is populated
I am getting some discrepancies between Project 2003 OLAP cubes and some reports I wrote. To reconcile the numbers I’d like to understand exactly how the cubes are populated. Each row in the fact table - MSP_CUBE_ASSN_FACT – seems to have a cost associated with one days work (ASSN_COST). I’d like to be able to reconstruct that number from the base tables – MSP_Projects, MSP_Tasks, MSP_Assignments, etc.
I am getting some discrepancies between Project 2003 OLAP cubes and some reports I wrote. To reconcile the numbers I’d like to understand exactly how the cubes are populated. Each row in the fact table - MSP_CUBE_ASSN_FACT – seems to have a cost associated with one days work (ASSN_COST). I’d like to be able to reconstruct that number from the base tables – MSP_Projects, MSP_Tasks, MSP_Assignments, etc.