simonB2010
Programmer
Hello all, and yes, I am a newbie to SSAS.
So far, I've built a simple cube, structured it for a many-to-many currency convert, applied a measureExpression [SalesMeasure]*[ExchangeRateMeasure].
All works swimmingly.
However, I have another 70 measures to add in, all of which will require the same currency conversion.
Do I have to manually add these in and individually set the measure expression? Or is there a way to add MEs in via code? Or other solution ?
Many thanks for any advice/tips etc....
Regards
Simon
So far, I've built a simple cube, structured it for a many-to-many currency convert, applied a measureExpression [SalesMeasure]*[ExchangeRateMeasure].
All works swimmingly.
However, I have another 70 measures to add in, all of which will require the same currency conversion.
Do I have to manually add these in and individually set the measure expression? Or is there a way to add MEs in via code? Or other solution ?
Many thanks for any advice/tips etc....
Regards
Simon