This content has been marked as final. Show 1 reply
Answers to your questions are as follows:
*1) Does it effect the performance of the OBIEE server.*
No. This is part of the Oracle BI Repository modeling process for Oracle BI 10g.
*2) Cons with row wise initialisation block used for implementing security which uses Oracle customise function in it. this initialisation block is been created for implementing 2 level security.*
There really aren't any cons. To get the security you are seeking row-wise security in Oracle BI 10g is the route you must take. In addition, this process is used widely in Oracle BI 10g for numbers of consecutive users and total users/groups in an LDAP or security group table ranging from hundreds to tens of thousands with nothing but success. So, don't worry about implementing this as your implementation will be sound by configuring row-wise security.