Please help me as I'm trying to get a tutorial on how to set up Currency
conversion.
I have a DimSourceCurrency and DimDestinationCurrency. When I use the BI
Wizard to create a Reporting Currency it fails for the 'Local' currency due
to it being more than CHAR(3). I fix this by changing it to 'Loc'. The
conversions appear to be happening, but the values are incorrect. Is there a
step by step guide somewhere or a good book that explains how to set this up.
The AdventureWorks seams to be One-Many

Thanks
Peter

Beware of Many to Many - the performance is sub-ideal.
--
SmartGuy


"Peter" wrote:

Hi Peter,

You can refer to this MSDN paper:

http://msdn.microsoft.com/library/de.../en-us/dnsql90
/html/sql2k5snapshotisol.asp

Richard Tkachuk
Microsoft Corporation

June 2005

Applies to:

Microsoft SQL Server 2005 Analysis Services

Summary: See an example of using the Many-to-Many dimension in SQL
Server 2005 Analysis Services to analyze sales data, and get ideas for
other uses such as treating medical conditions, software testing, and
more.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

HI Peter,

This was a known bug before RTM that was fixed for RTM.
Did you change loc everywhere int he MDX script as well?

There is no book on Currency conversion wizard that I know of.
If you send me an example of the source data in local currency and the
converted value that you are getting I may be able to help you...

"Peter" wrote: