Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 238 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
obiee .csv export issue
Hi All,
I have data like 1-9 . 20-1 11-6 which should be same when i export to .csv from an analysis, but after exporting i see the data as 1-Jan,20-Jan, 11-Jun which should not be the case.
Can any one help me out how to make sure the Analysis export to .csv should remain same as the results we see on obiee.
Help is appreciated.
Thanks.
Answers
-
2.) Do you see this when opening the csv with Excel or just with Notepad. Never underestimate how much Excel is trying to be too "clever" for its own good.
3.) If you are on one of the newest 12c releases you may want to read up on <DataValue>UseFormattedValue</DataValue> in the instanceconfig
0 -
1) Version of OBIEE we are using is 11.1.1.9.160719
2) I see this happening while opening csv in excel only, in notepad it looks perfect.
0 -
You're in luck. Your version also contains this. Check MOS Doc ID 2181784.1
and
0 -
@Mahak so did it work? Is the issue resolved?
If yes please close the question so that other forum users can also benefit from it?
0 -
It worked Christian, testing in higher environments.
0