Popular Tags
- OTBI 1,450
- Reporting 1,395
- FDI 1,130
- Analysis and Data Visualization 988
- BI Publisher 858
- Analysis 682
- Oracle Fusion Analytics 593
- Administration 555
- OAC 467
- OBIEE 433
- Analytics 404
- BI Publisher Data Models 358
- Security 295
- HCM 270
- BIP 265
- Answers 264
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Data Connectivity 210
- ERP Analytics Content 210
- BI Publisher Report Templates 205
- Oracle Analytics Cloud 202
- Fusion Data Intelligence 193
- Report Output 184
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Excel
Discussion List
-
Add Expand - Collapse option in Excel TemplatesHello, We currently have a requirement to add an expand/collapse feature within a report's output. We plan to use an Excel Template to design the report's layout. I woul… -
15Export 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 49 views 2 comments 15 points Most recent by User_T2IIN Oracle Analytics Cloud and Server Idea Lab
-
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 549 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 13 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 20 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 330 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 5 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 13 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 46 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 551 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 38 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 18 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 24 views 1 comment 6 points Most recent by Benjamin Arnulf-Oracle 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…