cancel
Showing results for 
Search instead for 
Did you mean: 

HANA calculation view ( table restriction)

former_member195748
Participant
0 Kudos
731

Hello SAP experts,

I have a simple scenario. I have created a Calculation view on 2 tables, Table - X and Y.

There are 2 users- "Thor" and "Hulk". THor has full access, but I want to restrict "Hulk" .

How do i restrict "Hulk" to only see data from Table X. as soon as i give both users "_sys_bic.CV" access both users
can see all the data , unless i create Analytical Privilge and restrict them the row. But my scenario is to restrict/not authorize HULK unless he gets TABLE access.

In short, is there any way data access on TABLES can be restricted in calulation view ( not just the rows).

Regards,

Vivek

View Entire Topic
bdc_erp
Participant
0 Kudos

as far as I know, there is no such feature in HANA CV authorization.

I think Analytical Privilege is the best way to get data filtered, otherwise you may create a customize authorization table to join source table:

Customize Table:

| User | Source |

| Thor | X |

| Thor | Y |

| Hulk | X |

Source Table :

| Source | Column A | Column B | Column C | Column D | Column E |

| X | a1 | b1 | c1 | .. | .. |

| X | a2 | b2 | c2 |.. | .. |

| X | a3 | b3 | c3 |.. | .. |

| Y | .. | .. | .. | d1 | e1 |

| Y | .. | .. | .. | d2 | e2 |

former_member195748
Participant
0 Kudos

Hey Jing Shen,

Any Idea if use of HDI can solve this issue

Regards,

vivek

bdc_erp
Participant
0 Kudos

@vivek singh

your question may regard SAP Web IDE for SAP HANA, the answer is NO

BR,

Jing