dbTalk Databases Forums  

Format Dimension

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Format Dimension in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
lvpaul@gmx.net
 
Posts: n/a

Default Format Dimension - 10-12-2005 , 08:20 AM






Hallo !

I have a dimension "diameter". The datatype of the Field is "Single".

I am showing the Cube with the Web Components 11.

How can I format the dimension "diameter"

a) in the Analysis Manager ?
OR
b) with the Pivottable of the Web Components ?

Now its something like this:

17
17.1
18.5
18.799999
31.200001

I need this:
17.0
17.1
18.5
18.8
31.2

Thanks
aaapaul


Reply With Quote
  #2  
Old   
michael v
 
Posts: n/a

Default Re: Format Dimension - 10-14-2005 , 11:21 AM






Both...

Heres the owc way....

right click mesure in owc, choose commands and options, choose format tab,
in number tab you can write you own format codes....#,##.0

<lvpaul (AT) gmx (DOT) net> wrote

Quote:
Hallo !

I have a dimension "diameter". The datatype of the Field is "Single".

I am showing the Cube with the Web Components 11.

How can I format the dimension "diameter"

a) in the Analysis Manager ?
OR
b) with the Pivottable of the Web Components ?

Now its something like this:

17
17.1
18.5
18.799999
31.200001

I need this:
17.0
17.1
18.5
18.8
31.2

Thanks
aaapaul




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.