The query does not reference any table when attempting to build the WHERE clause. (IES 00022)

[former_member360582]

Hi

I am getting below error.

The query does not reference any table when attempting to build the WHERE clause.  (IES 00022)

This error is in Validating Measue object in IDT.

It is not throwing error for dimensions objects but only for measure objects.

My BO version is 4.1

Backend is Teradata 14.1.

Regards

Gaurav.

[Former Member]

If your conection relational is Bw. Please change  the name or description name  Try don´t use (), special characters or restricted characters in description name

[former_member419024]

Im facing the same error, any solution found?

After remove prompt then I get this error.

[former_member4998]

Hi

In the dimension/Measure definition, you can select the table. Find the below screenshot.

If you still getting the issue…Can you please share your screenshot, for better understanding the issue?

[Former Member]

What is the syntax used for the object, both in the select and in the where clause?

[former_member497916]

Hi Gaurav,

Try to manually assign a table for this object.

Regards,

Sandeep