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

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.