Popular Tags
- OTBI 1,456
- Reporting 1,398
- FDI 1,146
- Analysis and Data Visualization 991
- BI Publisher 865
- Analysis 684
- Oracle Fusion Analytics 597
- Administration 557
- OAC 480
- OBIEE 434
- Analytics 410
- BI Publisher Data Models 359
- Security 297
- HCM 269
- BIP 265
- Answers 265
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Oracle Analytics Cloud 219
- ERP Analytics Content 215
- Data Connectivity 211
- BI Publisher Report Templates 205
- Fusion Data Intelligence 196
- Report Output 184
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
SQL
Discussion List
-
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 -
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 122 views 2 comments 1 point Most recent by Srinivas Pendyala-Oracle Oracle Transactional Business Intelligence
-
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
-
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
-
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 621 views 1 comment 0 points Most recent by Sahil_Makhiza Oracle Transactional Business Intelligence
-
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
-
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 331 views 9 comments 0 points Most recent by Alok Suraj-Oracle Oracle Transactional Business Intelligence
-
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 441 views 16 comments 0 points Most recent by MaartenDIF Oracle Transactional Business Intelligence -
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 182 views 4 comments 0 points Most recent by Pavel Buynitsky-Oracle Oracle Transactional Business Intelligence
-
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 751 views 2 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence
-
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
-
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 171 views 8 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence
-
Rows overcounting in AnalysisSummary How to only count the number of rows showing in an analysis Content Hello Oracle communities, When I attempt to display the total number of rows shown in an anal…Jonathan Chan gmg 111 views 2 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence
-
Error when using TODATE(REVENUE, YEAR) Oracle SQL functionSummary TODATE function resulted in error, what are possible alternatives to get the needed results? Content Hello Oracle Community, The below error (per enclosed 2 scre…Jonathan Chan gmg 212 views 7 comments 0 points Most recent by Arun Raj Oracle Transactional Business Intelligence
-
How to override NULL values with existing valuesSummary How to override null value with values from another column in OBIEE Analysis Content When building an analysis in OBIEE, what would be the code to enter into the…Jonathan Chan gmg 483 views 8 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence
-
Help with Formula: most recent offerSummary I need help creating a formula to pull in the most recent offer Content I'm pulling together a list of YTD offers. I am finding records where the candidate has a…Rosenerie Castillo 132 views 7 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence
-
Feasibility of having SQL Developer Connection to Oracle HCM Cloud Enviornment?Summary Feasibility of having SQL Developer Connection to Oracle HCM Cloud Enviornment? Content Hi Experts, I hope that most of you who have worked on an On-Premise syst…AshishERPCloud 121 views 5 comments 0 points Most recent by narasimha arekatla Oracle Transactional Business Intelligence
-
BI Publisher CSV files or Reading from Content Server sourceSummary Reading files on the Content Server in BI Publisher Content Hello, I'm trying to create a report in BI Publisher that will read an external file as a data source…Rob F 211 views 4 comments 0 points Most recent by user12182418 Oracle Transactional Business Intelligence
-
Need inputs to find who created/deleted the folder in Reports and AnalyticsContent Hi All, We have different custom folders in Reports and Analytics side. Is there any way to find who created/deleted the folder or Data model or Report? We need …Visu 231 views 4 comments 0 points Most recent by Tugce Kucukoner-144150 Oracle Transactional Business Intelligence
-
Trailing Spaces in OBIEESummary formatting question Content Hello! I am hoping to poll the community regarding some OBIEE formatting i'm trying to accomplish. I have a report where I need to cr…Joy Hanneman-161050 151 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence