I'm working with SQL Server 2008 SSAS creating a financial cube.
In ProClarity, the MDX editor displays:
SELECT { [Period].[Calendar].DEFAULTMEMBER } ON COLUMNS ,
{ [Cost Center].[Cost Center].&[1.97E2] } ON ROWS
FROM [Finance]
...and the same with Excel Pivot Table's MDX property from VBA.
Is there any setting in SSAS to have it return it scientific notation-less? Like:
SELECT { [Period].[Calendar].DEFAULTMEMBER } ON COLUMNS ,
{ [Cost Center].[Cost Center].&[197] } ON ROWS
FROM [Finance]