If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Crossjoins in Cube

Started by mindbender, 12 Mar 2007 01:29:58 AM

Previous topic - Next topic

mindbender

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..

John Doe

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..)