Maintain SAP BOBJ  security settings, Disable Edit and design for public folder reports

Maintain SAP BOBJ security settings, Disable Edit and design for public folder reports

Blogs, SAP
Learn how you could add Security settings to SAP BOBJ server 4.2 or higher. This article talks about some of the common security settings that can be applied for BOBJ implementation project. Learn how you could Maintain SAP BOBJ security settings, Disable Edit and design for public folder reports. These settings may not already exist by default in the system but is strongly recommended as these are some of the best practices we followed by working with clients and helps to meet the business requirement. Security Settings like To hide folders To restrict Save on Public folder Not allow design button to be enabled Export issue where report default file format comes as .pdf instead of XLS or XLSX : This is not really a security setting but system limitation and…
Read More
SAP BOBJ Troubleshooting tips & fixes applied

SAP BOBJ Troubleshooting tips & fixes applied

Blogs, SAP
Introduction This article talks about some of the fixes and SAP BOBJ Troubleshooting tips and steps applied for common issues. It covers some common issues and bugs faced by the client and how these can be fixed. Please refer to a section further to find about details of the issue and the fixes we applied for the below issues: Opening a report gives an error “Following Database error occurred: The driver returned invalid SQL_DRIVER_ODBC_VER Error in exporting the file “Sorry Promotion Management application is unable to process your request” & HTTP STATUS 500 error Connection Error: [Microsoft][ODBC Driver Manager] The specified DSN Contains an architecture mismatch between the driver and the application ERROR PublishingService: HandlerPool-Q Failed: The document's serialization version is too recent. Publication not being able to schedule. Web application not…
Read More
SAP Custom Search help creation & understand Elementary and collective search help

SAP Custom Search help creation & understand Elementary and collective search help

Blogs, SAP
Add custom search help by modifying the standard search help Fix the issue for user being able to select multiple options but after selecting it does not populate the window Find technical information to add SAP custom search help Find the technical information for the specific search help by clicking F1 and find the table name as V_PRSMP Using where used find the specific search help that uses the table Below is the search help which uses that view. Check PRSMP search help and find that it is an elementary search help. So, check if there is any other search help linked to it. Found the search help PRSM from the where used The search help PRSM is a collective search help You can find the corresponding user exit in…
Read More
Learn how to export and import files from BOBJ server

Learn how to export and import files from BOBJ server

Blogs, SAP
In this blog, we will be cover export and import files from BOBJ server and how it can be used to meet the reporting requirement. This blog covers below topic areas: Overview to help understand what BOBJ does. Steps to export a file Steps to import a file Overview Before we start, on a very high-level SAP BOBJ is a comparable product to what Power BI/SSRS does in the Microsoft world. It has some basic feature and functionalities like: Create daily reporting and dashboarding needs Schedule as a job and send email to stakeholders Manage user security to a very minute and detailed level to give only as much access as needed Ensuring users can only changes specific report attributes and allow them to save reports only locally and not override…
Read More
CRM Bol programming Make fields editable and display only

CRM Bol programming Make fields editable and display only

Blogs, SAP
This article covers the basics of how you could control the UI element using CRM bol programming and understand the technical objects which can be used to modify the display property on the UI. The article covers these 5 topic areas below: 1. Requirement 2. Finding the UI component 3. Opening the corresponding UI component from backend 4. Find relevant technical objects to modify 5. Code changes to make the field display only or editable 1. Requirement: Disable a UI element For customer overview screen when user clicks on edit to update the address information the next screen should be editable / display based on business rules. Check the below screen phone/ fax mobile screen should be editable based on mobile Number 2.    Find the UI component Right click on…
Read More