Skip to Content
avatar image
Former Member

BO XI 3.1 Backup sql query reports whitout soliciting users

Hi,

I'm working on BO XI 3.1 and we don't have yet budget to migrate to SAP BI 4!

I want to know, if we can not restart BO server (after installing security patch for exemple), what solution do we have to save the sql script of each report associated to each user for playing it in a database management toolset like toad and extract data for analyse in excel?

Executing querys will be performed by the support team (the aim is to built a traceability matrix with these elements : user, repository, report, sub report (if exists), sql script)

Is their any solution to do it "massively" whitout soliciting users?

For information, our univers contains derived tables, views, agregates... and some reports contains sub reports. There are more than 100 users et more that 20k reports!

I hope i'm clear!

Tks a lot for your answers

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Nov 30, 2017 at 07:11 PM

    The Audit tables will contain the query's SQL for each refresh action, so you could get it from there.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 01, 2017 at 12:21 PM

    Tks for the answer.

    Where can i fin this audit database?

    Add comment
    10|10000 characters needed characters exceeded