Hi,
I have created a cv view with Analytic Privilege option selected as 'SQL Analytic Privilege'. And i have not assigned this CV to any Analytic Privilege i.e. SQL.
When i try to query the CV View , i am getting Insufficient Privilege Error.
...
Hi,
I have created an cv view with data category Cube and when queried with required columns, the view is executing successfully. There query is getting logged in m_expensive statements. However, it is not getting in logged in m_sql_plan_cache....
Hi,I have created a table using hana HDBDD file. Created HASH and Range Partitions on particular columns of the table. When I try to add any new column to the existing table via HDBDD file, the existing partitions are getting merged. Could you please...
Hi,I have created a calculation view with data category as "Cube" and Star Join Enabled. The fact table(Table A) has been projected to Star Join node and then in the star join node it has been joined with CV dimensional view which is created using Ta...
Hi Lars,
Thanks for your reply. However, i dont have access to view the SAP note.
Could you please in brief about this execution hint and how does it will be helpful by using in the CV View.
Thank You,
Raviteja Purama
It is like select * from m_sql_plan_cache where user_name = 'userid' and statement_string like '%string_name%'.
One more thing, I have used the existing CV Views in the new CV View i created.
When i set the execution hint ce2qo_disable_unfoldi...
Hi,
I think that's how the star join works. In case of your requirement, move out the Leftouter Join with out of Star Join and you need to do the required calculation on top of it.
Hello Etienne,
There is a option called 'Auto Documentation' which will have all the details mentioned in your question.
Right of the click on the view and you will find it.
Please check.
Thank You,
RP
