If columns have same names and you are accessing more than one olap entity - cube/dimension in the query, you need to give <cube>.col or <dimension>.col to resolve ambiguity in the query.
Thanks Amareshwari On Mon, Feb 23, 2015 at 1:28 PM, Gokulakannan M (Engineering - Data Platform) <[email protected]> wrote: > 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 >
