Many-to-Many Currency Conversions in SQL Server Analysis Services
Guardado en:
| Publicado en: | SQL Server Magazine vol. 13, no. 12 (Dec 2011), p. 33-38 |
|---|---|
| Autor principal: | |
| Publicado: |
Informa
|
| Materias: | |
| Acceso en línea: | Citation/Abstract Full Text Full Text - PDF |
| Etiquetas: |
Sin Etiquetas, Sea el primero en etiquetar este registro!
|
| Resumen: | 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 |
| Fuente: | Advanced Technologies & Aerospace Database |