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

Numeric Dimension Attribute in SSAS 2008 R2 Expand / Collapse
Author
Message
Posted Sunday, December 02, 2012 11:00 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, March 31, 2014 3:39 PM
Points: 67, Visits: 127
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.


Post #1391738
Posted Monday, December 03, 2012 5:30 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 3:43 PM
Points: 234, Visits: 2,614
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
Posted Monday, December 03, 2012 9:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Monday, December 03, 2012 10:48 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 3:43 PM
Points: 234, Visits: 2,614
Within the dimension, click on the attribute in question. What is the data type showing up in the NameColumn Source?
Post #1392067
Posted Monday, December 03, 2012 2:44 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, March 31, 2014 3:39 PM
Points: 67, Visits: 127
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
Posted Tuesday, December 04, 2012 7:17 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 3:43 PM
Points: 234, Visits: 2,614
What about the data type in the dimension itself?
Post #1392472
Posted Tuesday, December 04, 2012 1:32 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, March 31, 2014 3:39 PM
Points: 67, Visits: 127
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
Posted Tuesday, December 04, 2012 1:45 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 3:43 PM
Points: 234, Visits: 2,614
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
Posted Tuesday, December 04, 2012 2:04 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, March 31, 2014 3:39 PM
Points: 67, Visits: 127
Okay i understand now
It is displayed WCHAR
Post #1392695
Posted Wednesday, February 26, 2014 3:01 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 2:04 PM
Points: 350, Visits: 178
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
Post #1545606
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse