Hi there,
  Can anyone tell me how to remove the decimal places from the OLAP Cube data and just make them whole numbers?  

Please and Thank you

Daniel Pruett

EggHeadCafe - Software Developer Portal of Choice 
Silverlight 2 Beta 2: Doing Data Part II
http://www.eggheadcafe.com/tutorials/aspnet/74e6d04f-7d50-4efe-8c82-69ba695d7e5d/silverlight-2-beta-2-doi.aspx

I think you will have to create a separate calculated field for the data in 
question.  For example if you want to show [Work] rounded to 0 decimals you 
would use this MDX formula

IIF([Measures].[Work] = NULL, NULL, ROUND([Measures].[Work],0))

You will also need to set the number format for this new calculated field to 
"General"

Jonathan

"Daniel Pruett" wrote in message news:20091118122245dpruett40@yahoo.com...
> Hi there,
>  Can anyone tell me how to remove the decimal places from the OLAP Cube 
> data and just make them whole numbers?
>
> Please and Thank you
>
> Daniel Pruett
>
> EggHeadCafe - Software Developer Portal of Choice
> Silverlight 2 Beta 2: Doing Data Part II
> http://www.eggheadcafe.com/tutorials/aspnet/74e6d04f-7d50-4efe-8c82-69ba695d7e5d/silverlight-2-beta-2-doi.aspx 

Daniel --

You did not state what type of numbers have the decimal places in Data 
Analysis views, but I will assume you are talking about Work columns, as I 
know they can show LOTS of decimal places!  :)  There's a pretty easy way to 
suppress the decimals, and to add the comma character as the thousands 
separator (showing 1,000 rather than 1000).  To do this requires a little 
Excel trick.  Keep in mind that the PivotTable in a Data Analysis view is 
actually an EXCEL PivotTable, so this means you can apply any type of Excel 
number formatting to numbers in a Data Analysis view.  Here's how to do it:

1.  Right-click on one of the columns that has lots of decimals and then 
click the Commands and Options item on the shortcut menu.
2.  In the Commands and Options dialog, click the Format tab.
3.  In the Number field, manually type the following Excel formatting:

#,##0

4.  Press the Enter key and then close the dialog.

You will see that your numbers are now properly formatted, supressing the 
decimals and adding comma as the thousands separator.  Hope this helps.

-- 
Dale A. Howard [MVP]
VP of Educational Services
msProjectExperts
http://www.msprojectexperts.com
http://www.projectserverexperts.com
"We write the books on Project Server"


"Daniel Pruett" wrote in message news:20091118122245dpruett40@yahoo.com...
> Hi there,
>  Can anyone tell me how to remove the decimal places from the OLAP Cube 
> data and just make them whole numbers?
>
> Please and Thank you
>
> Daniel Pruett
>
> EggHeadCafe - Software Developer Portal of Choice
> Silverlight 2 Beta 2: Doing Data Part II
> http://www.eggheadcafe.com/tutorials/aspnet/74e6d04f-7d50-4efe-8c82-69ba695d7e5d/silverlight-2-beta-2-doi.aspx 

Right click the column, pick the formatting option, and format as #,#
-- 
Regards,  Ben.


"Daniel Pruett" wrote:

> Hi there,
>   Can anyone tell me how to remove the decimal places from the OLAP Cube data and just make them whole numbers?  
> 
> Please and Thank you
> 
> Daniel Pruett
> 
> EggHeadCafe - Software Developer Portal of Choice 
> Silverlight 2 Beta 2: Doing Data Part II
> http://www.eggheadcafe.com/tutorials/aspnet/74e6d04f-7d50-4efe-8c82-69ba695d7e5d/silverlight-2-beta-2-doi.aspx
> .
>