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. What is the importance of _SYS_BI_CP_ALL analytic privilege?Īnswer: _SYS_BI_CP_ALL analytical privilege gives access to read from all information model views. How you can use Data provisioning in SAP HANA studio?Īnswer: Go to SAP HANA Modeler Perspective → Data Provisioning.Ħ. Complex calculations which are not possible thru graphical approach can be created using SQLScript.ĥ.
Graphical based calculation views offer better performance compared to SQL based calculation views.īut in scenarios where graphical calculation views cannot implement business logic, we need to use scripted calculation view. Scripted calculation views are created using the SQL Editor. Graphical calculation views are created using the graphical editor. What are the different types of calculation view? Which one would you prefer?Īnswer: There are 2 types of calculation view possible. Non-Structural: Package contains both repository objects and sub-packages.Ĥ. Structural: Package only contains sub-packages. What are they?Īnswer: In the HANA, 2 types of packages can be created. There are 2 types of packages in content. Explain how you can avoid unnecessary logging information from being stored?Īnswer: You can avoid unnecessary logging information from being stored by pausing the replication by stopping the scheme-related jobs.ģ. What is the operating system supported by HANA?Īnswer: Currently SUSE Linux Enterprise Server x86-64 (SLES) 11 SP1 is the Operating System supported by SAP HANA.Ģ.
0 kommentar(er)
