Hi,

Querying column with same name in main and referenced dimension results in
the below error.


*Launching query failed cause:No driver accepted the query, because
Ambiguous column C1, in dimensions main_dimension and reference_dimension*

Lets say main_dimension has columns C1 and C2 where C2 points to
*reference_dimension* column R1(foreign key). If column names C2 and R1 are
same, queries like below cannot be executed.

*query execute cube select C1, C2, reference_dimension.R2 from
main_dimension*
*query execute cube select C1, reference_dimension.R1,
reference_dimension.R2 from main_dimension*

Where R2 is some other column in reference_dimension

-- 
Regards,
Gokul

Reply via email to