Skip to Content
Jan 26, 2010 at 10:23 AM

Create Same Variable for 2 differents queries


Hi guru's,

I try to create one same variable in query designer for differents queries whiche have not the same field. I explain:

For example, I have one of my query based on a ODS which has a field called EAN but its technical name is RIS_R1007_F57 and I have another query based on another ODS which has also a field called EAN with the following techincal name RIS_EANMD_F1.

I would like to create a report with 2 tables and each query inside with in the variable screen, a variable which seeks in the both tables.

Anyone has an idea?

Thanks in advance for your help.



Edited by: rahhaoui mohamed on Jan 26, 2010 11:39 AM