Popular Tags
- OTBI 1,373
- Reporting 1,352
- Analysis and Data Visualization 902
- FDI 898
- BI Publisher 792
- Analysis 655
- Administration 543
- Oracle Fusion Analytics 536
- OBIEE 415
- BI Publisher Data Models 324
- Analytics 310
- OAC 276
- Answers 259
- Security 255
- Analyses 251
- Developers 235
- HCM 225
- BIP 216
- Data Modelling and Datasets 209
- Data Connectivity 205
- ERP Analytics Content 193
- Report Output 180
- BI Publisher Report Templates 178
- Agents 148
- Customizing Reports 142
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
pivot
Discussion List
-
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 41 views 6 comments 5 points Most recent by Avinash Krishnaram-Oracle Oracle Analytics Cloud and Server Idea Lab -
16Ability 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 63 views 2 comments 16 points Most recent by Jacob at MKL Oracle Fusion Data Intelligence Idea Lab
-
8Allow 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 95 views 2 comments 8 points Most recent by Molly P Oracle Analytics Cloud and Server Idea Lab -
2Enable 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 21 views 0 comments 2 points Started by Eslam Elbagoory 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 61 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 22 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 1 view 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…
-
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 42 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 132 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 31 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…