The SQL syntax for SSAS naming calculation must comply with the requirements of the & quot; Source & quot; Data Provider

Source: Internet
Author: User
In the SSAS Data Source view, namecomputation is an SQL expression represented as a computing column. Using name calculation, you can extend the relational architecture of tables or views in the data source view without modifying the tables or views in the basic data source. Some beginners see that named computing is generally defined in DEVStudio of SSAS, which is easy to misunderstand.

In the SSAS Data Source view, name calculation is an SQL expression represented as a computing column. Using name calculation, you can extend the relational architecture of tables or views in the data source view without modifying the tables or views in the basic data source. Some beginners see that named computing is generally defined in the DEV Studio of SSAS, which is easy to misunderstand.

In SSASDataIn the source view,NameComputingIsComputingThe SQL expression of the column. UseNameComputing, ScalableDataThe relational architecture of tables or views in the source view, without the need to modify the basicsDataTables or views in the source.

Some beginners seeNameComputingIt is generally defined in DEV Studio of SSAS and is easy to misunderstand.NameComputingSQLSyntaxIt should comply with the range supported by SSAS (that is, SQL server. In fact, this is not the case. If you understand thisDataYou can familiarize yourself with the nature and functions of the Source view.

You can also obtain the following information from the SSAS document:

FinishedNameComputingThenNameComputingExpression inSendDataSourceProvideProgramAnd then use the expression as the following SQL statement for verification. In this statement, Include DefinitionNameComputing.

SELECTExpression
     
      
FROM
     
     
     
      
      
. *, <>
     
     
AS

ColumnDataType of the scalar value returned by the expressionDataType.IfProvideThe program did not find any errors in the expressionTo add the column to the table.

------ Reference from SSAS online document

Please pay attention to the content in red in the above content.NameComputingOfSyntaxNeed to comply with the sourceDataProvideBecauseNameComputingIs submitted to the sourceDataProvideProcessing and execution.

For example, if the sourceDataProvideIs Access, then defineNameComputingYes. To complete peer-to-peer logic, you must convert the Case statement into a judgment Statement supported by Access, such as IIF.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.