Popular Tags
- Reporting 1,296
- OTBI 1,212
- Analysis and Data Visualization 800
- BI Publisher 677
- FDI 655
- Analysis 623
- Administration 502
- Oracle Fusion Analytics 468
- OBIEE 390
- BI Publisher Data Models 283
- Answers 253
- Analyses 247
- Developers 230
- Data Connectivity 196
- Security 195
- Analytics 194
- Data Modelling and Datasets 186
- HCM 184
- Report Output 164
- ERP Analytics Content 156
- Agents 145
- BIP 143
- BI Publisher Report Templates 137
- Packaging and Licensing 128
- Home and Catalog 122
pivot
Discussion List
-
1Ability to repeat item labels on Pivot Tables in Data VisualizationUsers in my organization would like the ability to repeat item labels in the Pivot Table view. Currently, the labels that are consistent relative to other labels to the …Andrew at MKL 8 views 0 comments 1 point Started by Andrew at MKL Oracle Fusion Data Intelligence Idea Lab -
OTBI Pivot table limits number of rowsHi, I have an OTBI report for Total Comp Deferred Cash Payments year wise. This is a simple report from subject area - Payroll - Element Entries History Real time. We ar…Arnabb 21 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence
-
4Possibility to use header/subheaders to organize columns in Tables/Pivot tablesHello, It would be desirable to be able to add Header/Subheaders to better organize data in Tables/Pivot tables in DV. Thanks. Best regards, JorgeJorge Olmeda 22 views 2 comments 4 points Most recent by Jorge Olmeda Oracle Analytics Cloud and Server Idea Lab -
OTBI_PIVOT_INDEXHi, If anyone knows how to use index on pivot table in OTBI, I would greatly appreciate your help. Thank you. Regards, Melekmelek cinar 11 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
Oracle Fusion OTBI > Ability to Rotate Rows Into ColumnsHello, We would like to design a report where the columns ‘Date’, ‘Time Entry Start Date and Time’, and ‘Time Entry End Date and Time’ are rotated. Please find below scr…Bernard T 2 views 0 comments 0 points Started by Bernard T Oracle Transactional Business Intelligence
-
How to design a pivot table in excel template?Trying to design a pivot table with tags in excel template but to make it is asking data first and then we can make pivot of it, but requirement is to make pivot based o…
-
Pivot functionality in excel template does not work when the number of data rows exceed 65KWe are using excel template pivot functionality to develop a costing report. Oracle supports only xls excel template and this is causing issue when the number of data ro…MeghaR 92 views 2 comments 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher
-
How to get grand total to properly sum values in pivot tables?We've noticed when summing pivot tables, that when are negative values the sums tend to be incorrect. For example, when using specific natural account segments, fiscal y…Caroline Blanchard 34 views 2 comments 2 points Most recent by Caroline Blanchard Oracle Fusion Data Intelligence -
How to add a calculated column in OTBI Pivot Table ?Hi All, Thank you in advance for your help and support. I have a query regarding the OTBI pivot table. I was wondering if there is a way to add a calculated column to th…Paul Younes 84 views 3 comments 0 points Most recent by RichardChan Oracle Transactional Business Intelligence
-
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. 11 views 3 comments 0 points Most recent by Gianni Ceresa Oracle Analytics Cloud and Server
-
OBI 12c pivot table excel exportHi there! As we recently moved from the (not longer supported) Oracle Discoverer to the BI Suite 12c, I wanted to ask if there is any way, to get the old behavior of exp…paddy3k 32 views 2 comments 0 points Most recent by paddy3k Oracle Business Intelligence Applications
-
How to Pivot the record and dynamically include the columnsHi, Am BI resource and new to Oracle. I have a requirement to create a view for reporting. 1.png 2.png 3.png View column template is attached. Product and Item level rec…