Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server > SQL Server Forums > SQL Server Analysis Services > What is the function of source properties at a measure.

Answered What is the function of source properties at a measure.

    •  
      Wednesday, May 11, 2011 8:04 AM
       
       
      Sign In to Vote
      0
      Sign In to Vote

      Currently trying to understand the source properties of a measure. Could someone give a link where i can i find info about this?

      I'm interested in the datatypes. IMO there 3 places where datatypes are handled : dsv, measure overall properties and grouped properies "source". I don't understand the role of these properties.



       

    Answers

    • Thursday, May 12, 2011 6:52 PM
       
       Answered
      Sign In to Vote
      0
      Sign In to Vote

      Hi

       

      I think it works in a similar way that implicit conversions work in SQL Server:

      "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). Business Intelligence Development Studio 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."

       

      There is a useful table of SSAS datatypes and how they are mapped from .NET and OLE DB datasources over here:

      http://msdn.microsoft.com/en-us/library/ms128523.aspx

      Hope this helps.

       

      Regards,

      Jason

       

      MCITP BI Developer - MCTS SQL Server
       

    All Replies

    • Wednesday, May 11, 2011 10:38 AM
       
       
      Sign In to Vote
      0
      Sign In to Vote

      This should give you some understanding:

      http://technet.microsoft.com/en-us/library/ms174792.aspx

       

      Regards,

      Jason

       

      MCITP BI Developer 2008 - MCTS SQL Server 2005
       
    • Wednesday, May 11, 2011 10:40 AM
       
       
      Sign In to Vote
      0
      Sign In to Vote

      Oh, here are Measure Properties:

      http://msdn.microsoft.com/en-us/library/ms175623.aspx

       

      MCITP BI Developer 2008 - MCTS SQL Server 2005
       
    • Wednesday, May 11, 2011 11:04 AM
       
       
      Sign In to Vote
      0
      Sign In to Vote

      Seen that, been there... The only information about source properties is this:

       

      Source

      Specifies the column in the data source view to which the measure is bound.

       

      There are more properties like:

      datatype, datasize, etc

      My question is how is this related to the datatype in the dsv and to the datatype of the measure? Is it a kind of cast?  

       
    • Thursday, May 12, 2011 6:52 PM
       
       Answered
      Sign In to Vote
      0
      Sign In to Vote

      Hi

       

      I think it works in a similar way that implicit conversions work in SQL Server:

      "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). Business Intelligence Development Studio 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."

       

      There is a useful table of SSAS datatypes and how they are mapped from .NET and OLE DB datasources over here:

      http://msdn.microsoft.com/en-us/library/ms128523.aspx

      Hope this helps.

       

      Regards,

      Jason

       

      MCITP BI Developer - MCTS SQL Server
       
    • Thursday, May 12, 2011 8:17 PM
      Moderator
       
       
      Sign In to Vote
      1
      Sign In to Vote

      I would run this BIDS Helper feature http://bidshelper.codeplex.com/wikipage?title=Measure%20Group%20Health%20Check&referringTitle=Home and it will tell you the proper data types and set them. There's lots of good information explaining this scenario on that page.

       

      http://artisconsulting.com/Blogs/GregGalloway