Hi, Is this what you are looking for ? https://docs.oracle.com/en/cloud/saas/otbi/otbi-admin/monitor-active-agent-sessions.html If you are specifically looking for a report with this data - such a report does not exist. Alternatively if you want to see all the agents in your environment you can do the following : 1) You…

Creating cross-SA analysis is a double-edged sword. Especially when you are using so many of them. Unlike BI Publisher report where you have absolute control over the SQL you are writing, here you have to depend on the logic written in the RPD which generated Physical SQL, and many a time when using so many subject areas…

Hi, OTBI follows the data security which is set for the user in the Fusion Application. There is no Security Configuration needed/available in OTBI to secure the Data.

Subject Area security for a user Follows Fusion side security setup for that User. If the user can see something or has access to some data in Fusion, then he automatically gets that access in OTBI as well. ....... But if your question is about subject area security in general, this documentation might be of help :…

Please check these documents : Fusion OTBI - COGS And Gross Margin Real Time Subject Area - COGS And Revenue Data Not Displayed (Doc ID 2311096.1) Fusion: SCM: CST: FAQ: OTBI Costing Subject Area Issues Master KM (Doc ID 2753653.1) Thanks

Hi Team, Please review - Goal : In 22A Catalog groups are no longer supported, during the upgrade to 22A existing Catalog Groups were converted to roles. How to add users to these new roles that were created from catalog group. Solution : The migrated roles are marked as unassignable so cannot be assigned directly. To add…

It's good that you want to get certified, but in the meantime, you can also review the easy to understand and follow documentation here to get started : https://docs.oracle.com/en/cloud/saas/otbi/index.html On the left side of this page, you will see 2 important links : Create Analyses and Dashboards - This refers to OTBI…

You are hitting system limits, since you are a SAAS customer, you may need to review the documents posted by Raghavan above. Thanks

To understand and identify the correct subject area and columns, you need to know which database table that data is stored in. If you know that you can use the process described in this document to figure out the right SA and Columns. How to verify if a certain attribute is available for reporting in OTBI ? (Doc ID…

Please review this documentation to understand where you will find the DFFs : https://docs.oracle.com/en/cloud/saas/human-resources/22b/fahca/human-capital-management-descriptive-flexfields-for-oracle.html#s20047246 The entire process describing how to enable DFFs is provided here :…

This feature is finally available to SAAS customers who have taken up the 22A update. Please review the documentation on how to apply themes and change the look and feel of your BI application in 22A here : https://docs.oracle.com/en/cloud/saas/otbi/otbi-admin/manage-themes.html

Hi Praveen, While i cannot pinpoint it for you, i can describe to you the methodology using which you can find out the right subject area and columns for your need. Please review : How to verify if a certain attribute is available for reporting in OTBI ? (Doc ID 2447001.1)

Since the entire middleware platform/stack is getting upgraded from 11G to 12C with 22A. It would be a good idea to bookmark this link, we are updating it actively and this should help you deal with any issues you face with BI post 22A upgrade : https://docs.oracle.com/en/cloud/saas/otbi/otbi-known-issues/index.html

It is definitely worth logging an Idea for this. Please provide the business use case in the Idea and how the existing webservices are inadequate. Basically, try to explain why REST API availability is quite important to your business. Once the Idea is logged, it will be under product management review for feasibility.

Hi Claudio, Your general understanding is correct that 12C brings with it REST API support, but the BI Publisher Codebase used for Fusion and Standalone 12C is different. If you are a Fusion Consumer, BI Publisher will not have support for REST API. Please continue using the webservices provided for Fusion : Fusion…

There are 2 options here : 1) To look at all schedules, a user would need BI Administrator Role. OR 2) While creating the Schedule, Select "Make Output Public" to make this job output available to all users with permission to access that specific report. Users with access can view the report from the Report Job History…

Hi All, Unfortunately, REST API is not supported for BI in Fusion.

If you are using Fusion Cloud, these limits cannot be increased. You will need to work within these limits.

If you are running/invoking the BI report via an ESS job, you could use the following function to retreive the ESSID. (select SYS_CONTEXT( 'USERENV', 'CLIENT_IDENTIFIER' ) C_USER_NAME from dual) CURR_USER This will return something like this : ess12345-abc.xyz@oracle.com Here "12345" should be the ESSID and the rest after…