on 03-03-2014 8:04 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Did you create your tables in DEV_ schema?
If you did, delete your tables and recreate it in your NEO_ schema.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
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
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
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
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.
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
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
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
In addition, at the end of Using HANA Modeler in the SAP HANA Cloud., there is a sentence:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.