asked on

Automate Reports in Business Objects

Hi

I am currently using Business Objects XI 3.1 provided by SAP (Screenshot attached with version)

I am able to create reports and export to a file. But I want to know if there is a way to automate the same.
I am using the script below

echo off
cls
m:
set ORACLE_HOME=M:\oraXP\ora10G
SET PATH=M:\oraXP\ora10G\BIN;%PATH%
"C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\busobj.exe" -system "SERVER:PORT" -auth "AD" "X:\PATH\REPORT.REP"

This automatically authenticates with AD to open the application and the REP File, but i have to manually export the data to excel.

if there is an option to export to excel via script, then it would be great, so that we can extract the report and schedule it.

I checked in google but there is not that much information based on the search operation which i performed.
BO-Version.PNG

Mike McCracken

WHy not use Infoview to schedule the reports?

mlmcc

Kurt Reinhardt

Agreed - what you're attempting is out-of-the-box functionality for the tool. Why are you attempting to do this manually?

brandsco

ASKER

actually i need to send out some fixed queries, reports on a weekly basis. normally it takes time to get the report, export to excel and format it the way we want and then send it. but if there is some scripting can be done, that would be nice. But as rhinok said, there is no option in this version.. let me check info view also..

thanks for the advice.

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Kurt Reinhardt

"Out-of-the-box" means it's an included feature, not excluded. You CAN schedule reports to run and be delivered in Excel format on an automatic, recurring basis. All of that functionality is included in both Infoview and the CMC (Central Management Console).