Popular Tags
- OTBI 1,509
- Reporting 1,428
- FDI 1,330
- Fusion AI Data Platform 1,054
- Analysis and Data Visualization 1,023
- BI Publisher 907
- Analysis 699
- Oracle Fusion Analytics 639
- OAC 615
- Administration 568
- Fusion HCM Analytics 463
- Analytics 463
- Fusion ERP Analytics 461
- OBIEE 446
- BI Publisher Data Models 372
- Oracle Analytics Cloud 312
- Security 309
- Fusion Data Intelligence 298
- HCM 297
- Fusion Data Intelligence FDI 280
- BIP 274
- Answers 267
- Analyses 258
- Developers 250
- Data Modelling and Datasets 241
SQL
Discussion List
-
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 216 views 8 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence Forum -
How to build an inventory analysis coupled with time constrained measure?Summary An analysis, contain info. on on-hand-quantity and open quantity, does not produce results after 15mins of run time. This happens when a time constrained measure…Jonathan Chan gmg 7 views 0 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence Forum
-
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 133 views 2 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence Forum
-
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 269 views 7 comments 0 points Most recent by Arun Raj Oracle Transactional Business Intelligence Forum
-
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 552 views 8 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence Forum
-
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 153 views 7 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence Forum
-
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 146 views 5 comments 0 points Most recent by narasimha arekatla Oracle Transactional Business Intelligence Forum
-
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 244 views 4 comments 0 points Most recent by user12182418 Oracle Transactional Business Intelligence Forum
-
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 247 views 4 comments 0 points Most recent by Tugce Kucukoner-144150 Oracle Transactional Business Intelligence Forum
-
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 156 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence Forum
-
Setting relative dates in a filter for an OTBI AnalysisSummary In an OTBI Analysis is there a way to add into a relative date range into a filter? Content I need an Analysis with a filter to pick up dates within the last wee…Tim Welsh 2.7K views 17 comments 0 points Most recent by Kamran Butt-161785 Oracle Transactional Business Intelligence Forum
-
Filter on blank and future datesSummary Create a filter using SQL expression to show just the null and future dated values Content Hello, I have a need to see only the null values and future dates. I'm…slgott 262 views 2 comments 0 points Most recent by SantoshKumarBhairi Oracle Transactional Business Intelligence Forum
-
Filter for terminations in prior calendar weekSummary I'm creating a termination report and trying to show which terminations were in the calendar week (Sunday-Saturday) prior from the week when the report was run C…Karen B 102 views 3 comments 0 points Most recent by Lavanya Reddy Oracle Transactional Business Intelligence Forum
-
Pivot resultsHello all, When I try Pivoting the result of one of my queries, OBIEE gives me an error saying there are too many variables. Is there a way to pivot the data i'm queryin…Guillermo Bueno 265 views 13 comments 0 points Most recent by Guillermo Bueno Oracle Analytics Forum
-
How to modify the content of a column through a result similar to RPADSummary How to modify the content of a column through a result similar to RPAD - we want to create a report that will need to have a specific lenght per column & wish to…TheoMC 22 views 0 comments 0 points Most recent by TheoMC Oracle Transactional Business Intelligence Forum
-
How to modify this complex join in OBIEE Answers?How do I achieve below join condition for one specific report in OBIEE 12c Answers? Select * from A right outer join B on (a.id = b.id and a.entity is not null) I have d…
-
Help with Advanced Editor Raw SQL SyntaxHello all- Thank you for reviewing my Advanced Editor SQL Question. I have two queries that work alone by themselves. I want to add or subtract these numbers together. H…
-
Is Orders data available through the OTBI layer in Order Management / SCM?Summary Is Orders data available through the OTBI layer in Order Management / SCM? Content Is Orders data available through the OTBI layer in Order Management / SCM? Rea…Shalindra Singh 61 views 1 comment 0 points Most recent by Shalindra Singh Oracle Transactional Business Intelligence Forum
-
OTBI Variable Presentation Date Prompt Format DD-MON-YYYYSummary Users need to be able to enter a date in DD-MON-YYYY format at the prompt Content Our date format changed to dd-MON-yyyy (15-MAY-2017), but the only way the repo…Brenda Jacks-49721 292 views 1 comment 0 points Most recent by RichardChan Oracle Transactional Business Intelligence Forum
-
Using an SQL Date Formula in OBIEE ReportSummary How do I display previous 30 days of data Content Could someone please show me how to tweak the below formula. I’d like to pull data from the previous 30 days; h…3371114 1.5K views 8 comments 0 points Most recent by 3371114 Oracle Transactional Business Intelligence Forum