Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Setting Many MeasureExpressions

Status
Not open for further replies.

simonB2010

Programmer
Jul 19, 2011
5
GB
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top