Currency conversion in SSAS2005 -
11-02-2005
, 03:49 PM
I have a couple of questions regarding the currency conversions in SSAS 2005.
1. Can I create a currency conversion with pivot currencies that change
based on another dimension. Here's my situation:
My transactions have their own currencies which are Local currencies.
I run data analysis with different currencies. Ex: Analysis1 has calculations
based on USD whereas Analysis2 has calculations based on EURO. So I am
trying to create a dimension called Analysis with Analysis1 and Analysis2 as
items, each with its own currency. Now I want to aggregate the results across
analyses. So if I select All Analyses and select GBP as reporting currency,
having a single pivot currency will not work. And the BI wizard forces me to
select a single pivot currency. Is there any way we can accomplish this?
2. The BI wizard for creating a currency conversion does not work if I don't
have a time dimension setup and associated with the measure group. In my
case I am defining exchange rates for Analysis1 and Analysis2, not some
period. Is there a way to NOT specify period dimension and successfully setup
a currency conversion.? (In my experiment, I created a dummy time dimension
based off of Analysis dimension)
Any help is greatly appreciated.
Thanks |