Numeric Dimension Attribute in SSAS 2008 R2

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Analysis Services » Numeric Dimension Attribute in SSAS 2008 R2

Numeric Dimension Attribute in SSAS 2008 R2

Rate Topic

Display Mode

Topic Options

Author

Message

maretix

Posted Sunday, December 02, 2012 11:00 AM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 1:04 PM
Points: 52, Visits: 93

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..... Smile

Many thanks to all people read my post.

Ciao Maretix.

Post #1391738

Scott Murray-240410

Posted Monday, December 03, 2012 5:30 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 6:39 AM
Points: 159, Visits: 2,205

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/

Post #1391859

fernando.stackoverflow

Posted Monday, December 03, 2012 9:35 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, January 30, 2013 7:35 AM
Points: 1, Visits: 7

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

Post #1392032

Scott Murray-240410

Posted Monday, December 03, 2012 10:48 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 6:39 AM
Points: 159, Visits: 2,205

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

Post #1392067

maretix

Posted Monday, December 03, 2012 2:44 PM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 1:04 PM
Points: 52, Visits: 93

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...

Post #1392153

Scott Murray-240410

Posted Tuesday, December 04, 2012 7:17 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 6:39 AM
Points: 159, Visits: 2,205

What about the data type in the dimension itself?

Post #1392472

maretix

Posted Tuesday, December 04, 2012 1:32 PM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 1:04 PM
Points: 52, Visits: 93

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 ???

Post #1392677

Scott Murray-240410

Posted Tuesday, December 04, 2012 1:45 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 6:39 AM
Points: 159, Visits: 2,205

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?

Post #1392683

maretix

Posted Tuesday, December 04, 2012 2:04 PM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 1:04 PM
Points: 52, Visits: 93

Okay i understand now
It is displayed WCHAR

Post #1392695

« Prev Topic | Next Topic »

Permissions