Angad Singh's Blog

In recent project, we faced a scenario where we needed to change the data source location for a Analysis Application. It can be required in following cases: You have moved your underlying HANA model to new package You have renamed your underlying HANA model in same package You have changed the connection and moved your underlying HANA model to new package You have changed the connection but underlying HANA model is still in same package In our case, I  changed the connection and moved underlying HANA model to new package. This feature is  called "Exchange Data Source" in Design Studio. The version of Design Studio is 1.4 and BI Platform is 4.1 SP05.  So I followed following steps to make existing Analysis Application working. First of all, backup. So, copy the Analysis Application to other folder (for example \Public Folder\Sales & Distribution\ or to your favourite folder) in BI Platform. Open Design Studio and connect to BI Platform. Ope...

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 Privileges X_HNS_USERADMIN This role can create users, change th...