Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Joozh
Posting Yak Master
145 Posts |
 Posted - 2004-11-23 : 12:01:08
|
| Hi,Is there a format function in MDX which will help me solve the following scenario:One of my measures is Net Sales and I have tried all different formats in Analysis Services so that it shows without the decimal places i.e. instead of showing the Net Sales for any selected combination of Dimensions as 123,456.04, I want to show it as 123,456When I browse the cube (in Analysis Services), I can meet my requirement. However, in my front-end (Microsoft Data Analyzer), I am still getting it as 123,456.04 (even when the same in Analysis services, i.e. when I browse the cube, is being shown as 123,456).I do not have much choice at the moment and am stuck with Microsoft Data Analyzer and unfortunately have not been able to solve this :(Can someone think of a solution/workaround/use of MDX which will help me get the results being displayed without the decimal.Many TIAThanks & Regards.-J |
|
|
jojo_jacob
Starting Member
24 Posts |
Posted - 2004-11-23 : 23:39:06
|
| I dunno abt MDA, but some OLAP tools provide the facility to format the measures as defined in the Analysis Services, rather than adopting the tool's formatting styles.If that option is not there in MDA, you may use the FORMAT clause with a calculated member in MDX, like:with member [Measures].[Formatted Net Sales] as '([Measures].[Net Sales]', format = '0'select {[Measures].[Formatted Net Sales]}, ............. on columns,................. on rowsfrom SalesLet me know if this worked for u.CheersJojo |
 |
|
|
|
|
|
|
|
Is there a format function in MDX which can help ?