Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
-
Re: Security on reporting OTBI
Hi, It is not possible to deny something that is already denied. So ALL subject areas are already "denied" from BI Author Role. That is "denied" meaning that if you issue sql to q…1 -
Re: In Seeded OTBI report "Top 10 Spend Supplier"
Hi Abhishek, Liwen, In the seeded analysis "Top 10 Spend by Suppler" in folder procurement/spend/transaction analysis samples/ this is a query from subject are "Procurement - Spend Rea…1 -
Re: How to create P&L and Balance sheet in oracle fusion cloud real time?
Hi Faisal, For this use case you can perhaps as suggested by Praveen use the general ledger balances (cube) subject area or more detailed transactional balances subject area in OTBI.…1 -
Re: How can I get a notification on failed scheduled OTBI Job?
Hi, Yes that is correct. Yes when you schedule a report in OTBI with a "Report Job" in OTBI you do have an option to send an notification by email on failure. But no when you schedule an an…1 -
Re: OTBI analysis - problem with left outer join
Hi, On page /analytics/saw.dll?IssueRawSQL this SQL execute with success. No error message. and if you add a sort NOTE This will tell you in anyone entered a timecard that day but all status of timec…2
