Do you have Entity property maintained in Interco dimension as well??? or only with Entity dimension? Because you have shown Entity dimension with Intco property but in select statement used the reverse.....