I have a problem when I made calculation on SSAS 2005. I have two dimensions such as Department and Parameter where 1 Department has several Parameters.
Each Parameter has point measure (Total Point Parameter) and bobot measure in percent (Bobot Parameter). The subtotal of Total Point Parameter is sum of Total Point Parameter for parameters in 1 department and the subtotal of Bobot Parameter is sum of Bobot Parameter for parameters in 1 department which the result will be 100%. I want to make a calculated measure named Total Point Department that I can get the result by multiplying Total Point Parameter with Bobot Parameter. But for the subtotal of that calculated measure, the value should be sum of Total Point Department for parameters in 1 Department. I attach the layout so you can have a good understanding to my problem.
This is the MDX script for Total Point Department:
[Measures].[Bobot Parameter]
* [Measures].[Total Point Parameter]
Can you please help me? Thanks in advance.
Regards,
I have the same issue, have you been able to solve your problem?
|||Have you tried setting this up use a measure expression instead of a calculated measure?
I think this will make the multiplication happen at the leaf level and then the normal aggregation will kick in.
Otherwise you could try scoping your calculation at the leaf level.
sql
No comments:
Post a Comment