dbTalk Databases Forums  

Currency conversion in SSAS2005

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Currency conversion in SSAS2005 in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Raghu
 
Posts: n/a

Default 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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.