Link to home
Start Free TrialLog in
Avatar of brandsco
brandscoFlag for United Arab Emirates

asked on

Automate Reports in Business Objects


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
set ORACLE_HOME=M:\oraXP\ora10G
"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.
Avatar of Mike McCracken
Mike McCracken

WHy not use Infoview to schedule the reports?

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


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.
Avatar of Mike McCracken
Mike McCracken

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
"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).