Buchumschlag

Many-to-Many Currency Conversions in SQL Server Analysis Services

Gespeichert in:
Veröffentlicht in:SQL Server Magazine vol. 13, no. 12 (Dec 2011), p. 33-38
1. Verfasser: Tuppen, David
Veröffentlicht:
Informa
Schlagworte:
Servers
Currency
Sales
Financial reporting
Conversion
Databases
Online-Zugang:Citation/Abstract
Full Text
Full Text - PDF
Tags: Tag hinzufügen
Keine Tags, Fügen Sie das erste Tag hinzu!
Abstract:Using the Business Intelligence Wizard in SQL Server Analysis Services (SSAS). you can perform currency conversions, but you unfortunately aren't able to enter multiple dales or multiple exchange rales. If you're using a separate database server, you'll need to move the Sales.bak database backup h'!e to a local or mapped drive where that database server is able to locate backups. * Restore the sample Sales database fronrlhe SQL Server 2008 R2 backup file named Sales .bak. * Open the Currency Conversion solution in Business Intelligence Development Sludio (BIDS) and change the deployment server name to the name of your SSAS server. * Open the data source in the solution and change the server name to name of the server on which you restored the Sales database. The cube will use these dimensions imernully Io perform currency conversions.\n According to BOL, the Scope function "Limits the scope of specified Multidimensional Expressions (MDX) statements to a specified sub cube."
ISSN:1522-2187
2165-3291
Quelle:Advanced Technologies & Aerospace Database