August 12, 2015 at 7:48 am
Hello,
I'm trying to create a calculated measure that returns the converted value of an amount to Euro : i have the measure [Measures].[Montant] in my fact table but i need to use a dimension attribute [Taux Change].[Taux Euro] that represents the conversion rate.
My calculated measure should basically be something like :
[converted_amount] = [Measures].[Montant]*[Taux Change].[Taux Euro]
My problem is that this new calculated measure returns Blank.
Could you please help me find the appropriate MDX code to use in my case.
Thanks.
August 12, 2015 at 10:18 am
mrani.soukaina (8/12/2015)
Hello,I'm trying to create a calculated measure that returns the converted value of an amount to Euro : i have the measure [Measures].[Montant] in my fact table but i need to use a dimension attribute [Taux Change].[Taux Euro] that represents the conversion rate.
My calculated measure should basically be something like :
[converted_amount] = [Measures].[Montant]*[Taux Change].[Taux Euro]
My problem is that this new calculated measure returns Blank.
Could you please help me find the appropriate MDX code to use in my case.
Thanks.
The first thing I'd recommend checking is that you have a relationship between your fact table and dimension.
Assuming that's in place, my first guess would be that your problem is the dimensionality (dimensional level) of your MDX statement. You may need to step one level down, i.e. [Taux Change].[Taux Euro].[Taux Euro]
Apologies for the shameless plug, but this blog post may help test your calculated member: https://wordpress.com/post/18685351/731/[/url]
Hope this helps...
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply