Hi,
I'm very new with business object and just wondering whether it is possible to create a scheduled report that auto-run for a specific time of the day in Business Object 6.5.
And below is the SQL codes that I run daily:
SELECT
BACKOFFICE.BRK_ACCOUNT_MASTER_VW.ACCOUNT_NO,
BACKOFFICE.BRK_ACCOUNT_MASTER_VW.ACCOUNT_NAME,
BACKOFFICE.BRK_CNOTES_VW.CNOTE_DATE,
BACKOFFICE.BRK_CNOTES_VW.CNOTE_NO,
BACKOFFICE.BRK_CNOTES_VW.CNOTE_STATUS,
BACKOFFICE.BRK_CNOTES_VW.BUY_SELL_CODE,
BACKOFFICE.BRK_CNOTES_VW.UNITS,
BACKOFFICE.BRK_CNOTES_VW.SEC_CODE,
BACKOFFICE.BRK_CNOTES_VW.UNIT_PRICE,
BACKOFFICE.BRK_CNOTES_VW.UNITS_VAL,
BACKOFFICE.BRK_CNOTES_VW.BKGE_VAL,
BACKOFFICE.BRK_CNOTES_VW.BKGE_GST,
BACKOFFICE.BRK_CNOTES_VW.NETT_VAL,
BACKOFFICE.BRK_CNOTES_VW.ADVISER_CODE,
BACKOFFICE.BRK_ACCOUNT_MASTER_VW.BRANCH,
BACKOFFICE.BRK_CNOTES_VW.ADVISER_CODE
FROM
BACKOFFICE.BRK_ACCOUNT_MASTER_VW,
BACKOFFICE.BRK_CNOTES_VW
WHERE
( BACKOFFICE.BRK_CNOTES_VW.ACCOUNT_NO=BACKOFFICE.BRK_ACCOUNT_MASTER_VW.ACCOUNT_NO )
AND (
BACKOFFICE.BRK_CNOTES_VW.CNOTE_DATE BETWEEN @variable('From Date') AND @variable('To Date')
AND BACKOFFICE.BRK_CNOTES_VW.CNOTE_STATUS != 'R'
AND BACKOFFICE.BRK_ACCOUNT_MASTER_VW.BRANCH = 'EPWM'
)
I would like to get this report scheduled and auto-save it as csv file on my hard drive instead of me running it everyday and manually save it.
I really appreciate it if anyone out there can help me on this.
thanks a lot.
Cheers,
Silva