Popular Tags
- OTBI 1,364
- Reporting 1,352
- Analysis and Data Visualization 898
- FDI 883
- BI Publisher 788
- Analysis 654
- Administration 542
- Oracle Fusion Analytics 535
- OBIEE 415
- BI Publisher Data Models 323
- Analytics 309
- OAC 270
- Answers 259
- Security 253
- Analyses 251
- Developers 234
- HCM 219
- BIP 213
- Data Modelling and Datasets 208
- Data Connectivity 205
- ERP Analytics Content 192
- Report Output 179
- BI Publisher Report Templates 178
- Agents 148
- Customizing Reports 141
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Excel
Discussion List
-
4Ability 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… -
2Request 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 12 views 0 comments 2 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 464 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…
-
47Remove 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 22 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 -
4OAS - 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 4 points Most recent by Benjamin Arnulf-Oracle Oracle Analytics Cloud and Server Idea Lab
-
11Export 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 31 views 1 comment 11 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…
-
2Ability 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 2 points Most recent by Shannon in MT Oracle Transactional Business Intelligence Idea Lab
-
BI Report Output - How to get more than 65k rows in single tab in excel sheetWe have a requirement to get all the data in single sheet in a excel output more than 65k rows. Currently if the data more than 65k then data showing in next sheet. We t…
-
6Generating .xlsx Output in BI Publisher with Excel TemplatesHi Team, currently .xlsx Output is supported only with RTF Templates in BI Publisher but we have requirement for Generating .xlsx Output in BI Publisher with Excel Templ…User_K1Q89 31 views 0 comments 6 points Started by User_K1Q89 Oracle Analytics Cloud and Server Idea Lab
-
8Email Workbook as Excel AttachmentCurrently, it is not supported to email a workbook. One of the following options is a need for our company for exporting and sharing workbooks: 1. Be able to select Exce…Molly P 31 views 4 comments 8 points Most recent by Gabby Rubin-Oracle Oracle Analytics Cloud and Server Idea Lab
-
No option to output format in excel 2007+ .xlsxHello! From my online research online (I'm not an MS history expert) - "XLS and XLSX extensions represent popular Excel file formats that were introduced by Microsoft as…Kevin M Storrie 61 views 7 comments 0 points Most recent by Kevin M Storrie Oracle Business Intelligence Applications
-
20Warn 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 219 views 3 comments 20 points Most recent by Benjamin Arnulf-Oracle Oracle Analytics Cloud and Server Idea Lab
-
2OAC export Excel for mobile devicesNow we have the export option in Oracle DV using the right click over a data table, but in a mobile device like tablet, Ipad, cellphone, it's not possible that action. W…User_FGIQG 11 views 0 comments 2 points Started by User_FGIQG Oracle Analytics Cloud and Server Idea Lab
-
Disable Wrap Text in the excel output generated using RTF templateHi, I am creating a RTF based report using BI publisher, and the default output is Excel. But the output in excel is generating with wrap text. How can i disable the wra…Sukanya Mukherjee 440 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher
-
Excel compatibility with Oracle BI?We are using the version of Excel 1997, which is too old and is only capable of threat with 65,000 lines. Which other versions of Excel are compatible with Oracle BI Clo…User_80RQ8 51 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Oracle Transactional Business Intelligence
-
2Excel Exports - Large Amounts of Data - Non csvSR 3-35451755611 : OBIEE 11g - Error while exporting report into excel. *** This applies to 12c also *** The current guidance in New Features and Recommendations for Wor…Chet Mistry 12 views 0 comments 2 points Started by Chet Mistry Oracle Transactional Business Intelligence Idea Lab