Hi @skhan , You will have to elaborate a little here for us to understand and then assist you. Can you please upload a document with screenshots explaining what is not working and what is the expected outcome according to you ? Regards, Gaurav

Hi @Nicolas Trojack There are sometimes Module/product specific processes that need to be run to sync the data/populate the tables that OTBI depends on. To know if this is the case for your usecase, you will need to check with the HCM Analytics team. I suggest you log a new thread under HCM Analytics. Besides this from…

@Sudheer YN You could also try posting it in the product specific analytics forum and there are better chances of getting the right guidance. SCM/PRC Analytics Regards, Gaurav

@BillW You might find the right assistance in this forum, please log a thread there. ERP Analytics Regards, Gaurav

Hi @Charan Kumar Reddy Lingala If the PDF doesn't contain any sensitive data can you try uploading the PDF here so we can open and see how it looks on our end. Thanks.

Hi @Yftach Paschur-Oracle By Default grouping in OTBI happens implicitly from left to right. Meaning check the columns selected in the Criteria Tab, the grouping will happen from the leftmost column towards the right most. To explicitly set Group By you need to use my Colleague's suggestion ie Rajasekhar's Suggestion.…

Hi @Martha Wasylynchuk , It seems like your syntax is incorrect. Kindly look at this documentation for the correct syntax with examples. Conditional Formatting in RTF You need to use IF-ELSE-IF Statement here to achieve what you are looking for. An Example : <?xdofx:if AMOUNT > 1000 then 'Higher' else if AMOUNT < 1000 then…

Hi @User_1SFC9 , How are you inserting the image into the template ? Is it via ctrl A + ctrl C from another source like paint, or are you doing it using Insert Picture option in MS Word ? Please review the following : Insert Method: Instead of dragging the image OR copy pasting the image, use the "Insert > Picture > From…

Hi @User_CYBWX Have a look at this thread and see if it is helpful : Additional Reference that talks about Date Conversion Function: If my response has answered your question or assisted you with your concern, please click "yes" below to accept the answer or comment with any additional queries. You can also read the Cloud…

Hi @Terri Norris , What reports are you talking about here, can you elaborate ? "but I cannot find read only roles to allow access to the reports" Also check these threads, might be relevant : If my response has answered your question or assisted you with your concern, please click "yes" below to accept the answer or…

@Omran Zeaiter There is no way to "Convert" an OTBI analysis to a BIP Report. If you can tell us more about the error or issue you are facing, we can advise further. Additionally, if you would like to recreate the analysis but using a data model using SQL. Then what you need to do is the following : 1) Find the Data…

Hi @Vasco Its a bit late, but did you get a solution to you query ? If not, Would you be able to explain how you want the graph to look with an example so i can review and advise. Regards, Gaurav

@Sunil Nukala2 Please explain what you mean by synced, with an example. Regards, Gaurav

Hi @Anna-MariaP Please post this question in this forum : You will get the appropriate assistance for this query there. Thank You, Gaurav

Hello @Mohab Ehab-Oracle OTBI does not allow using external data sources. Your only option would be to export the data from Fusion in Bulk using BI Cloud Connector Console and then use that exported data for your reporting needs. BICC Documentation can be found here : If my response hasanswered your question or assisted…

Hello @Stefano_Mazzocca Thank you for posting about BI Publisher APIs Lets start with the right documentation first. Here is a great KM article explaining what APIs are supported and available in Fusion SAAS : Fusion Application BI Publisher (BIP) : Available Public Webservices in Fusion Applications (Doc ID 2086077.1)…

Hi Team, In addition to what my colleague said you can also keep this document handy, this will also help you figure out if a user made changes to reports in OTBI Catalog. Fusion Applications - How to Track Delete , Archive and Unarchive Events In BI (Doc ID 2930706.1) If my response has answered your question or assisted…

Apart from the usage metrics suggested by my colleague, there is one more thing you can do. Please look at reducing the amount of data stored in the scheduler tables. https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-admin/purge-job-diagnostic-logs.html#TBIPA-GUID-C4FBCDB5-BD63-4393-AB13-66BA9D82DDC3 If my response has…

Hi Team, OTBI picks up data mapped from Fusion Tables. Please check if "SENT FILE NAME" column is mapped to any OTBI subject area column. Thanks

Hello @Dylan M, I understand you are asking a question regarding BI Object Labels for DFF and their segments. This may not be the best way, in fact i dont think there is a way to export them all in 1 shot, but i suppose you can view this information in the Log file that gets generated after running the following scheduled…