61.What is the prerequisite for doing the currency conversion?
You need to import tables TCURC, TCURF, TCURN, TCURR, TCURT, TCURV, TCURW and TCURX.
62.What is the prerequisite for Unit of Measure?
You need to import the tables T006 & T006A.
63.What happens when you activate an object in HANA?
When we activate an object, it becomes available for reporting and analysis. After successful activation of a view, a run time object is created in _SYS_BIC schema.
For example, suppose there is a calculation view CV_VIEW1 in package “MyPackage”. After activating this view, a run time object (column view) will be created in _SYS_BIC schema with name “MyPackage/CV_VIEW1”. This column view is used when we do the data preview of calculation view.
64.What is the difference between Activate and Redeploy?
- Activate - Deploys the inactive objects.
- Redeploy - Deploys the active objects in one of the following scenarios:
If your runtime object gets corrupted or deleted, and you want to create it again.
In case of runtime problems during object activation, and the object status is still active.
65.How do we control row-level access in HANA?
Analytic privilege can be used to maintain row-level access.
It is used to grant different users access to different portions of data in the same view depending on their business role.
It is used to grant different users access to different portions of data in the same view depending on their business role.
66.What is the importance of _SYS_BI_CP_ALL analytic privilege?
_SYS_BI_CP_ALL analytical privilege gives access to read from all information model views.
We can control this by creating our own analytical privileges and assigning it to only the views that a user should be reporting against and at the level they want to view data.
If a user has the _SYS_BI_CP_ALL Analytic Privilege assigned all other restrictions are ignored. This is generally used for developer roles.
We can control this by creating our own analytical privileges and assigning it to only the views that a user should be reporting against and at the level they want to view data.
If a user has the _SYS_BI_CP_ALL Analytic Privilege assigned all other restrictions are ignored. This is generally used for developer roles.
67.Suppose we want to give minimum authorization to end users so that they can only see the output of modeling views. The users should not be able to perform any other activities. What are the privileges that should be assigned to user?
We need to assign following privileges:
- Read access to the package containing modeling view
- Execute & Select access on _SYS_BI
- Execute & Select access on _SYS_BIC
- Execute on REPOSITORY_REST
68.What are the types of schema in HANA?
In HANA, there are 3 types of schemas.
- User Defined Schema: These are created by user (DBA or System Administrator)
- SLT Derived Schema: When SLT is configured, it creates schema in HANA system. All the tables replicated into HANA system are contained in this schema
- System Defined Schema: These schemas are delivered with the SAP HANA database and contain HANA system information. There are system schemas like _SYS_BIC, _SYS_BI, _SYS_REPO, _SYS_STATISTICS etc.
69.What is the difference among Raw Data, Distinct values and Analysis while doing the Data Preview?
- Raw Data: It displays all attributes along with data in tabular format.
- Distinct Values: It displays all attributes along with data in graphical format.
- Analysis: It displays all attributes and measures in graphical format.
70. What is Hierarchy? What are the types of hierarchy supported in HANA?
Hierarchies are used to structure and define the relationships among attributes in a modeling view. Organizations define hierarchies for information classification, allowing roll-up and drill-down analysis. For example, a sales organization might allocate a sales person to a country and a country to a region. Sales data can then be aggregated and analyzed by region, country, or sales person.
There are two types of hierarchies:
- Level Hierarchies are hierarchies that are rigid in nature, where the root and the child nodes can be accessed only in the defined order. For example, organizational structures, and so on.
- Parent/Child Hierarchies are value hierarchies, that is, hierarchies derived from the value of a node. For example, a Bill of Materials (BOM) contains Assembly and Part hierarchies, and an Employee Master record contains Employee and Manager data. The hierarchy can be explored based on a selected parent; there are also cases where the child can be a parent.
No comments:
Post a Comment