Excel problem: Exported from OBIEE to Excel analysis adding time part to a date column
There is a date column used in OBIEE analysis. That column is declared as 'date' datatype in Oracle table, type in rpd is also 'DATE'. However, when exported to Excel, Excel is adding time values to the end of date part of this column. Here is a simple analysis:
The same analysis when exported into Excel:
As you can see, it is adding '5:00:00' to the end of '11.05.2022'. My guess is it is adding timezone values by default, which is the following in our OBIEE:
How can we prevent Excel from adding unnecessary values? Should we change settings in instanceconfig.xml file to use formatted value using 'UseFormattedValue' parameter? Or is there any simpler way to do this?
UseFormattedValue is the way to go because your problem isn't the Oracle side, but rather Microsoft trying to be "smart" in their interpretation in Excel. https://docs.oracle.com/middleware/bi12214/biee/BIESG/GUID-FF6954BA-2DE0-4422-BA58-05F32936F4FF.htm#BIESG9196
- Recognize and process quotation mark (")
- Enumerate all data in Excel range, count them and sort by occurrence
- Add headers to table based on values found in cells
- Table Stacking using VBA
- how to handle excel files using C++?
- sqlite3 or CSV files
- Match and list values to a dynamic list including multiple column criteria
- Match and list values to a list including mutliple column criteria
- Transpose Excel data for multi-Stacked bar chart
- Match and list values based on values listed in another column
- Use pandas to read excel files with wrong sheet state
- Display x-rows below a certain position from a filtered and sorted list
- Get the first and last number occuring in a (text) string in a cell
- Count the program-steps
- Using VSTACK to pile-up results
- Excel vba Login to the site
- How to get a string array in an Excel cell and use as a reference
- Excel's max function returning wrong value when using vlookup
- Excel list of values where data matches across multiple rows
- How to save Image independently in VBA module
- How to map table references in a JSON file to corresponding values in an Excel file using Python?
- Move values from column to rows in Excel
- Application.FileDialog vs GetOpenFilename: What is the difference?
- Only display the values in a certain rank position from filtered and sorted list
- Convert table to reflect column names as row values
- Excel: Dynamic stacking or arrays n-number of times
- Convert Excel formula to Power Query (if countifs)
- Trying to hide rows in excel based on two values
- Combine every unique value from column A with duplicated values into a new sheet
- Import formula from variable - Excel VBA