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

[klausfreyburger]

Hi all,

I am following this excellent blog

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

[Former Member · Accepted solution]

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

[damodar_sai_mallika]

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.

[Former Member]

Did you create your tables in DEV_ schema?

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

[klausfreyburger]

I used the NEO_schema.

Best regards

Klaus

[Former Member]

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:

Thanks and Regards

Felipe Antonio Maria

[klausfreyburger]

Thanks Felipe.

I was using this CALL "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS" already. Does not help in this case.

[Former Member]

Hi,

Is this still the case? Are you able to do a "open content" from the SYS_BIC column views for a analytic view  created under the trial account? Please let me know.

Thanks,

[klausfreyburger]

Hi,

> Is this still the case?

yes it is.

> Are you able to do a "open content" from the SYS_BIC column views for a analytic view 

there is no menu item "open content" for an analytic view. However there is a menu item "Open Definition" which gives message "insufficient privilege"

For calculation views there are menu items "Open Data Preview" and "Open Content" in _SYS_BIC which both work fine.

By the way: Open Definition" for calculation views gives message "insufficient privilege" as well.

Thanks

[Former Member]

Thanks for the prompt and helpful reply Klaus.

[robson_soares]

Hi Felipe,

For me this statement results the following error:

Could not execute 'CALL "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS"' in 4.159 seconds .

SAP DBTech JDBC: [10001]: user-defined error:  [10001] "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS": line 45 col 14 (at pos 2187): [10001] (range 3) user-defined error exception: user-defined error:  [10001] "HCP"."GRANT_PRIVILEGES_ON_MANAGED_REPO_OBJECT": line 21 col 3 (at pos 1020): [10001] (range 3) user-defined error exception: user-defined error:  [10001] "HCP"."DEPENDENCY_VALIDATOR": line 90 col 9 (at pos 4690): [10001] (range 3) user-defined error exception: Checking object: schema: _SYS_BIC, object: pXXXXXXtrial.myhanaxs.sap-hana-tutorial/AT_REGION. User DEV_XXXXXXXXXX is not authorized for:  Object: REGION Schema: DEV_XXXXXXXXXX Type: TABLE.

Remarks:

1) user and schema names were intentionally omitted;

2) I'm able to see data from REGION table via context menu.

[Former Member]

Hello Klaus,

I'm stuck on the same issue, so wondering if this has been resolved?  If so, what's the solution? 

Thanks!

[klausfreyburger]

no solution. I am using calculation view as workaround.

Regards

Klaus

[former_member213240]

Hi Robert,

Please remove all the objects from the schema "DEV_****" & "_SYS_BIC". You can create all your catalog objects in the schema "NEO_****" only .

Once corrected, please run the below code in the SQL console

CALL "HCP". "HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS"

or

CALL "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS" ("<package>", "<analytical_vew>")

You will see all your views at the schema _SYS_BIC --> Column Views for Data Preview.

Regards

Dinesh

[former_member234801]

Hi Klaus,

Did you discover anything further about these limitations ? Seems quite annoying that you are unable to preview the data in Analytic Views ?

Cheers, Jim

[klausfreyburger]

Hi Jim,

> Did you discover anything further about these limitations ?

no

> Seems quite annoying that you are unable to preview the data in Analytic Views ?

I agree.

Best regards

Klaus

[former_member213240]

Hi Klaus,

There is a workaround to view data from analytic view in the trial account. You can convert the analytic view into calculation view (not literally) using a dummy calculated column (attribute).

Please check my blog for details.

Regards

Dinesh

[Former Member]

Dear All,

I stumbled on the same issue. Data Preview for Attribute Views works fine (after applying CALL "HCP". "HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS"). For Analytic Views I don't get the data shown.

Following Dinesh's solution, I noticed that there is a difference to my environment.The directory column views of _SYS_BI is entirely empty. I only see my views under "Content". Is there a step I missed?

I added a calculated column to AV_SALES as proposed by Dinesh. This did not helped here.

Br,

Tobias

[klausfreyburger]

Hi Tobias,

after CALL "HCP". "HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS" you should see the Analytic View in schmea _SYS_BIC (not _SYS_BI).

Did you refresh the catalog tree?

For me the workaround proposed by Dinesh worked fine.

You have to watch that the Calculated Column has "Column Type Attribute" (which is the default).

Best regards

Klaus

[Former Member]

Hi Klaus,

thanks, that did the trick!

Br,

Tobias

[Former Member]

Hi Klaus,

I was wondering if you tried using input parameters in the Analytic views.

I am currently studying the EPM demo model provided as a part of SHINE OPEN SAP.

The model contains an analytic view called Purchase_common_currency, this view accepts currency code as input.

In an ideal scenario, when the data preview on this view is selected via content folder, it prompts for the input parameter and then process the data.

Problem I'm facing while accessing data preview on this view via the SYS_BIC column views is that the data preview does not prompt for the input parameter.

As a result, there is no currency conversion and the resultant raw data set displayed does not match the desired functionality.

Let me know your thoughts.

[klausfreyburger]

> I was wondering if you tried using input parameters in the Analytic views.

No, I did not.

Best regards

Kaus

[radoslaw_kotowicz]

Hi Klaus/All,

I am trying to understand if the workaround suggested by Dinesh still works for the trial account. I made a test myself yesterday and it seems that the data preview is not available for analytical and calaculation views. Neither in the studio nor via Excel MDX provider. The later pulls up a list of views but complains about the lack of priviliges to access BIMC_CUBES. Is anyone able to use the trial account with Excel pivot tables?

Thanks in advance,

Radek

[philipp_thiele]

Hi All,

I currently have the same problem as is described here. I wanted to run CALL "HCP". "HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS" but I can't because I have created a object in _SYS_BIC. Problem is, I can't see the schema "_SYS_BIC" hence I don't know how to delete the view I created. Anyone an idea how to solve this problem?

Thanks in advance,

Philipp

[former_member185671]

Hi Philip,

First of all make sure you restart Eclipse some times.

I think there was a downtime so maybe that was the reason.

Best,

Christoforos

[former_member189905]

Hi Dinesh,

could you say me what is the utility of he schema user DEV_ ?

Why I can't create my objects in this schema ?

Thank you.

KT

[OliverGoetz]

Hi KT,

the idea behind the DEV_ users was to use a different database user than the one the application itself is using (the NEO_ user), so that this DEV_ user can be tied to an personal user for the purpose of better traceability who was doing what in the HANA system, and also to allow a better access control (e.g. revoking certain privileges from such a "Development User" while retaining them for the application user and for other developer users in the same account).

Having said that, for the Trial accounts this may well be perceived as unnecessary overhead (and it might be just that), since in Trial accounts you usually have a one-to-one relationship between account and user.

But don't expect this to change in the Trial offering we have today. Bigger changes are on the way, as we plan to change the HCP HANA Trial offering more fundamentally in a way that makes the development experience much closer to what you get for productive instances.

Best regards,

Oliver

[former_member189905]

Hi Olivier,

thank you for your respond.

KT.

[Former Member]

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

[Former Member]

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

[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