Popular Tags
- OTBI 1,486
- Reporting 1,412
- FDI 1,223
- Fusion AI Data Platform 1,045
- Analysis and Data Visualization 1,013
- BI Publisher 882
- Analysis 695
- Oracle Fusion Analytics 621
- Administration 558
- OAC 554
- OBIEE 440
- Fusion HCM Analytics 433
- Analytics 431
- Fusion ERP Analytics 424
- BI Publisher Data Models 363
- Security 309
- HCM 289
- BIP 271
- Answers 267
- Oracle Analytics Cloud 260
- Analyses 257
- Developers 248
- Data Modelling and Datasets 235
- Fusion Data Intelligence 222
- ERP Analytics Content 219
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
pivot
Discussion List
-
31Ability 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 181 views 8 comments 31 points Most recent by Bhaskar Konar Oracle Fusion AI Data Platform Idea Lab -
12Enable alternate styling in table or pivot table viz.To ease the readiness or rows in tables or pivot tables in OAC DV, alternate styling to rows should be allowed when formatting data background color, this option already…Eslam Elbagoory 51 views 3 comments 12 points Most recent by Bhaskar Konar Oracle Analytics Idea Lab -
1Add expand and collapse buttons to table components and pivot tables in OACHello, good afternoon! Would it be possible to create an option for the table or pivot table visualization component to use a (+/-) symbol to expand or collapse the leve…Raphael Gonçalves Silva 51 views 2 comments 1 point Most recent by Raphael Gonçalves Silva Oracle Analytics Idea Lab -
5Attribute-Based Values in FDI PivotsThe Ask We'd like to propose an enhancement for Data Visualization (DV) within Fusion Data Intelligence (FDI). Specifically, we're requesting the ability to use an attri…
-
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…
-
5Requesting Oracle to provide indentation in Pivot view of OAC DVMy sincere request is to ask Oracle to introduce indentation as a feature in OAC DV pivot view. Since the traditional users are excel based , they would love this featur…Ajinkya Vyawahare 71 views 6 comments 5 points Most recent by Avinash Krishnaram-Oracle Oracle Analytics Idea Lab -
13Allow repeating row labels on pivot table visualizationsClassic Allow repeating row labels on pivot table visualizations Currently only available in table visualization Example: Classic table option/functionality (does not ex…Sreekumar_Analytics_Ambassador 151 views 2 comments 13 points Most recent by Molly P Oracle Analytics Idea Lab -
OAC: How to suppress rows in pivot table exportIn OBIEE you can select to repeat the value of the row instead merge it. This is useful when you are exporting a pivot and you need to repeat the value to allow the user…Ursula Ortiz -Oracle 144 views 6 comments 0 points Most recent by Anders W. Langholm Oracle Analytics Forum
-
3Show dimenion hierarchy in Excel Export according to Classic BIWhile exporting a (pivot) table via Excel using dimension hierarchies, those hierarchies are not "visible" for the customer, since each entry is on the same line. E.g. a…Dr. Christopher Cullmann 11 views 1 comment 3 points Most recent by Benjamin Arnulf-Oracle Oracle Analytics 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 34 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence Forum
-
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, Jorge -
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 Forum
-
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 1 view 0 comments 0 points Most recent by Bernard T Oracle Transactional Business Intelligence Forum
-
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…User_SXVU3 486 views 1 comment 0 points Most recent by Federico Venturin - Oracle Oracle Analytics Publisher Forum
-
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 61 views 2 comments 2 points Most recent by Caroline Blanchard Oracle Fusion AI Data Platform Forum -
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 242 views 3 comments 0 points Most recent by RichardChan Oracle Transactional Business Intelligence Forum
-
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…
-
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…
-
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 41 views 2 comments 0 points Most recent by paddy3k Oracle Business Intelligence Applications Forum