Customising MDX

Andreas187

Is it possible to customise the MDX when extracting data from one Essbase cube for import into another.

So instead of this which exports all dimensions into a text file (I have paraphrased the code!):

SELECT Dim1 ON COLUMNS,

{Dim2.Lev0, Dim2.Lev0, Dim3.Lev0, Dim4.Actual, Dim5.Product1, Dim6.Entity1} 

ON ROWS FROM database

I would like to exclude dimensions that aren't necessary in the destination cube

SELECT Dim1 ON COLUMNS,

NON EMPTY {Dim2.Lev0, Dim2.Lev0, Dim3.Lev0} 

ON ROWS FROM database

WHERE (Dim4.Actual, Dim5.Product1, Dim6.Entity1)