Hi,
There is no syntax error in the query. But you are not selecting any results from this query because of the the Non Empty function.
I guess you are trying to find :
SELECT
{}
ON 0,
(
[Entity].[EntityPRID].&[118445008]*
[Entity-OrgType].[EntityOrgType].[EntityOrgType].MEMBERS
)
ON 1
FROM [Model]
and SQL query cannot run in multidimensional cube. It is not very meaningful to find the "same" sql query.
But similar SQL against the original data source would be something like :
SELECT '118445008' as EntityPRID, EntityOrgType from Entity-OrgType
Regards,
Lukas