merge dimensions sql

building reports webintelligence
1

Hi All,

For merge dimension - is there a way to see the entire sql for the two data providers.

Is it correct that since the merging is done at the report level, one sql is not generated?

ajq

anushajq (BOB member since 2005-02-22)

2

If you view SQL within the query panel you will see what is happening. You will have to view the SQL for each data provider in a separate step.

The “join logic” used to merge the two (or more) data providers is found in the “merge dimension” screen, and does not show SQL since it’s done by the report engine rather than the database.

Dave Rathbun :us: (BOB member since 2002-06-06)