So, you are wondering how to retrieve the actual database query behind any VO in BI Cloud Connector (BICC) ? Here's how we can do it.
- Log in to BI Analytics as user with BI Administration privilege.
Navigation path: BI domain → Analytics → Administration
- On Administration page, navigate to Issue SQL option
- Enter physical SQL as below:
select_physical * from
"<VO Name>"
WHERE 1<> 1
e.g.
select_physical * from
"FscmTopModelAM.FinApInvTransactionsAM.InvoiceHeaderPVO"
WHERE 1<> 1
- Click Issue SQL
- In the log file, search for string "query to database". It should looks like this -
- Now, this is the true underlying query issued at database level.
0 comments:
Post a Comment