MDX to SQL

Question

SELECT
{}
ON 0,
NON EMPTY (
[Entity].[EntityPRID].&[10000000] *
[Entity-OrgType].[EntityOrgType].[EntityOrgType].MEMBERS
)
ON 1
FROM [Model]

Can any one help. if above query has any syntax error. and also can give a similar sql query

Answer 1

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