I am using Microsoft t Visual Studio 2010 In process of creating Cube based on SQL Server 2008 platform.
I created data source then data source view and put in several tables that went ok.
Then I was trying to add - create Named Query in data source view .
In query I am using Left outer apply to call function. This function is table - valued function.
Query is created
When I double click on this query I got this error popped up:
SQL Syntax Error Encountered
The following errors were encountered while parsing the contents of SQL pane:
“The OUTER APPLY SQL construct or statement is not supported.”
However, If I right click on it and click on explore data I can see data.
How to get read of this error.