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-06-28 : 07:24:04
|
| Hi,The underlying table for my fact contains a Sale field whose data type is decimal.In the cube editor, I have tried a few options (both for Data Type and Display format) but in my front end I am still getting the results with 2 decimal places. Can someone kindly help me how I can get the results in a rounded form so that the decimal places are not shown e.g. instead of seeing 12,345,678.98 I want the results rounded as 12,345,679.If (and i really hope not) it boils down to using MDX in the front end then can u kindly guide me since I can only spell MDX at the moment :(Many thanks in advance for your help.Thanks & Regards.-J |
|
|
Devarajan
Starting Member
13 Posts |
Posted - 2004-07-02 : 04:48:19
|
| Edit hte cube and select the measure that u want to round goto advanced properties and then change the display format to #,#G.DevarajanS/o K.Gopalakrishnan |
 |
|
|
Devarajan
Starting Member
13 Posts |
Posted - 2004-07-02 : 04:48:48
|
| Edit hte cube and select the measure that u want to round goto advanced properties and change data type to integer and then change the display format to #,#G.DevarajanS/o K.Gopalakrishnan |
|
|
|
Joozh
Posting Yak Master
145 Posts |
Posted - 2004-07-05 : 06:56:23
|
| Thanks for the help and sorry for late acknowledgment. I have tried thisbut still not getting the results in rounded format :( Must be an issuewith the front-end.Thanks & Regards.-J |
|
|
|
|
|
|
Want to see results in rounded form