The Performance for the generated SQL-Query
to get the rows during the Processing
from SQL-Server by the OLAP-Service is as shown:
SELECT DISTINCT "dbo"."XDIM01_50"."DDIM01GRP50", "dbo"."XDIM01_10"."DDIM01GRP10", "dbo"."XDIM01_10"."FDIM01", "dbo"."XDIM01_10"."DDIM01ID"
FROM "dbo"."XDIM01_10", "dbo"."XDIM01_50"
WHERE ("dbo"."XDIM01_50"."FDIM01"="dbo"."XDIM01_10"."FDI M01")
ORder by "dbo"."XDIM01_10"."FDIM01"


the same Results and faster Query is:
SELECT Distinct a.DDIM01GRP50,a.DDIM01GRP10,a.FDIM01,DDIM01ID
from tDIM01grp a cross join tdimgrptxt b
where (b.ddimnr=0 and b.ddimgrpnr in (50,10))
order by fdim01

Is it possible, to change the generated Query
during the Dimension-Processing?


Thanks

Michael