Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

KPI status error

Hello,

I created couple KPI in Tabular model (1200, SSAS 14.0.249.3). I can’t use KPI Status in any report (Excel, Power BI) or Dataset on SSRS. Always I have the next error:

===================================



MdxScript(DRK_data_model) (9, 38) Failed to resolve name 'SYNTAXERROR'. It is not a valid table, variable, or function name. (Microsoft SQL Server 2017 Analysis Services)



------------------------------

Расположение программы:



в Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.ExecuteTabular(CommandBehavior behavior, ICommandContentProvider contentProvider, AdomdPropertyCollection commandProperties, IDataParameterCollection parameters)

в Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteReader(CommandBehavior behavior)

в Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteReader()

в Microsoft.ReportingServices.QueryDesigners.ASDesigner.QueryBuilderClientControl.QueryExec.ThreadExecution()