We have 10 different reports in BIP, the requirement is to generate all the report in pdf and excel format at certain time and store to specific path in same box in back end.
How to achieve this, is there any document ?
Thanks in advance!
Yes you can do this.
Configure Bursting- FILE option on BIP Data Model and schedule the report at specific time.
To configure bursting - https://docs.oracle.com/cd/E14571_01/bi.1111/e13881/T527073T555155.htm
If you don't want to split the report output into multiple files; use constant column value - example - include dummy column on your sql lke 'dummy' as burst_flag