Select from Analytical View

[Former Member]

Hello,

I'm trying to do select from Analytical view.

In some Analytical views I succeed but in others I get the message:

What am I doing wrong?

Thanks,

Amir

[former_member182302 · Accepted solution]

Hi Amir,

If your analytic view has a calculated column then the select query works since even though it is analytical view because of calculated columns it creates additional calculation view like wrappers and hence select works

On the other hand if it doesn't have a calculated column you will get the error you mentioned, in this case you must use the select query with group by clause to solve the issue

Regards,

Krishna Tangudu

[justin_molenaur2]

It would likely help speed up analysis if you provided the SQL you are trying to execute rather than just provide the error message alone.

But as Krishna stated, when selecting from an AN you need to always use aggregation functions and group by.

SELECT COL1, SUM("MEASURE1")

FROM AN

GROUP BY COL1

Regards,

Justin