none
when i add new attribute to my dimension change the datatype for from double to wchar (originality this this is float)

    Question

  • when i add new attribute to my dimension  change the datatype for from double  to wchar (originality this this is float)

    and sort order is alphabetical  . 

    Monday, January 14, 2013 4:36 AM

Answers

All replies

  • Hi Mohsen,

    As per the link - http://msdn.microsoft.com/en-us/library/ms128523.aspx -

    "All data that is received from the data source is converted to the SSAS type specified in the binding (usually during processing). An error is raised if the conversion cannot be performed (for example, String to Int). SQL Server Data Tools (SSDT) usually sets the data type in the binding to the one that best matches the source type in the data source. For example, the SQL types Date, DateTime, SmallDateTime, DateTime2, DateTimeOffset are mapped to SSAS Date, and the SQL type Time is mapped to String."

    Having said this, you can also change the data type manually by altering the properties of the newly added dimension's attribute, but you need to make sure it won't change in future otherwise SSAS will raise an error.

    HTH

    Regards,
    Santosh


    http://microsoftbizintel.wordpress.com/

    Monday, January 14, 2013 8:58 AM
  • Hi MohsenShafiey,

    For the attribute order, we can set the "OrderBy" property of the attribute. For more information, please see:
    Dimension Attribute Properties Reference: http://msdn.microsoft.com/en-us/library/ms174919.aspx

    Here is a blog about ordering attribute members of dimensions in Analysis Services for your reference, please see:
    http://dinesql.blogspot.com/2011/04/ordering-attribute-members-of.html

    Regards,


    Elvis Long
    TechNet Community Support

    Wednesday, January 16, 2013 2:27 AM
    Moderator