Bring all the columns from tabular SQL

[ajen7118]

Hello,

I have a tabular SQL and trying to bring all the columns to the report from the tables I joined.

ex:
select *
from A, B, C
where .....

However, it always pops out an error message said "The server returned an unrecognized query framework response"

It will work if I specify
select A.data, A.time, B.cd etc.
from A, B, C
where .....

is there anyway to work around for me to show all the columns? Thank you

[ajen7118]

anyone can help?

thanks.

[Lynn]

You have already identified the work around to show all columns. You need to list them. Once you do that you can include them in the query subject that is fed by the tabular SQL and set any properties as desired or needed.

Is there a reason why this is a problem?

It is not a good practice to use tabular SQL as the preferred approach would be to model your data source properly in Framework Manager and publish a package that can support reporting requirements.

[Michael75]

If you absolutely have to use tabular SQL, you can avoid having to specify all the columns by doing

select A.*, B.*, C.*
from A, B, C

[ajen7118]

Thank you.

The problem is there are some columns with the same columns' name in different tables.

For example,

Table A -- Columns --> CD, name, number, data
Table B -- Columns --> CD, org, div, project
Table C -- Columns --> Org, time, type, lev1name

I am still getting the error to bring in all the columns when I validated the SQL.

Thank you so much for your help.

[bdbits]

You can't ever have multiple columns with the same name in your result set, and the default name is the column name with no qualifiers. There is no way around that.