Popular Tags
- OTBI 1,446
- Reporting 1,392
- FDI 1,116
- Analysis and Data Visualization 986
- BI Publisher 854
- Analysis 682
- Oracle Fusion Analytics 585
- Administration 555
- OAC 449
- OBIEE 433
- Analytics 399
- BI Publisher Data Models 356
- Security 293
- HCM 266
- 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 192
- Report Output 184
- Fusion Data Intelligence 179
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Excel
Discussion List
-
Oracle Analytics can now copy multi-select data cells in TablesOracle Analytics is now allowing to copy multi-select data cells in Tables! Users can now easily multi-select, column-select or row-select multiple data cells in Oracle …Benjamin Arnulf-Oracle 524 views 8 comments 15 points Most recent by Anna Pietrangelo Oracle Analytics News -
Position of the download menu in a workbookHi, we've seen that the position of the download menu is changed from the right side to the center of the workbook: is it a new feature or is it possible to change the p…AM HRE 11 views 1 comment 0 points Most recent by Sumanth V -Oracle Oracle Analytics Cloud and Server -
How to retain report format after exporting to Excel?Hello, Upon extracting the report, the format of values in excel file have extra characters and extra spaces. Is there a way to correct the data upon exporting? Report v…Ivony Ann Paula Salango 11 views 2 comments 0 points Most recent by Ivony Ann Paula Salango Oracle Transactional Business Intelligence -
24Warn users of 25k row limit when exporting to Excel (xlsx)The preview feature exporting to Excel (xlsx) format has recently been implemented as a general access feature. While in most instances this makes exporting data from da…User_HUUWH 303 views 3 comments 24 points Most recent by Avinash Krishnaram-Oracle Oracle Analytics Cloud and Server Idea Lab
-
How to extend subject areas with a dataset created via Excel upload?Is there a way to extend subject areas with a dataset created via Excel upload?
-
Combining FDI Reports ExportsHi Community, I built two FDI reports with the same number of columns and same column names. Is there a way to create an excel export combining the results of these two …
-
0Formatted excel export from OAC classic report does not merge cells for report level headerFormatted excel export from OAC classic report does not merge cells for report level header which changes the width of the data column below it When we export a report w…User_DLG2I 4 views 1 comment 0 points Most recent by Benjamin Arnulf-Oracle Oracle Analytics Cloud and Server Idea Lab
-
2Excel Export should contain format of the table itself including headers, footnotes and filtersAs statistical office of the government of Rhineland-Palatinate, Germany, we want to offer our customers tables on canvas. Our customers quite often have the need to exp…Dr. Christopher Cullmann 11 views 0 comments 2 points Started by Dr. Christopher Cullmann 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…
-
7Ability to reload an Excel/CSV Dataset incrementallyThe user would like the ability to click on "Reload Dataset" with a check box to reload incrementally. Use Case: User uploads an Excel/CSV file with January 2025 data Ne…
-
6Request to Increase Data Export LimitsDue to customer requests, we would like to increase the data export limits from 400,000 to 1,000,000 rows when exporting to formatted reports from analyses and dashboard…User_VCTMR 41 views 0 comments 6 points Started by User_VCTMR Oracle Analytics Cloud and Server Idea Lab
-
New Feature from the idea lab in Oracle Analytics: Excel Multi-Sheet UploadNew feature from the idea lab in Oracle Analytics: Excel Multi-Sheet Upload You can now drop an excel file with multiple tabs and import all of them in a single dataset.…Benjamin Arnulf-Oracle 488 views 12 comments 16 points Most recent by Sudarsan G Oracle Analytics News
-
Merged Cell in Excel Template of BIP ReportHi All, How do I generate the report shown below? I wish to merge common text in "Organization" and generate report like below. Please provide pointers to any link for r…
-
49Remove row limit of 75000 on Excel (XLSX) exports from OTBIWhen exporting reports in XLSX format from OTBI analyses or dashboards, the output is capped at 75000 rows and cuts off at this point. Our customers need to be able to e…
-
1Ability to upload .xlsm (macro enabled excel) file in EPM CloudBusinesses extensively utilize Macro enabled Excel (.xlsm) for ad-hoc reporting. Integrating Excel with SmartView functionalities addresses numerous ad-hoc reporting req…Shivangini Kotiyal 33 views 0 comments 1 point Started by Shivangini Kotiyal Oracle Analytics Cloud and Server Idea Lab
-
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
-
6OAS - Visible Export Button for Excel DownloadFor our customers it is important to easily download tables or Pivot tables from canvas to Excel. Instead of searching the several download functionalities via the "thre…Dr. Christopher Cullmann 21 views 1 comment 6 points Most recent by Benjamin Arnulf-Oracle Oracle Analytics Cloud and Server Idea Lab
-
12Export All Workbook Canvases to ExcelCurrently you can only export a visualization to Excel. We want to be able to export all canvases on a workbook to Excel so each canvas is displayed in a separate Excel …Molly P 32 views 1 comment 12 points Most recent by User_P2G94 Oracle Analytics Cloud and Server Idea Lab
-
Excel is not considering my date value as date even after I tried many formatting? Need suggestionI am creating a XML publisher report where the date in the excel output should be in 'MM/DD/YYYY' format. Here I am able to achieve this format in excel however my excel…
-
3Ability to limit Export optionsWe have a need for being able to limit the Export As options from a Report. We would like to have Export → Formatted → , but not have Export →Data. I can see other varia…Shannon in MT 11 views 2 comments 3 points Most recent by Shannon in MT Oracle Transactional Business Intelligence Idea Lab