Posts

Showing posts from March, 2014

Resolve Performance Issue with HANA Filter Variables (used as prompts) in Analysis for Excel

Image
In this blog, I will discuss the performance issue which I experienced while selecting input variables/filters (prompts) for HANA information view consumed directly in SAP Analysis for Excel 1.4 SP5. This performance issue might be faced during consuming HANA information view with large amount of data.

Usually in SAP HANA we create variables to filter the data in HANA information view at runtime or design time. For example, in following window we have a variable for "Plant".



Let's look at the filter variable created in SAP HANA for attribute "Plant". This variable will display values from column "Plant" from same information view. When user click on browse button (as shown in above image) then it display these values.




When user clicks on browse button to select value for "Plant" variable then it generates a SQL statement. Let's look at the SQL statement captured from Analysis for excel log file. I ran that query in SAP HANA Studio to captu…

SAP HANA Content Security Roles Setup

Image
A few months ago I was given a task to implement content security in SAP HANA. The main purpose for this task was to provide Business user access to information models created in SAP HANA. For example Finance user should only view finance package and can access information models in that package via BI tools such as Analysis for excel.

So, after a research and few discussions with various people (one of them was from SAP Melbourne) I came up with following security model.

















Let's assume that content is maintained in following structure:



So based on each type of privilege I created the roles as shown below:

System Privilege Roles

These roles are mainly needed for System admin tasks (technical role)

X_HNS = S for System Privilege role


Role Name Privilege Type Assigned <