Click here to Skip to main content
15,886,802 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have the following MDX:

SCOPE ([measures].[std_mg_qst_sup_olap]);
	SCOPE ([d_std_dim_questionnaire].[l_std_dim_questionnaire_key].[l_std_dim_questionnaire_key].members);
		THIS = 
							sum(
		[d_std_dim_questionnaire].[l_std_dim_questionnaire_key].currentmember,
		std_m_qst_sup_in_quest_olap)/
		sum(
		[d_std_dim_questionnaire].[l_std_dim_questionnaire_key].currentmember,
		std_m_qst_sup_in_quest_count_olap);
	
	END SCOPE;


Based on this the values are being calculated as shown below:

Criteria Value
A4
B4
C4
Total 3.83

Here, I am expecting the aggregation to be 4 and not 3.83.

(Sorry about the formatting, Criteria is one column with values A, B and C. Value is another column that shows the numbers in each criteria with values as 4, 4 and 4 respectively).

What I have tried:

I tried using
currentmember
instead of
members
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900