obiee .csv export issue

Mahak

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.

[Deleted User]

1.) Which exact version?

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

Mahak

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.

[Deleted User]

You're in luck. Your version also contains this. Check MOS Doc ID 2181784.1

and

https://docs.oracle.com/middleware/12213/biee/BIESG/GUID-FF6954BA-2DE0-4422-BA58-05F32936F4FF.htm#BIESG9196

[Deleted User]

@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?

Mahak

It worked Christian, testing in higher environments.