Popular Tags
- OTBI 1,482
- Reporting 1,408
- FDI 1,216
- Fusion AI Data Platform 1,043
- Analysis and Data Visualization 1,011
- BI Publisher 879
- Analysis 691
- Oracle Fusion Analytics 618
- Administration 556
- OAC 548
- OBIEE 437
- Fusion HCM Analytics 428
- Analytics 427
- Fusion ERP Analytics 413
- BI Publisher Data Models 362
- Security 303
- HCM 287
- BIP 268
- Answers 266
- Analyses 256
- Oracle Analytics Cloud 255
- Developers 248
- Data Modelling and Datasets 235
- Fusion Data Intelligence 219
- ERP Analytics Content 217
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Excel
Discussion List
-
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 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 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…User_90781 63 views 2 comments 0 points Most recent by Nehemias-Oracle Oracle Analytics Publisher Forum -
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 22 views 2 comments 3 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 2.3K views 4 comments 0 points Most recent by Tejas GN Oracle Analytics Publisher Forum
-
8Generating .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…
-
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…
-
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 154 views 7 comments 0 points Most recent by Kevin M Storrie Oracle Business Intelligence Applications Forum
-
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…
-
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 739 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Forum
-
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 Forum
-
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 Most recent 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.
-
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 purposes
-
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 281 views 7 comments 0 points Most recent by Krithika Raghavan-Oracle Oracle Fusion AI Data Platform Forum
-
11OTBI Analysis - need ability to increase limit on Excel and CSV exportsCurrently the limit when exporting data as excel or CSV is 75,000 lines. When analysing several months of data, this is not enough, and means that we have to limit OTBI …Carol440 33 views 2 comments 11 points Most recent by Clare Murtagh Oracle Transactional Business Intelligence Idea Lab
-
Show Parent Data in Excel TemplateHi, everyone! This could be an easy/tricky question but, so far, I couldn't find a solution. I'm trying to build an Excel template. I need to display in a sheet all data…Andres De la Ossa-Oracle 32 views 0 comments 0 points Most recent by Andres De la Ossa-Oracle Oracle Transactional Business Intelligence Forum -
OBIEEwhen exporting thereport to excel it is onlydownloading 3573rows but my EM has the belowvalue.when exporting the report to CSV it is downloading the entire data.. it only happenswith excel..how can i get this resolved?
-
split string into columns using commaI have a string that contain the saleperson staff ID and their name. I am trying to split it into 2 column like in excel. 1 column for staffID and 1 column for Name. z32…
-
Dynamic columns in Excel TemplateHi all, Is there something simillar to "for-each@cell" in excel template? In order to make dynamic columns like i can do with rtf template but in this case with an excel…