Popular Tags
- OTBI 1,445
- Reporting 1,392
- FDI 1,115
- Analysis and Data Visualization 984
- BI Publisher 853
- Analysis 681
- Oracle Fusion Analytics 584
- Administration 555
- OAC 448
- OBIEE 433
- Analytics 399
- BI Publisher Data Models 355
- Security 293
- HCM 265
- Answers 264
- BIP 263
- Analyses 255
- Developers 245
- Data Modelling and Datasets 228
- Data Connectivity 210
- ERP Analytics Content 208
- BI Publisher Report Templates 204
- Oracle Analytics Cloud 191
- Report Output 184
- Fusion Data Intelligence 176
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
pivot
Discussion List
-
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 31 views 2 comments 1 point Most recent by Raphael Gonçalves Silva Oracle Analytics Cloud and Server Idea Lab -
25Ability 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 134 views 5 comments 25 points Most recent by Purvesh Bhavsar Oracle Fusion Data Intelligence 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…Purnima Mishra 34 views 0 comments 5 points Started by Purnima Mishra Oracle Analytics Cloud and Server Idea Lab -
9Enable 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 34 views 1 comment 9 points Most recent by R Stonaker Oracle Analytics Cloud and Server Idea Lab
-
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 44 views 6 comments 5 points Most recent by Avinash Krishnaram-Oracle Oracle Analytics Cloud and Server Idea Lab -
11Allow 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 134 views 2 comments 11 points Most recent by Molly P Oracle Analytics Cloud and Server 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 121 views 6 comments 0 points Most recent by Anders W. Langholm Oracle Analytics Cloud and Server
-
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 Cloud and Server 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 24 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 4 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…User_SXVU3 450 views 1 comment 0 points Most recent by Federico Venturin - 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 49 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 214 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. 12 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 33 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…