SAP-HANA
SAP HANA Architecture, LandScape, Sizing: Complete Tutorial
SAP HANA Database is Main-Memory centric data management platform. SAP HANA Database runs on SUSE...
Analytic Privileges restrict the user to view data for which they authorize. SAP HANA Analytic Privileges is used for Security purpose.
SQL Privileges provide authorization on object level not at a record level, so provide a record or row-level authorization "Analytic Privileges" will be used.
SAP HANA Analytic Privileges are used to provide authorization on below information view –
Now we are going to create an Analytic Privileges and will assign to user "ABHI_TEST", by this Analytic we restrict the user to view data only for a company with value 1000.
Step 1) Go To option as below-
Modelling package (Right Click) --> New -> Analytic Privileges.
Step 2) New Analytic Privilege popup appear
Click on 'OK' button, in next step Analytic Privileges editor will be displayed for add and edit privileges.
Step 3) Analytic Privileges editor will open as below-
Validate and Activate Analytic Privileges, an analytic privilege is created in Analytic Privileges folder under Modelling package as below -
Step 4) Now we are going to assign Analytic Privileges to User "ABHI_TEST". "ABHI_TEST" user have privileges to access modelling package.
Double click on User "ABHI_TEST" from Security -> Users.
Analytic Privileges is added as below -
Step 5) Now, we deploy this changes in user by clicking deploy button.
A message is displayed as below –
User 'ABHI_TEST' changed.
Step-6) Check Analytic Privileges Assign to user "ABHI_TEST" is working or not.
Login to "ABHI_TEST" user by select HANAUSER system as below –
ABHI_TEST user has no full access of data of Calculation view created by HANAUSER, as HANAUSER has created analytic privileges for restriction on this calculation view for the company -1000 and assign to ABHI_TEST user.
So, Go to Content Folder -> Select Package -> Calculation View (CA_FI_LEDGER) ->Right Click -> Data Preview.
Data Preview screen will be displayed as below-
Data in calculation view will be restricted for company code– 1000.
SAP HANA Database is Main-Memory centric data management platform. SAP HANA Database runs on SUSE...
SAP HANA Operator can be used for calculation, value comparison or to assign value. SAP HANA...
What is DATA Provisioning? DATA Provisioning is a process of creating, preparing, and enabling a network...
What are Attributes? Attribute view acts like a dimension. It join multiple tables and act as...
What is SAP HANA Analytic view? SAP HANA Analytic view is based on STAR Schema Modelling, and it...
Import and Export option of SAP HANA Provide features to move tables, Information View, landscape...