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

All Replies

• Monday, January 14, 2013 8:58 AM

   

   
  

  0

  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/

  • Reply
  • Quote

   
• Wednesday, January 16, 2013 2:27 AM

  Moderator

   

   
  

  0

  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

  

  • Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Wednesday, January 23, 2013 9:37 AM
  •  
  • Reply
  • Quote