Posts

Showing posts from October, 2011

Row Level Security (RLS) in SAP BO

Row Level Security limits the rows(data) a user/group can view. This is implemented using Supervisor in previous versions of BO.From XI we can implement Row Level Security in Designer.We can use @Variable('BOUSER') in where condition area of an Object Definition.for eg: Employee.EmployeeId  is the object, Go to object properties in Select--we write Employee.EmployeeId, in Where write  Employee.EmployeeId=@Variable('BOUSER').This gives the values related to Employee who logs in.In this way we can implement Row level Security. We also have another way in which we use "Manage Access Restrictions".In Designer->Tools->Manage Security->Manage Access Restrictions-->Give a name to restriction -->In Row tab(select table & give a condition eg:Country.CountryName=Singapore or CompanyCode=1010) -->Assign this restriction to a Group/User. This restricts a user(eg.Singapore sales Manager) to access values coresponding to Singapore. We can als

SAP BO Integration Step by Step (Windows)

Image
If the Version is BO Enterprise XI 3.0/3.1, If it is SAP BI 4.0 it doesn't required. Follow the below Steps.   1. To Integrate BO Server with SAP ECC/BW Download appropriate SAP Integration Kit from https://websmp206.sap-ag.de/support   2. Extract the Compressed file. 3. Install the BO Integration Kit on BO server. 4. Open the Integration kit folder --> Transports folder. 5. Here we can find 2 folders for ANSI and Unicode Compatible . Before you get into these folders Open the file transports_EN.txt file 6. Most of the SAP Servers are Unicode. In this Unicode folder, we can see K, R files.             K:Cofiles R:Data files   7. Follow the Instructions in the text file. Copy the respective files with appropriate file numbers with K to the D:\usr\sap\trans\cofiles.  8. R files to D:\usr\sap\trans\data . These Paths(OS Level) are where SAP ECC/BW  got installed. 9.