Remove "From" Box from BILaunchPad - Schedule your Report

Hello,

Today, I will be writing about scheduled reports - removing from section on Business Objects 4.1.

First of all, logon to your Business Objects server, and stop Tomcat on Central Configuration Manager 

When you stop Tomcat, users will not be able to connect web services. (BI, CMC etc)

Create a copy of BILaunchpad.properties file, which is located in
\Program Files (x86)\SAP BusinessObjects\Tomcat\webapps\BOE\WEBINF\config\default

Original file will not be changed.  We will be working on the copy of the file.

Open the file in notepad and find the line below :

# Shared Destination From Field.  Enables or Disables the From field when scheduling a object to a destination.  When the value is set to false the From field will not be rendered and the system will first attempt to get the email value from the report default, if report default is not available it will attempt to get the value from the email address on user profile of the logged on user and lastly if the user profile email address in not available it will use the job server default SMTPFrom=true

If you change it to SMTPFrom=false , users will not see "From" box when they schedule their report.

You can manage the default from e-mail address through CMC - Adaptive Job Server.

With this configuration, users will receive the scheduled reports from a single e-mail address.

When you finish your work on BILaunchPad.properties, copy the file to

Program Files (x86)\SAP BusinessObjects\Tomcat\webapps\BOE\WEBINF\config\costum

To make your changes stable, also copy BILaunchPad.properties file to

Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\warfiles\webapps\BOE\WEB-INF\config\costum

If you don't copy the file under warfiles, your changes will be lost after a SP - FP upgrade, and the system will be back to default settings.

When you are done with BILaunchPad.properties file run Wdeploy.

I prefer to delete Catalina folder and restart Tomcat. You can find Catalina folder under

Program Files (x86)\SAP BusinessObjects\Tomcat\work

Catalina folder will be recreated, and it may take sometime.  Usually, folder size is near 1,35 GB.  It depends on the system components.  For example, if you install SAP Explorer on your system, the file size will be increased.

Please reach me from my e-mail address if you have any questions.

Events in Business Objects

Aloha!

Today I want to talk about a great feature of Business Objects. Events!

What is "Event"?

Basically, they are flags.  I also call them safety belt :)
With event mechanism, database tables can be watched and afterwards reports on BO can be triggered.
Also reports can be triggered sequentially.

Events are created on CMC, but can be used both on CMC and BI.

What are the types of "Event"?

1. Custom Event
2. File Based Event
3. Scheduled Event

1. Custom Events
Not much to do!  Type in the name and description. Totally manual.

2. File Based Event
My favorite.  This event waits for a file on a location to be triggered.
For example, let's say your report is created by the data of Table A, then you will need to be sure ETL process of Table A has finished.
If your ETL process leaves a flag after completion, you can create an event, and let your report wait for this flag.

 3. Scheduled Event
This event is used to run your reports sequentially.  Status can be modified by the user.  Success / Fail / Both  
For example, report B to be run when report A has finished successfully.
Or when report A fails, report C has to run.  

How do we create Event?

•  Log on to CMC  
• Select Events
• Choose New Event
• Choose your Event Type

• Type in event name (necessary), description (optional)

How will you use Events on your Reports?

When BO reports, publications etc. are being scheduled, you can see Events tab on the left corner.

You can easily add the events to your schedule.

Events to wait for 

When you add your event to this section, your schedule will wait for this event to occur first.  

** If you add File Event to this section, flag must be placed to the stated location, 

after the reoccurrence time

Event names are not parametric, so this is a great way to control your events.

Events to trigger on completion 

This option is used for schedules to run sequentially.  You can only add schedule based event to this section.

I think Event mechanism is a great way to inhibit wrong report distribution.  

Take care and please write me your ideas.

See you on the next post!

Business Objects 4.1 - BI üzerinde Schedule Edilen Rapordan From Seçeneğini Kaldırma

Merhaba!

İlk konumuz, çoğu kişinin bilmediği BI 4.1’de otomatik iletilen raporlardaki “From” seçeneğinin kaldırılması.

Bu işlemi yapmak için, Business Intelligence 4.1 kurulu olan sunucuya bağlanmamız gerekiyor.

Öncelikle Tomcat’i stop ediyoruz.  Bu işlemi Central Configuration Manager üzerinden yapabiliriz.

Unutmayın! Tomcat stop edildiğinde kullanıcılar sisteme erişemez. 

Gelelim yapacağımız işleme.

<INSTALLDIR>\Program Files (x86)\SAP BusinessObjects\Tomcat\webapps\BOE\WEBINF\config\default

dosyasının altından BILaunchpad.properties dosyasını açıyoruz ve kopyasını masaüstümüze kaydedelim.

Bu dosyayı notepad ile açabilirsiniz.  Buradaki aşağıdaki satırda 

# Shared Destination From Field.  Enables or Disables the From field when scheduling a object to a destination.  When the value is set to false the From field will not be rendered and the system will first attempt to get the email value from the report default, if report default is not available it will attempt to get the value from the email address on user profile of the logged on user and lastly if the user profile email address in not available it will use the job server default

SMTPFrom=true

SMTPFrom=false yazdığımız zaman, BI platformunda schedule işlemi yapılırken, kullanıcılar “From” seçeneğini görüntüleyemeyecektir.

From’da hangi e-mail adresi yazacağını ise, CMC üzerinden Adaptive Processing Job Server’dan belirleyebilirsiniz.

Bu ayarlama ile, schedule işlemini yapan kullanıcılarınızın raporlarının, tek mail adresinden iletilmesini sağlayabilirsiniz.

BILaunchPad.properties dosyasında değişikliklerinizi tamamladıktan sonra, ilgili dosyayı 

<INSTALLDIR>\Program Files (x86)\SAP BusinessObjects\Tomcat\webapps\BOE\WEBINF\config\costum

klasörü altına taşıyın.

Yaptığınız değişikliğin kalıcı olabilmesini sağlamak için, BILaunchPad.properties dosyasını

<INSTALLDIR>\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\warfiles\webapps\BOE\WEB-INF\config\costum

dosyasına kopyalamalısınız.  Değişiklikler bu klasörde değişiklik yapmasanız da sisteminize yansıyacaktır.

Ancak, herhangi bir SP - FP değişikliğinde - patch geçtikten sonra, tüm ayarlamalarınız, default ayarlarınıza geri dönecektir.

BILaunchPad.properties dosyasını çalıştırdıktan sonra Wdeploy çalıştırın.

Ben genellikle Catalina dosyasının ismini değiştirip, Tomcat’i açmayı tercih ediyorum.  Bu yöntemi denemek isterseniz, 

<INSTALLDIR>\Program Files (x86)\SAP BusinessObjects\Tomcat\work

altından bu klasöre ulaşabilirsiniz.

Dosyanın oluşması biraz zaman alacaktır.  Genellikle bu dosya, 1.35 GB boyutundadır.  Oluşması sistem hızına göre değişmektedir.

Umarım faydalı bir tanışma yazısı olmuştur :)

Lütfen yorum bırakın, merak ettiğiniz şeyleri sorun, yeni yazı konularımı beraber belirleyelim.

Bana bi.technology.bi@gmail.com adresinden ulaşabilirsiniz.