Hi all,
I need to build a cube with a measure which has a following concept.
The measure is a calculated measure which has the formula say x = a/b. Where x is the measure.
I have the following dimensions and measures
Dim1 Dim2 Dim3 Meas A Meas B Meas X (A/B)
Dim 3 has the values Orange,Apple,Grapes,All.(For eg).
1.If I select values for Dim 3 for analysis
--------------------------------------------
My Meas A and Meas B needs to be as present in the fact table corresponding to the respective Dim 3 value.
2.If I don't select values for Dim 3 for analysis
--------------------------------------------------
My Meas A and Meas B should be corresponding to the value for 'All' in the Dim 3 (as default).
Hope u got this.
How to go about in doing this? Pls help.
Regards
Anandh
I need to build a cube with a measure which has a following concept.
The measure is a calculated measure which has the formula say x = a/b. Where x is the measure.
I have the following dimensions and measures
Dim1 Dim2 Dim3 Meas A Meas B Meas X (A/B)
Dim 3 has the values Orange,Apple,Grapes,All.(For eg).
1.If I select values for Dim 3 for analysis
--------------------------------------------
My Meas A and Meas B needs to be as present in the fact table corresponding to the respective Dim 3 value.
2.If I don't select values for Dim 3 for analysis
--------------------------------------------------
My Meas A and Meas B should be corresponding to the value for 'All' in the Dim 3 (as default).
Hope u got this.
How to go about in doing this? Pls help.
Regards
Anandh