on 05-07-2014 7:56 AM
Hi Experts,
I am working on HANA DB. I have created analytical view over tables and also made a copy of predefined analytical view for example:
While I am trying to access the throw IDT Connection it throwing error on displaying data of analytical view.
Eorr is: "SAP DBTech JDBC: [7]: feature not supported: not allowed over OLAP VIEW : search without aggregation or grouping by expression other than view column"
Even I am not able to display data on IDT under the business layer same error occurs:
Thanks in advance,
Manoj Kumar
Hi Manoj, I see you asked this question a while ago but i had the same error and was able to figure it out. If you go to your analytic view, and select data preview. If everything is right, you will see your data. In the top right is a show log button. From there you can see the SQL used to view your Analytic view. Hope that helps
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Manoj,
I was facing the same issue and solution which worked for me is:
1. Created a calculated column in analytic view.
2. In the SQL Script section of calculation view i used an aggregation function (SUM) on the column which i created in the earlier step followed by GROUP BY clause.
Conclusion:
Basically what i understood from all the reading i have done related to this error is: Whenever we use an Analytic view in a Calculated View a GROUP BY clause is necessary which in turn requires us to have an Aggregation Function in our query.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.