Popular Tags
- Reporting 1,315
- OTBI 1,260
- Analysis and Data Visualization 831
- BI Publisher 719
- FDI 706
- Analysis 631
- Administration 523
- Oracle Fusion Analytics 490
- OBIEE 398
- BI Publisher Data Models 297
- Answers 255
- Analyses 248
- Developers 231
- Analytics 229
- Security 219
- Data Connectivity 202
- Data Modelling and Datasets 197
- HCM 194
- ERP Analytics Content 177
- OAC 174
- Report Output 167
- BIP 166
- BI Publisher Report Templates 154
- Agents 148
- Customizing Reports 129
Excel
Discussion List
-
38Remove 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…
-
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…
-
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 21 views 0 comments 1 point Started by Shivangini Kotiyal Oracle Analytics Cloud and Server Idea Lab
-
2Show 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 12 views 1 comment 2 points Most recent by Benjamin Arnulf-Oracle Oracle Analytics Cloud and Server Idea Lab
-
3OAS - 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 3 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 12 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…Thanigainathan R 906 views 4 comments 0 points Most recent by Tejas GN Oracle Fusion Data Intelligence
-
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 29 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 62 views 7 comments 0 points Most recent by Kevin M Storrie Oracle Business Intelligence Applications
-
19Warn 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 180 views 3 comments 19 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 258 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 52 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 11 views 0 comments 2 points Started by Chet Mistry Oracle Transactional Business Intelligence Idea Lab
-
Is it possible to access subledger data via Smart View?I would like to know if Smart View is able to pull subledger data directly from ERP without having to drilldown the GL. Any documentation would be helpful.Luis Orihuela 58 views 2 comments 0 points Most recent by Luis Orihuela Oracle Analytics Cloud and Server
-
1Allow Exporting reports in excel format. Very IMPORTANTAllow Exporting reports in excel format, users sometimes prefer having the report in excel so they further analyse it or use it for other purposesEmilia N Sh 11 views 0 comments 1 point Started by Emilia N Sh Oracle Analytics Cloud and Server Idea Lab
-
Export data from FAW to ExcelHello, Is it possible to export data from FAW to Excel for use in another application? Is there any internal feature available for this purpose? If not, what would be th…Enio Lacerda 187 views 7 comments 0 points Most recent by Krithika Raghavan-Oracle Oracle Fusion Data Intelligence