Hi,
Please help with this MDX.
I need a report with situation of the sales( there are in currency $) and I need to be in EURO.
How could I achieve this
Thanks,
MDX question
Hot Topic
- Will package work on different CTP version?
- Capturing and reporting execution errors
- Transferring Records from a table to multiple files
- Size of datafiles in a MSSQL2000
- Using Forms authentication in scripts
- Capturing Changes In Data
- SQL Express Family CTP Now Available
- sql transaction
- Transforming Old Data to a new database with different relationships
- Msg 468, Level 16, State 9, Line 1 --Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_Ge
SQL Server
- service broker message on remote instance not working
- can't modify stored proc which is in a publication
- service broker error : Connection handshake failed
- DTS to SSIS
- SSIS Package is "hanging" after validation
- Installing Quickstart DB-Samples
- Count Query
- How to deny permission to modify report's datasource property
- Where's the bell?
- Data transfer from Adaptive Server Anywhere( 8.0.2.4308) to SQL Server 2005
MDX question
Marble
You can create a calculated member to convert USD to Euro at specified rate (in the example below I assumed $1 = € 0.81) and define its format string accordingly. Like such:
WITH MEMBER [Measures].[SalesInEuro] AS
[Measures].[Sales Amount] * 0.81,
FORMAT_STRING = '€ #,##0.00'
SELECT { [Measures].[Sales Amount], [Measures].[SalesInEuro] } ON 0 FROM Finance