Popular Tags
- OTBI 1,494
- Reporting 1,412
- FDI 1,278
- Fusion AI Data Platform 1,050
- Analysis and Data Visualization 1,013
- BI Publisher 890
- Analysis 696
- Oracle Fusion Analytics 628
- OAC 571
- Administration 559
- Fusion HCM Analytics 445
- OBIEE 444
- Fusion ERP Analytics 442
- Analytics 440
- BI Publisher Data Models 367
- Security 311
- HCM 293
- Oracle Analytics Cloud 284
- BIP 273
- Answers 266
- Fusion Data Intelligence 257
- Analyses 257
- Developers 248
- Data Modelling and Datasets 237
- Fusion Data Intelligence FDI 222
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
SQL
Discussion List
-
how to put a Countif in a unique field in an OTBI reportSummary: In my report, I have Person Number field which is unique, however the report has some duplicate entries. I only need to understand how do I get a count to see h…Abhishek Bagh 1.3K views 8 comments 0 points Most recent by Amrita Gupta-Oracle Oracle Transactional Business Intelligence Forum -
How to perform function on a multiple value parameter?I'm trying to perform a function on parameter with multiple inputs oracle BI. It's a LoV parameter where u can select multiple values. It shows invalid number of argumen…
-
SQL/report to get the list of consultants (not having Person ID)We are looking for a user/role report that list users firstname/lastname/email and roles. The report we have only lists if they are linked to a person record. We have co…Vijay Ramani VJ 341 views 4 comments 0 points Most recent by Vijay Ramani VJ Oracle Transactional Business Intelligence Forum
-
How to default an OTBI SQL in a Data Model to Table View?Summary: How to default an OTBI SQL in a Data Model to Table View? Content (required): Does anyone know if it's possible to default the Data tab of an OTBI Data Model to…Mike Burnett 93 views 3 comments 0 points Most recent by Mike Burnett Oracle Transactional Business Intelligence Forum
-
Merging two reportsHi everyone, I have two separate reports that I would like to run. Both run fine on their own, but when adding all the columns to one of the reports I get multiple error…
-
Is there a way to find what reports/anaylsis are set up for Bursting?Summary Is there a way to find what reports/anaylsis are set up for Bursting? Content Hello I need to find out what reports/analysis have been created and set to burst o…Helen Thomas-53877 141 views 6 comments 0 points Most recent by Raghavan p-Oracle Oracle Transactional Business Intelligence Forum
-
Help with an OTBI or SQL query to produce a list of all job codes with Grade informationSummary: Hi All, I am hoping someone can help me - I have been struggling with a report request for a while now and I didn't think it was going to be this hard Our busin…PamS 2.2K views 16 comments 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Forum
-
Approval date not extractedSummary: Content (required): Hello everybody, In editing a report concerning various information about a job requisition. We needed to extract the "Approval Date" of a j…Gerardo Peluso 31 views 1 comment 0 points Most recent by ravikiran goda-Oracle Oracle Transactional Business Intelligence Forum
-
BIP performance recommendations guide v1.0 for FA SaaS (2800118.1) is available on MOS PortalSummary BIP Performance Recommendations Guide is intended for FA SaaS BI system integrators, BI report developers and admins. It covers advanced performance tuning techn…Pavel Buynitsky-Oracle 155 views 2 comments 1 point Most recent by Srinivas Pendyala-Oracle Oracle Transactional Business Intelligence Forum
-
Something off in SQL expression for criteriaSummary Trying to capture last month's data Content The report functions with the expressions below; however, It doesn't seem to actually capture the last day of the pre…Cassandra Kurth 61 views 2 comments 0 points Most recent by User_UEHCK Oracle Transactional Business Intelligence Forum
-
OTBI Analysis showing Filter values in Excel OutputSummary OTBI Analysis excel output showing filter values along with data and scheduler ran twice, while it was set to run once every week Content Hello Everyone, Our OTB…GauravGupta39 141 views 4 comments 0 points Most recent by SantoshKumarBhairi Oracle Transactional Business Intelligence Forum
-
AR Aging Bucket (Fusion OTBI)Content I am facing a problem with OTBI. I need to create an analysis using a subject area for receivable aging bucket but there is no subject that is called aging I tri…Maram Abuzaid 622 views 1 comment 0 points Most recent by Sahil_Makhiza Oracle Transactional Business Intelligence Forum
-
BI Publisher Data Model completes with errorsSummary BI Publisher Data Model completes with errors Content Hi Everyone, I'm trying to create a BI Publisher report using HRC_TXN_HEADER and HRC_TXN_DATA tables. Here …Dhanuka Chamal 222 views 3 comments 0 points Most recent by Dhanuka Chamal Oracle Transactional Business Intelligence Forum
-
MD5 encryption in RTF templateSummary In BI Report output using RTF template, need to to include a URL string which is formed using multiple flex field values and need to encrypt that particular URL …Murugappan Murugappan 31 views 0 comments 0 points Most recent by Murugappan Murugappan Oracle Transactional Business Intelligence Forum
-
Report on BIP Catalog Folders detailsSummary Report on BIP Catalog Folders details like Roles and Permission etc. Content Dear Team, How to report on BIP Catalog Folders details like Roles and Permission et…Karthik_ks 374 views 9 comments 0 points Most recent by Alok Suraj-Oracle Oracle Transactional Business Intelligence Forum
-
What application do you use to write your SQLContent I'm very curious as to what other people use to write their SQL. Personally I am using NotePad++ (with the SQL language setting to help with syntax). I do feel t…MaartenDIF 494 views 16 comments 0 points Most recent by MaartenDIF Oracle Transactional Business Intelligence Forum -
OTBI performance recommendations paper (2679006.1) is available on MOS PortalSummary OTBI performance recommendations V2 doc is intended for OTBI system integrators, BI report developers and admins. It covers advanced performance tuning technique…Pavel Buynitsky-Oracle 185 views 4 comments 0 points Most recent by Pavel Buynitsky-Oracle Oracle Transactional Business Intelligence Forum
-
Meaning of Oracle table name with and without "_" at its end?Summary What is the difference between Oracle tables named with and without "_" at the end? Content Hello Oracle Community, 1) What's the difference between Oracle table…Jonathan Chan gmg 792 views 2 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence Forum
-
How to display count(new customer account opened) from lasy year's month-to-date in analysisSummary How to display the amount of new customer account opened in last year's month-to-date, together with this year's month-to-date data Content Hello Oracle Communit…Jonathan Chan gmg 81 views 2 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence Forum
-
Extract first sets of integer from entriesSummary How to extract the first sets of integer from entries in "New Calculated Measure" Content Hello Oracle Community, In "New Calculated Measure" in Analysis, how ca…Jonathan Chan gmg 183 views 8 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence Forum