Export of Pivot table
S2O2Jan 13 2010 — edited Jan 18 2010Hi everyone,
I have a pivot table in OBIEE 10.1.3.4.1 which has the following structure:
Day Week Year
Field1 Field 2 Field1 Field 2 Field1 Field2
Branch 1 1.1 2.1 9.2 15.2 711.2 451.1
Branch 2 9.1 3.5 25.6 19.1 982.1 872.2
exporting this pivot table to an Excel file works fine and has the same structure as the pivot table in Answers.
If I am going to export the pivot table to an CSV file the result will be in the following way:
Day Field1 Branch1 1.1
Day Field2 Branch1 2.1
Day Field1 Branch2 9.1
Day Field2 Branch2 3.5
..
...
How can I get an CSV export which looks the same as the orginal pivot table?
Thanks.