Decimal places in OLAP Cube Data

[Daniel Pruett]

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/tutorial...82-69ba695d7e5d/silverlight-2-beta-2-doi.aspx

 

[Jonathan Sofer [MVP]]

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

in message news:[email protected]...

 

[Dale Howard [MVP]]

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.




in message news:[email protected]...

 

[Ben]

Right click the column, pick the formatting option, and format as #,#