Hi, If in your "drill down OTBI report" if you are using the subject areas in the metadata repository database (RPD), so you have created an analysis in OTBI or you have created a report in OTBI with a data model with dataset with SQL data source "Oracle BIEE" or data set data source is an analysis in the catalog, then…

Hi Christian, Is TI an acronym? Not sure what you men mean by a TI user? Are you referring to the "TI" in Oracle Transactional Business Intelligence (OTBI). To view content in OTBI you need role "BI Consumer Role", to create analytics and reports using existing data models in OTBI you need role "BI Author Role", and to…

Hi, A person, person name, person address may have many versions over time. A person may have many addresses at the same point in time and over time. At any point in time one of the many address for a person may be the main address for that person (PER_ALL_PEOPLE_F.MAILING_ADDRESS_ID). If you want the history of both the…

Hi Fernando, No. I am not sure what you mean by "import analytics and report from OTBI to PBI?". But will assume your use case is to view data from Oracle Fusion Cloud Applications in Power BI. Obviously you can build a data extract to get data out to put it somewhere external that can be connected to by PBI. Or use the…

Hi, Yes here is the documentation regards roles you need. The duty roles are required so that you can query the subject area without the system throwing a database connection error. The duty role is inherit by the job role. Inside the job roles are also the data security policies that may be used by the subject area for…

Looking at your session log then this may be the view used to get licences and certifications for a person HRT_BI_CERTIF_ITEMS_V ...FROM HRT_PROFILE_ITEMS PI, hz_geographies HG, hz_geographies HZ , fnd_territories_b TB WHERE PI.CONTENT_TYPE_ID = 103 AND PI.COUNTRY_ID = HG.GEOGRAPHY_ID(+) AND PI.STATE_PROVINCE_ID =…

Hi, If you want to find an attribute, or confirm an attribute is not mapped since some are not, in a subject area to use in an analysis or report in OTBI then you can view the data lineage to see what attributes in the application database view object columns are mapped to presentation tables and columns in the subject…

Hi Ashley, Consider using instead the function that is designed for this purpose. TIMESTAMPDIFF() This will give you the number of seconds or mins or hours or days etc. rounded to the nearest integer between 2 timestamp attribute columns. So if you use sql_tsi_day between 2 datetimes then you will get to the nearest whole…

Hi Fred, CEMLI is, as I understand it, a "concept". A framework for the delivery of Configuration, Extension, Modification, Localization, and Integration. Not sure what you refer to by a CEMLI "tool" in OTBI. In the context of Oracle Fusion Cloud Applications I would start by reading this user guide Oracle Fusion Cloud…

Hi Aaron, As Harish said. Yes you can do this a simple way. Yes a report must have at least one layout. But the bit you are missing is that that layout can have no columns in it. If all you want is data with no format then you do NOT need to tediously have to drag and drop each column in. So create your data model, create…

Hi, 1. In OTBI you have subject areas "User System Usage" "Security - Roles and Privileges Real Time" "Security - Audit Real Time" "OTBI Usage Real Time" "OTBI Performance Real Time" 2. Also have you considered as solution to your use case using application "Risk Management and Compliance". This is one of the applications…

Hi, Yes the Oracle Business Intelligence (OBI) platform part of Oracle Transactional Business Intelligence is a suite of products. One of the products is a client side tools you can download to install in MS Office. So you can embed a pie chart from an analysis in OBI into your power point then just press refresh each time…

Hi, In the column property option did you change the data format to HTML?

Hi, What subject area are you using? What is the simplest logical query you can do to demonstrate the problem? Is this ERP or HCM? If ERP, which data security policy in which job role that you are granted did you setup data access for users? If HCM, which data role did you create linked to which job role with what security…

Hi Mike, Unfortunately the SQL syntax is different. Functions to_date and to_char are NOT valid. You need to use the correct version of SQL. You are using "logical" sql in an analysis in OTBI or in a data model in a report in OTBI using data source OBIEE. Here is a link to review the functions in the sql language reference…

Hi Radhika, When you use the task permissions on a folder or file in the catalog in OTBI to grant to a role then all you are doing is choosing what actions a user can perform on that file or files in a folder. For example, read, write etc. But the file folder permissions have absolutely nothing to do with how many rows are…

Hi, In OTBI the date format IS taken from your preferences in Oracle Fusion Cloud Applications. Both the American and European date formats are bad because they are ambiguous for the first 12 days of each month which is about 39% of the days in a year. The better format to use is the international oraganization for…

Hi, Having just re-read your question it maybe that you do in fact get data when you select only columns from the risk management subject area. But it returns no data only after you add some columns from the second subject area from system usage? Queries where you just add columns from multiple subject areas will only work…

Hi Gianni Ceresa, Yes you are on the correct forum for OTBI in Oracle Fusion Cloud Applications. Assume you are also getting no data found when you use the out of the box pre-defined dashboards that use the subject areas in Risk Management. Assume you are getting no data found no matter what columns you select from the…

Hi, The list of analytics and reports in HCM is in your user guide on docs.oracle.com Review sheet You can also just browse everything in the catalog in OTBI in /Shared Folders/Human Capital Management/...