Numeric Dimension Attribute in SSAS 2008 R2

Question

Numeric Dimension Attribute in SSAS 2008 R2

maretix

Hall of Fame

Points: 3835
More actions
December 2, 2012 at 11:00 am

#144048

Good evening to all.
I use SSAS 2008 R2 and i did some cubes.
I built a dimension PRODUCT that contains 2 numeric attributes...PRICE WITH TAXES and PRICE WITHOUT TAXES
Both attributes are numeric (deci format in DW Database)
When i use Excel to query and navigate through the my cube, numeric attributes are displayed like string formats...
I have to format my PRICE WITH TAXES and PRICE WTIHOUT TAXES inside Excel.
What is the best practice to do to display that data RIGHT ALIGNED as numeric values with no manually operations ????
Before to build my dimension ..Do i have to do something in Data Source View of Cube Solution ???? and what ???
Or what else is it the best to do ????
aNY SUGGEST ??? Any useful link to read ??? Any examples ???
For me no problem to use Excel but final users are very exigent...grrrr.....:-)
Many thanks to all people read my post.
Ciao Maretix.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Scott Murray-240410 SSCarpal Tunnel Points: 4649 More actions · Answer 1

You should be able to set the format of each measure to a numberic format ("###.##" for instance). Take a look at : http://technet.microsoft.com/en-us/library/ms175623.aspx

or

http://sharepointmike.wordpress.com/2012/06/02/949/[/url]

fernando.stackoverflow Grasshopper Points: 23 More actions · Answer 2

I believe the question concerns formatting a non-measures dimension. I would like to know how to do this as well.

Scott Murray-240410 SSCarpal Tunnel Points: 4649 More actions · Answer 3

Within the dimension, click on the attribute in question. What is the data type showing up in the NameColumn Source?

maretix Hall of Fame Points: 3835 More actions · Answer 4

Hi guys.

Thanks for your kind reply.

Yes i'd like to know how to format a numeric attribute dimension and not format a numeric measure.

Sorry for my english...i created a misunderstanding,,,

I'd like to be able to display a numeric attribute of a dimension when i use Excel.

The field is a decimal type in SQLSERVER DW Table....

When i use that field as attribute of a dimension, i was not able to display as a numeric directly in Excel..

Regards in advance...

Scott Murray-240410 SSCarpal Tunnel Points: 4649 More actions · Answer 5

Scott Murray-240410

SSCarpal Tunnel

Points: 4649

December 4, 2012 at 7:17 am

#1565312

What about the data type in the dimension itself?

maretix Hall of Fame Points: 3835 More actions · Answer 6

Hi .

Do your efer to use properties attribute inside Dimension Designer ???

i did.

I tried to set format attribute as numeric...but nothing happen .when i query that attribute in Excel it is displayed as string left aligned.

Thanks.

Did you ever do that ???

Have you got an example ???

Scott Murray-240410 SSCarpal Tunnel Points: 4649 More actions · Answer 7

Not the format, but

Within the dimension, click on the attribute in questionm, then properties. What is the data type showing up in the NameColumn Source?

maretix Hall of Fame Points: 3835 More actions · Answer 8

maretix

Hall of Fame

Points: 3835

December 4, 2012 at 2:04 pm

#1565494

Okay i understand now

It is displayed WCHAR

Suresh.Utham SSCommitted Points: 1524 More actions · Answer 9

I'm also facing same issue while applying format under NameColumn . It's not allowing to change from WCHAR to Double... Also, if I use #,##0.00 in format string, nothing happens while browsing cube in excel / SSMS.

Suresh