Popular Tags
- OTBI 1,499
- Reporting 1,417
- FDI 1,290
- Fusion AI Data Platform 1,054
- Analysis and Data Visualization 1,014
- BI Publisher 895
- Analysis 699
- Oracle Fusion Analytics 632
- OAC 581
- Administration 564
- Fusion HCM Analytics 447
- Analytics 446
- OBIEE 444
- Fusion ERP Analytics 443
- BI Publisher Data Models 370
- Security 303
- HCM 295
- Oracle Analytics Cloud 292
- Fusion Data Intelligence 274
- BIP 272
- Answers 266
- Analyses 258
- Developers 249
- Data Modelling and Datasets 238
- Fusion Data Intelligence FDI 230
Report Layouts
Discussion List
-
Different report in same Excel file with differents sheetSummary Different report in same Excel file with differents sheet Content Hi Experts, I created 3 new reports as per our customer requirements. But they need all the rep…NIRMAL KUMAR L 156 views 3 comments 0 points Most recent by NIRMAL KUMAR L Oracle Transactional Business Intelligence Forum -
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 24 views 0 comments 0 points Most recent by Stephane Cote-Oracle Oracle Transactional Business Intelligence Forum
-
How to calculate subtotal of sectionSummary trying to get subtotal of section but it includes all data Content Any suggestions on how to get the subtotals added to this report? Example below, want totals f…Michelle Slobig Rotsolk 334 views 1 comment 0 points Most recent by Manoj Madhavan Oracle Transactional Business Intelligence Forum
-
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 52 views 0 comments 0 points Most recent by NIRMAL KUMAR L Oracle Transactional Business Intelligence Forum
-
Syntax to converting 24 hour time format to 12 hour format in sqlSummary Syntax to converting 24 hour time format to 12 hour format in sql Content Hi, Anyone know the SQL syntax to convert 24 hour time format(eg. 18:00 for 6:00 PM) to…NIRMAL KUMAR L 1.4K views 1 comment 0 points Most recent by Manoj.Gupta Oracle Transactional Business Intelligence Forum
-
Conditional FormattingSummary Conitional Formatting is not working properly Content I have created a report to help our teams identify at risk background checks. The report uses OBI condition…Tristan Hindes-55332 51 views 2 comments 0 points Most recent by RichardChan Oracle Transactional Business Intelligence Forum
-
Embedded Reporting/BI PublisherSummary audit report using offer fields Content Hello, I am trying to build a report for recruiters to use to audit the offers they have created. The intention is for th…Alice Kim, SPHR-SCP 130 views 5 comments 0 points Most recent by Alice Kim, SPHR-SCP Oracle Transactional Business Intelligence Forum
-
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 Most recent by Aaron Leggett Oracle Transactional Business Intelligence Forum
-
How to adjust 1000 notation within a BI Publisher graphContent Hello, We would like to adjust the y axis of a chart we made so that the 1000 counts are not seperated with a comma. Where can we adjust this formatting? See att…Marianne Kromwijk 61 views 2 comments 0 points Most recent by Marianne Kromwijk Oracle Transactional Business Intelligence Forum
-
Exporting to Excel & Word WrapSummary I want cells with longer text to wrap automatically when I export an analysis to excel 2010. Content I have a built an analysis that pulls in requisition user co…Tristan Hindes-14952 132 views 3 comments 0 points Most recent by Ramesh Nakka Oracle Transactional Business Intelligence Forum
-
Adding subtotal breaks into a BI Publisher table reportSummary How do I add subtotal breaks into BI Publisher report? Content In an Analysis created with subject areas it's easy to add subtotals by going into the view under …Tim Welsh 242 views 0 comments 0 points Most recent by Tim Welsh Oracle Transactional Business Intelligence Forum
-
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 Most recent by Ellen Manthei Oracle Transactional Business Intelligence Forum
-
Format prompt selectionsSummary Add specific formatting to prompted selections Content Is there a way to format the selections that show for prompts? For instance i need to have a prompt that f…User_EQ8R5 96 views 4 comments 0 points Most recent by User_EQ8R5 Oracle Transactional Business Intelligence Forum
-
StatsSummary Stat Report Content is it possible to report where you have a count of the number of employees in a age range - the age ranges would be columns and then rows wou…Peter Kirwan 37 views 1 comment 0 points Most recent by Chris Dabel Oracle Transactional Business Intelligence Forum
-
Pivot Table/Table Horizontal LayoutSummary Adjusting the layout of a pivot table or table from vertical to horizontal Content I need to change the layout of a sectioned Table from vertical to horizontal. …Andy French 41 views 1 comment 0 points Most recent by JF Carpentier-23261 Oracle Transactional Business Intelligence Forum
-
Adding new columns to a single view changes all viewsSummary Adding new columns to a single view changes all views Content Is there a setting that will stop this from happening? I have several reports that have multiple vi…Dawn Phipps 74 views 3 comments 0 points Most recent by Dawn Phipps Oracle Transactional Business Intelligence Forum
-
Placement of Dashboard Report LinksSummary Can the Dashboard Report Links (e.g., edit, export, add to briefing book, etc.) be moved from the bottom of the page to the top? Content Is it possible to move t…Andy French 57 views 2 comments 0 points Most recent by Maria Lieberman Oracle Transactional Business Intelligence Forum
-
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 24 views 0 comments 0 points Most recent by Terri Allen Oracle Transactional Business Intelligence Forum
-
Days between Step/StatusSummary OBI Days between Step/Status Content I am trying to create a custom calculations to show the number of days a submission remains in a particular step and status.…Alexis Rivers 41 views 1 comment 0 points Most recent by Kellyzuckerman Oracle Transactional Business Intelligence Forum
-
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 Most recent by Andy French Oracle Transactional Business Intelligence Forum