Calculated Member - can it solve my problem -
05-24-2006
, 10:19 AM
I have a cube where the fact data lists project parameters, e.g. say 2 rows
per project where each row maps a project parameter which has the score 0 or
1
PROJECT PARAMETERNAME SCORE
Project1 param1 1
Project1 param2 1
Project2 param1 1
Project2 param2 0
Per project I want to have a measure, ProjectScore, that is set to 1 or 0
based on a MIN aggregation of all SCORE values for each project (ProjectScore
is 1 for Project1 and 0 for Project2 in the example above).
What I then want to to aggregate an average(%) of the projects that has
ProjectScore=1 (for the example the total aggregation is 50%).
I am currently looking into setting up two calculated measures to simulate
this, but I'm not there yet... (I could set up two separate cubes, and then a
virtual cube on top - but what I want to accomplish is to be able to filter
out specific parameters and see how that affects the percentage aggregations,
a feature I can not get by using two cubes)
I would appreciate advice on how to set up these aggregations.
Lamm |