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
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
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
3 people are following this question.
File for a cloned Vertipaq data object conflicts with a master data object file
dimension security on a combination of dimensions
integration services ne figure pas dans la liste des fonctionnalités partagées de sql server
Getting error message as "Unable to find any Microsoft OLE DB providers on the machine."
How to schedule SQL profiler to auto start/stop to capture SSAS synchronization?