Top 10

[Sonia Martín Temiño]

Hola,

Quiero sacar los 10 registros con mayor importe de una tabla con consulta MDX, pero me da error.

Alguien sabe como hacerlo?

SELECT [Measures].[ImportePedidos] ON 0,
TopCount
([Cliente].[Cliente].Members
, 10
, [Measures].[ImportePedidos]
) ON 1
FROM [Pedidos]
WHERE([Familia].[Familia].Members)

Esto me da error:

Mondrian Error:Internal error: Populating member cache with members for [[Cliente].[Cliente]]; sql=[select `penvcliente`.`cliId` as `c0`, `penvcliente`.`cliNombre` as `c1`, sum(`pencliped`.`pedBaseImpo`) as `c2` from (select * from penvcliente where clientidad = 2) as `penvcliente`, (select * from pencliped where pedI..........
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SQL_SELECT_LIMIT=10' at line 1

Trabajo con la versión;

Schema Workbench
Product Version : 8.1.0.0-365

En sql no tengo problema, pero necesito que la consulta sea MDX

SELECT T1.empNombre, FORMAT(T1.importe, 2, 'de_DE')
FROM
(
select distinct empNombre AS empNombre, SUM(facBaseImponible) as importe
from penprofac fac
join penvproveedorcompras cli on fac.empCodigo = proID
and fac.facIdEntidad = cli.IdEntidad
group by empCodigo
order by importe desc
limit 10
) AS T1;

Gracias.

Saludos,

Sonia