Many-to-Many Currency Conversions in SQL Server Analysis Services
Guardat en:
| Publicat a: | SQL Server Magazine vol. 13, no. 12 (Dec 2011), p. 33-38 |
|---|---|
| Autor principal: | |
| Publicat: |
Informa
|
| Matèries: | |
| Accés en línia: | Citation/Abstract Full Text Full Text - PDF |
| Etiquetes: |
Sense etiquetes, Sigues el primer a etiquetar aquest registre!
|
MARC
| LEADER | 00000nab a2200000uu 4500 | ||
|---|---|---|---|
| 001 | 910803340 | ||
| 003 | UK-CbPIL | ||
| 022 | |a 1522-2187 | ||
| 022 | |a 2165-3291 | ||
| 035 | |a 910803340 | ||
| 045 | 2 | |b d20111201 |b d20111231 | |
| 084 | |a 68489 |2 nlm | ||
| 100 | 1 | |a Tuppen, David | |
| 245 | 1 | |a Many-to-Many Currency Conversions in SQL Server Analysis Services | |
| 260 | |b Informa |c Dec 2011 | ||
| 513 | |a Feature | ||
| 520 | 3 | |a 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." | |
| 653 | |a Servers | ||
| 653 | |a Currency | ||
| 653 | |a Sales | ||
| 653 | |a Financial reporting | ||
| 653 | |a Conversion | ||
| 653 | |a Databases | ||
| 773 | 0 | |t SQL Server Magazine |g vol. 13, no. 12 (Dec 2011), p. 33-38 | |
| 786 | 0 | |d ProQuest |t Advanced Technologies & Aerospace Database | |
| 856 | 4 | 1 | |3 Citation/Abstract |u https://www.proquest.com/docview/910803340/abstract/embedded/7BTGNMKEMPT1V9Z2?source=fedsrch |
| 856 | 4 | 0 | |3 Full Text |u https://www.proquest.com/docview/910803340/fulltext/embedded/7BTGNMKEMPT1V9Z2?source=fedsrch |
| 856 | 4 | 0 | |3 Full Text - PDF |u https://www.proquest.com/docview/910803340/fulltextPDF/embedded/7BTGNMKEMPT1V9Z2?source=fedsrch |