Hi,
Is there a possibility of getting a crossjoin for dimensions and measures which are directly picked from a cube.
When i`m viewing the Native MDX query i am finding the query to be starting with 'SELECT CROSSJOIN '
How could this affect my results..
You'll get a crossjoin if you nest dimensions on the same axis.
Further to that, if you are working with a crosstab, make sure you are viewing the MDX from the report layout (tools menu) rather than the Query object. If you view the MDX from the query object, the data is projected on to a single axis, and will not be reflective of your layout.
Viewing the MDX from the layout will give you a better indication of the true MDX (reflective of your crosstab - multiple axis, slicers, etc..)