Skip to Content

Data Preview for Analytic View does not work in SAP HANA Cloud trial account

Hi all,

I am following this excellent blog Using HANA Modeler in SAP HANA Cloud Platform

Modeling works pretty well. E.g. I can model and upload tables, create and activate attribute views and analytic views. Data Preview for attribute views works fine as well. However when trying Data Preview for Analytic View a pop-up occurs with message

SAP DBTech JDBC: [257]: sql syntax error: Error:insufficient privilege: Not authorized at ptime/query/checker/query_check.cc:2443

After that the analytic view is displayed without any objects.

Consuming the same analytic view with advanced analysis excel works fine, all data is shown correctly.

Analytic Privilege is disabled in the definition of the Analytic View.


My database user DEV_.. does not have any analytic privilege, nor do I see any analytic privilege at the assigned roles. Might this cause the issue?

Does anybody manage to execute a Data Preview for Analytic View using a SAP HANA Cloud trial account?

Thanks for your answers!

Klaus

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 30, 2014 at 06:58 AM

    Hi Klaus,

    I tried HCP three months ago. I had the same problem and found why. We cannot do the "Data Preview" because the role (starting with NEO_) which is granted to you has no object privilege "BIMC_VARIABLE(_SYS_BI)" which is a prerequisite for "Data Preview". I've made a test for that, if you grant additional "BIMC_VARIABLE(_SYS_BI)" to a user/role, the user can do the "Data Preview" then.

    The problem is no one will grant "BIMC_VARIABLE(_SYS_BI)" to you in HCP. So, we cannot do "Data Preview", we can just select the activated analytic view in _SYS_BIC.

    Best regards,

    Wenjun

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 11, 2014 at 05:53 PM

    Hi Klaus!

    I know that this is an old post but I believe this could help someone. =)

    SAP made a procedure that solve this issue.


    "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS".


    Just open a SQL console and execute this procedure and you will be able to use the Data preview feature.


    CALL "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS".


    You can found more information on:


    Using HANA Modeler in SAP HANA Cloud Platform


    Thanks and Regards


    Felipe Antonio Maria

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 14, 2014 at 04:28 PM

    Hi

    i am having a problem with attribute view ( i am using 30 days trial editions in the cloud cockpit)

    after i created its activated well but it doesnt preview data

    it gives me this error:

    Please help!!!

    Thanks


    scr.jpg (821.4 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      It seems that your attribute view is not yet activated ( hence the grey diamond in your attribute view icon).

      Please activate the view and try again

  • avatar image
    Former Member
    Apr 30, 2014 at 07:01 AM

    In addition, at the end of Using HANA Modeler in the SAP HANA Cloud., there is a sentence:

    Some known limitations

    • Data Preview menu is not working from the SAP HANA Modeler or the SAP HANA Development perspective
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 08, 2015 at 05:21 PM

    Did you create your tables in DEV_ schema?

    If you did, delete your tables and recreate it in your NEO_ schema.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 29, 2016 at 06:16 AM

    Hi ,

    Even i have faced the same issue but i didn't get any message saying about Authorization.

    I was doing modeling in Eclipse earlier.

    Now i have hana studio software separately installed on my PC.And the data preview part is working fine for me.

    Add comment
    10|10000 characters needed characters exceeded