Error while using select statement on Analytic View.

[Former Member]

Hello All,

I am getting a below error while I tried to use Analytic View using Select statement.

Could not execute 'select * from "_SYS_BIC"."zretailcoe/ZAN_SALES_ACTUAL"' in 887 ms 919 µs .

SAP DBTech JDBC: [7] (at 25): feature not supported: cannot execute select * on olap cube: zretailcoe/ZAN_SALES_ACTUAL: line 1 col 26 (at pos 25)

How do I use Analytic View as a table in my store procedure?

Thanks

Vinoth

[former_member182114 · Accepted solution]

Hi Vinoth,

You can't use select * on analytic scenario. You must inform the fields and do the aggregations (sum/max/min/avg...) and the group by at end.

Personally I use the data preview to "generate" the first select with all keys and sums....

Data Preview -> Raw data -> double click on Show Log and look for the line with generated SQL.

Regards, Fernando Da Rós

[Former Member]

Hello,

You could use CE_OLAP_VIEW

This operator returns results for an existing Analytical View. It takes the name of the Analytical view and optional list of KFs and dimensions as parameters.

Please refer to http://help.sap.com/hana/SAP_HANA_SQL_Script_Reference_en.pdf for syntax.

Regards,

Hema