Forum Stats

  • 3,814,410 Users
  • 2,258,870 Discussions
  • 7,892,703 Comments

Discussions

Customising MDX

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)