Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Key generates in scientific notation in client tools Expand / Collapse
Author
Message
Posted Tuesday, December 24, 2013 11:57 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 26, 2014 1:33 PM
Points: 28, Visits: 101
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]

Post #1525801
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse