Hi ,

I need to create an MDX query that will return the value 0, is it
possible to do this without the use of measures/dimensions etc?

As an example what I want to recreate is the SQL below using MDX:

select sum(sales), 0, 0 ,0 ,0 from SalesTable

My problem is that I cannot get the MDX to bring in the fixed values
(zeros).

Thanks

Lxkash