March 24, 2008 at 2:47 pm
I'm in the process of converting an Analysis Services 2000 data warehouse to SSAS 2005. The current system pre-calculates all currency conversions and stores the resulting values in the fact tables. With SSAS, I now have the option of using the Business Intelligence wizard in the Cube Designer to build currency conversions on the fly. I like this option but I'm wondering what others are doing in this regard. Does adding calculated members of that type present a serious performance concern? Should I stick with the old methods? My primary fact table at present contains around 2,000,000 rows. Any best practice guidance would be appreciated.
March 25, 2008 at 7:33 am
Calculated measures work fine, but they are calculated so depending on the MDX you create, they can become a performance issue. The best way to determine if they are going to work for your situation is to try it. Since the conversion effort is reasonably big (spend the time to do it right rather than using the upgrade wizard) it is a good time to do this type of performance testing.
I would expect you to be able to use calculated measures for currency conversion without any performance issues.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply