Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 54 Oracle Analytics and AI Sharing Center
- 26 Oracle Analytics and AI Lounge
- 311 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.7K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 117 Oracle Analytics and AI Trainings
- 24 Oracle Analytics and AI 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