Popular Tags
- OTBI 1,401
- Reporting 1,365
- FDI 961
- Analysis and Data Visualization 953
- BI Publisher 816
- Analysis 663
- Administration 553
- Oracle Fusion Analytics 543
- OBIEE 421
- Analytics 342
- OAC 336
- BI Publisher Data Models 335
- Security 271
- Answers 261
- Analyses 253
- Developers 240
- HCM 237
- BIP 232
- Data Modelling and Datasets 218
- Data Connectivity 205
- ERP Analytics Content 199
- BI Publisher Report Templates 184
- Report Output 180
- Agents 151
- Customizing Reports 146
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Answers
Discussion List
-
Pipleline Time In Process - Detail & Metrics Performance Issue - Advanced SQLSummary Pipleline Time In Process - Detail & Metrics Performance Issue - Advanced SQL Content Hi All, We have a dashboard -Pipeline Time In Process which consists of bot…Ramesh Nakka 21 views 0 comments 0 points Started by Ramesh Nakka Oracle Transactional Business Intelligence -
Pass Groovy script variable to OTBI DashboardSummary Pass Groovy script variable to OTBI Dashboard Content Hi All, I want to Pass Groovy script variable for OTBI Dashboard from fusion page to Dashboard (Dashboard p…user11018780 31 views 0 comments 0 points Started by user11018780 Oracle Transactional Business Intelligence
-
Length function issueSummary Please use CHAR_LENGTH instead of LENGTH Content In OBI, there is an issue with the LENGTH function where it causes the report to take up multiple times the norm…Stephane Cote-Oracle 21 views 0 comments 0 points Started by Stephane Cote-Oracle Oracle Transactional Business Intelligence
-
Error occurs in query when we add one line in where conditionSummary Error occurs in query when we add one line in where condition Content Hi, While adding this line in the existing query the below error occurs. Line used in where…NIRMAL KUMAR L 41 views 0 comments 0 points Started by NIRMAL KUMAR L Oracle Transactional Business Intelligence
-
Extracting Project Team Member Start DatesContent Hello How can I extract the the Person, Project Role and Start Date from OTBI or BI Publisher? I have found several subject areas where some of the information i…Aaron Leggett 11 views 0 comments 0 points Started by Aaron Leggett Oracle Transactional Business Intelligence
-
Two Pivot Tables with Different ValuesContent Hi I am trying to contain a report that has two pivot tables in it but with different parameters to restrict the results. I am pulling in the Expenditure Type co…Aaron Leggett 31 views 0 comments 0 points Started by Aaron Leggett Oracle Transactional Business Intelligence
-
Issue with Percentage in Pivot TableSummary Issue with Summarizing Percentages in Pivot Tables Content I have a calculation for the fill rate based upon hired vs target. This is working fine in the details…Ellen Manthei 31 views 0 comments 0 points Started by Ellen Manthei Oracle Transactional Business Intelligence
-
Pivot Table PromptsSummary Multi-tab dashboard based off pivot table prompts Content I have a report that displays the market data based on a pivot table prompt. Problem being when there a…Terri Allen 21 views 0 comments 0 points Started by Terri Allen Oracle Transactional Business Intelligence
-
Release 11 view issuesSummary Two views are not the same in Release 11 as they were in Release 10 Content We recently were upgraded to R11 and I found two BI Answer views that are not the sam…Shawn McDonald 11 views 0 comments 0 points Started by Shawn McDonald Oracle Transactional Business Intelligence
-
Able to change "Searching..." text?Summary Able to change "Searching..." text? Content Are we able to change the text on the "Searching..." pop up that appears when an analysis is loading? See attached. W…Andy French 11 views 0 comments 0 points Started by Andy French Oracle Transactional Business Intelligence
-
Max Unposting DateSummary Using max to provide latest unposting date Content I am using Max to provide the latest unposting date for requisitions. This is causing the number of completed …Alexis Rivers 31 views 0 comments 0 points Started by Alexis Rivers Oracle Transactional Business Intelligence
-
How to add ESSAPP application role ESSAdmin to enable cloud extract for OTBI-ESummary How to add ESSAPP application role ESSAdmin to enable cloud extract for OTBI-E Content a. To access BI Cloud Connect Console we need to provision roles in APM, c…Stephen Wright-19382 32 views 0 comments 0 points Started by Stephen Wright-19382 Oracle Transactional Business Intelligence
-
12c: Catalog object priviledge validation failedHi guys, first of all I want to state my versions I am using for the upcoming scenario / question / problem: OBIEE: Version 12.2.1.4.0 (including the latest security pat…Carsten Weber 21 views 2 comments 0 points Most recent by Carsten Weber Oracle Analytics Cloud and Server
-
How to filter to see only rows where the ID has the newest Date?I Have a Table as seen in the picture above. I only want to see the rows where the IDs have the newest Value. A seen in the Picture below:User_Y73CE 215 views 4 comments 0 points Most recent by User_Y73CE Oracle Analytics Cloud and Server
-
Display Pivot Table sections horizontally in 11gHello! This question has been asked, but as far as I can find, never answered. When you set up a pivot table and specify sections, each section of the pivot table is sta…Jesse O. 12 views 3 comments 0 points Most recent by Gianni Ceresa Oracle Analytics Cloud and Server
-
OBIEE 11g Dynamic graph based on reportHi guys, I have a question about Graphs on OBIEE. I was requested to create several reports using Usage Tracking info. Everything is setup and running, but I have proble…
-
Dashboard Menu Drop Down List Is Not ScrollableDear Experts, Upgraded OBIEE 11g to OBIEE 12c, OBIEE 12C has issue with missing dashboard menu in the down the line. If user has more dashboards if he wants to navigate …User_MSQS7 11 views 1 comment 0 points Most recent by [Deleted User] Oracle Analytics Cloud and Server
-
columns with data not filtered based on user login in a report filtered based on user loginHello, I am new to oracle BI and working on OBIEE 12.2.1.4.0. I have a requirement to create an analysis where I need to show three columns for a user. 1st column for Av…User_428ZJ 21 views 3 comments 0 points Most recent by [Deleted User] Oracle Analytics Cloud and Server
-
Accounting Format in OBIEEI'm writing a series of analyses that include dollar amounts, and the stakeholders wish to use a specific accounting format. However, I have not yet figured out how to d…
-
Filter on Last Day of Previous Month (Criteria)Can someone please advise me why I can't use this as a SQL Filter? "Gregorian Calendar"."Date" = TIMESTAMPADD(SQL_TSI_DAY , -(1), TIMESTAMPADD(SQL_TSI_DAY , DAYOFMONTH("…mrmmickle1 294 views 4 comments 0 points Most recent by mrmmickle1 Oracle Analytics Cloud and Server