Sohel, As suggested by Praveen for analysis (blue) in OTBI (not reports (yellow)) the method using the usage tracking tables S_NQ_ ACCT/DB_ACCT in the 2 usage tracking subject areas will work if all the analysis were executed by someone at least once. It has the path to the analysis/dashboard prompt etc and the subject…

Hi What is the logical sql in your analysis? Post the simplest query with the least number of presentation columns with the least complex filters that will demonstrate your problem statement. To understand "how this field works" now go to page analytics/saw.dll?IssueRawSQL then View Log to go to page…

Here is the bit in your user guide that tells you how to get user information in your report in OTBI For more information see Oracle® Fusion Middleware Data Modeling Guide for Oracle Business Intelligence Publisher 12c (12.2.1.2.0) E77720-02 December 2016…

Hi uyogi Sorry but I do not understand what you mean by users who are "primary/secondary". You grant a role to users. There is no primary or secondary user. Just n users that are granted a role. You may create role Y as a copy of a pre-defined out of the box role X with a new name such as…

FYI Try this Select Navigator, select Show More In group My Enterprise select work area Setup and Maintenance Select task Manage Administrator Profile Values Profile Option Code = FND_TRACK_USER_ACTIVITY update Profile Level = Site value from DISABLED to ENABLED For more information see then get a list of sign in times…

Sidney, The link is to an article in My Oracle Support. Only customers of oracle may read articles on My Oracle Support. It the link is broken just go to support.oracle.com then search for the article. As a customer of oracle when you purchased a licence you were given a support identifier. You can use this support…

Hi Sidney, If you look at your session log of the query proposed by Rebecca select all 0 s_0, "User"."Last Activity Date" as s from "User System Usage" you can see that the data source is this database table column select all t.last_activity_date as s from fnd_session_users t If you get no data then that is likely that…

Hi, I am not sure what content you refer to. Maybe you can post what work area selected form the navigation menu you are using to view this? Is this a report or an analysis? What is the path to this content in the catalog in OTBI? What is status "Active". I will make a guess that this is a list of workforce person…

So for a day of the month n=12 to be in a date range from start date YYYY-mm-dd to end date YYYY-mm-dd then assuming end date > = start date then i think you need to test how many months between the start end dates. To include day 12; If same year month difference in months = 0 then start date must be > = 12 AND end date…

Hi, For test case 1 payroll day of start date 2023-12-31 = 31 and day of end date 2024-01-13 is 13. 31 is NOT "< = 12", 13 is NOT "> = 12", 13 is not "= 12" - so it is not true for any of your 3 conditions in your switch so it is nether Yes nor Yes - the case will return null. For test case 2 payroll day of start date…

Hi, I assume I know what you mean when you say "upload image" to OBI. For example, in your editor you selected the button "Upload Image", selected a file from your local machine, the system put that file in hidden folder /Custom/images. You can then reference that custom image in your content. But what do you mean when you…

FYI But looking in the session log I think the time dimension is header created date select all 0 s_0 , "Time"."Date" as d , "- Purchase Receipt Line Details"."Receipt Line Id" as id , "- Purchase Receipt Line"."Receipt Amount" as f FROM "Receiving - Purchase Receipts Real Time" ORDER BY 1 ASC NULLS LAST FETCH FIRST 7 ROWS…

Hi, Receiving - Purchase Receipts Real Time https://docs.oracle.com/en/cloud/saas/supply-chain-and-manufacturing/24a/faosm/Receiving--Purchase-Receipts-Real-Time-SA-83.html#Receiving__Purchase_Receipts_Real_Time_SA_83_d1e18588 Your user guide says the time dimension in this subject area is "Receipt Date". What does it mean…

Hi, Yes that is correct. No audit data for any of the tables in the subject areas in OTBI.

Hi, No. You can see this from the "Review data lineage mapping" from the tables and views in the view objects in the application database to the presentation tables and columns in the subject areas in the metadata repository database (RPD).…

Hi, There are instructions in the link included in my answer about how your cloud account administrator can set you up as a user of the console to view the service usage reports or receive them by email when they are generated by Oracle. For example, there is a read only role called Business Administrator.

Hi Rory, The good news. Yes they do. This forum is for OTBI. So that means you are a customer using Oracle Fusion Cloud Applications as SaaS. You can get this information from your console for SaaS. For more information see Oracle® Cloud Getting Started with Oracle Cloud Applications E41248-91 February 2024 About the…

Hi, In that case you need to build your report such that it always has 1 row of data. Like join to a second dataset g_0 with a a select null from dual so you always get that row if no data found in your main data set g_1.

Hi, For your second question regards sizing. So the Oracle Business Intelligence (BI) (OBI) in OTBI is platform Oracle Business Intelligence (OBI) 12c (suite Enterprise Edition(EE)) (but since Standard Edition (SE) has not been sold since like 2008 you can if you like drop the EE from OBIEE). OBI is a suite of products;…

Hi, Both analysis (blue) and reports (yellow) are in OTBI. The data models in your reports in OTBI may be from 4 data sources; 3 application pillar databases CRM, HCM, FSCM and 4 Oracle BI EE (a data set from an analysis or the logical sql with in either case a query from subject areas in the metadata repository database…