question

SudiptoDuyari-5179 avatar image
0 Votes"
SudiptoDuyari-5179 asked LukasYu-msft commented

MDX to SQL



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

sql-server-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered LukasYu-msft commented

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


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,

Did this help you issue?

0 Votes 0 ·