Hi,
Looks like you only change very little in the code .
As we said, no syntax error, but you are not selecting any results from this query because of the the Non Empty .
SQL query cannot run in multidimensional cube, it is not very meaningful to find the "same" sql query.
I guess you are trying to have :
SELECT '10000000' as EntityPRID, EntityOrgType from Entity-OrgType
Regards,
Lukas